Hi all,
I use RMAN and TDP for backup and restore database.
Before I run script, l run "list backup of archivelog all " and "list backup" command.
I got following information:
RMAN> list backup of archivelog all;
RMAN-03022: compiling command: list
RMAN-03025: performing implicit partial resync of recovery catalog
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
3961 15 524081063 0 524081062 18 21-APR-04
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
3962 1 1 AVAILABLE 21-APR-04 0ifjplt6_1_1
List of Archived Logs Included
Thrd Seq Low SCN Next SCN Low Time Next Time
---- ------- ---------- ---------- --------------- ---------------
1 1 68396 68503 21-APR-04 21-APR-04
RMAN>list backup;
RMAN-03022: compiling command: list
List of Backup Sets
Key Recid Stamp LV Set Stamp Set Count Completion Time
------- ---------- ---------- -- ---------- ---------- ----------------------
3944 13 524081052 0 524081003 16 21-APR-04
List of Backup Pieces
Key Pc# Cp# Status Completion Time Piece Name
------- --- --- ----------- ---------------------- ------------------------
3945 1 1 AVAILABLE 21-APR-04 0gfjplrb_1_1
List of Datafiles Included
File Name LV Type Ckp SCN Ckp Time
---- ------------------------------------- -- ---- ---------- -------------
1 C:\ORACLE\ORADATA\NGHIATD\SYSTEM01.DBF 0 Full 68499 21-APR-04
2 C:\ORACLE\ORADATA\NGHIATD\RBS01.DBF 0 Full 68499 21-APR-04
3 C:\ORACLE\ORADATA\NGHIATD\USERS01.DBF 0 Full 68499 21-APR-04
4 C:\ORACLE\ORADATA\NGHIATD\TEMP01.DBF 0 Full 68499 21-APR-04
5 C:\ORACLE\ORADATA\NGHIATD\TOOLS01.DBF 0 Full 68499 21-APR-04
6 C:\ORACLE\ORADATA\NGHIATD\INDX01.DBF 0 Full 68499 21-APR-04
When I restore database following script, I got error message.
C:\>rman target internal/[EMAIL PROTECTED] catalog rman/[EMAIL PROTECTED]
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06005: connected to target database: NGHIATD (DBID=2816620961)
RMAN-06008: connected to recovery catalog database
RMAN> run
2> {
3> set until logseq = 1 thread = 1;
4> allocate channel t1 type 'sbt_tape';
5> restore database;
6> recover database;
7> alter database open resetlogs;
8> }
RMAN-03022: compiling command: set
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Then I run other script and got error message :
RMAN> run
2> {
3> allocate channel t1 type 'sbt_tape';
4> restore database;
5> recover database;
6> alter database open resetlogs;
7> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=13 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 5.2.0.0
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=16 set_stamp=524081003 creation_time=21-APR-04
RMAN-08089: channel t1: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to C:\ORACLE\ORADATA\NGHIATD\SYSTEM01.DBF
RMAN-08523: restoring datafile 00002 to C:\ORACLE\ORADATA\NGHIATD\RBS01.DBF
RMAN-08523: restoring datafile 00003 to C:\ORACLE\ORADATA\NGHIATD\USERS01.DBF
RMAN-08523: restoring datafile 00004 to C:\ORACLE\ORADATA\NGHIATD\TEMP01.DBF
RMAN-08523: restoring datafile 00005 to C:\ORACLE\ORADATA\NGHIATD\TOOLS01.DBF
RMAN-08523: restoring datafile 00006 to C:\ORACLE\ORADATA\NGHIATD\INDX01.DBF
RMAN-08023: channel t1: restored backup piece 1
RMAN-08511: piece handle=0gfjplrb_1_1 tag=FULL_ORACLE_BACKUP params=NULL
RMAN-08024: channel t1: restore complete
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
RMAN-03022: compiling command: recover
RMAN-03022: compiling command: recover(1)
RMAN-03023: executing command: partial resync
RMAN-03022: compiling command: recover(2)
RMAN-03022: compiling command: recover(3)
RMAN-03023: executing command: recover(3)
RMAN-08054: starting media recovery
RMAN-03022: compiling command: recover(4)
RMAN-06050: archivelog thread 1 sequence 1 is already on disk as file C:\ORACLE\
ORADATA\NGHIATD\ARCHIVE\ARC00001.001
RMAN-03023: executing command: recover(4)
RMAN-08515: archivelog filename=C:\ORACLE\ORADATA\NGHIATD\ARCHIVE\ARC00001.001 t
hread=1 sequence=1
RMAN-08060: unable to find archivelog
RMAN-08510: archivelog thread=1 sequence=2
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03006: non-retryable error occurred during execution of command: recover(4)
RMAN-07004: unhandled exception during command execution on channel default
RMAN-20000: abnormal termination of job step
RMAN-06054: media recovery requesting unknown log: thread 1 scn 68503
Does anyone know what the message means ?
Thanks in advanced,
Nghiatd
