ADSM-L

Error when restore database

2004-04-21 23:15:55
Subject: Error when restore database
From: nghiatd <nghiatd2 AT FPT.COM DOT VN>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 22 Apr 2004 10:15:48 +0700
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

<Prev in Thread] Current Thread [Next in Thread>
  • Error when restore database, nghiatd <=