RMAN Point in Time Recovery


D:\>rman catalog rman/rman
RMAN> connect target rman/rman ;
RMAN> register database ; (hanya sekali)
RMAN> @cold.sql

RMAN> run {execute script TSH1_daily_backup; }

RMAN-03021: executing script: TSH1_daily_backup

RMAN-03022: compiling command: shutdown
RMAN-06405: database closed
RMAN-06404: database dismounted
RMAN-06402: Oracle instance shut down

RMAN-03022: compiling command: startup
RMAN-06196: Oracle instance started
RMAN-06199: database mounted
RMAN-06400: database opened

Total System Global Area     461793308 bytes

Fixed Size                       75804 bytes
Variable Size                123006976 bytes
Database Buffers             338632704 bytes
Redo Buffers                     77824 bytes

RMAN-03022: compiling command: shutdown
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script TSH1_daily_backup
RMAN-03002: failure during compilation of command
RMAN-03013: command type: shutdown
RMAN-06004: ORACLE error from recovery catalog database: ORA-12571: TNS:packet w
riter failure
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . resetAll ; :succe
ss := dbms_rcvman . SUCCESS ; :av
RMAN-06099: error occurred in source file: krmk.pc, line: 9397

Referensi

  1. Recovery Manager (RMAN) in Oracle 8i, http://www.oracle-base.com/articles/8i/recovery-manager-8i.php

Comments