-
I am testing restore until time on a database from a hot backup. Once the successful 1st restore, I want to restore from an old backup, so I used reset database incarnation to that number. However I keep getting ORA-19507error as below. Before resetting db, I also did recover database until cancel and alter database open resetlogs. Did I miss anything else.
begin database restore and recovery
${ORACLE_HOME}/bin/$RMAN target / rcvcat rman/rman@rcat cmdfile "$CMDFILE"
Recovery Manager: Release 8.1.7.0.0 - Production
RMAN-06006: connected to target database: TEST (not mounted)
RMAN-06008: connected to recovery catalog database
RMAN> run {
2> # Restore all datafiles, and recovers them completely.
3> allocate channel t1 type 'SBT_TAPE' ;
4> allocate channel t2 type 'SBT_TAPE';
5> restore controlfile to '/u02/oradata/TEST/control01.ctl';
6> restore controlfile to '/u03/oradata/TEST/control02.ctl';
7> restore controlfile to '/u04/oradata/TEST/control03.ctl';
8> sql "alter database mount";
9> restore database
10> until time "to_date('Aug 30 2001 12:00:00','Mon DD YYYY HH24:MI:SS')";
11> recover database
12> until time "to_date('Aug 30 2001 11:55:00','Mon DD YYYY HH24:MI:SS')";
13> sql "alter database open resetlogs";
14> release channel d1;
15> release channel d2;
16> release channel d3;
17> }
18>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=10 devtype=SBT_TAPE
RMAN-08526: channel t1: VERITAS NetBackup for Oracle8 - Release 3.2GA
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=11 devtype=SBT_TAPE
RMAN-08526: channel t2: VERITAS NetBackup for Oracle8 - Release 3.2GA
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=121 set_stamp=439118532 creation_time=30-AUG-01
RMAN-08021: channel t1: restoring controlfile
RMAN-08505: output filename=/u02/oradata/TEST/control01.ctl
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential file
, handle="bk_121_1_439118532", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: sbtrestore: Backup file not found.
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIE
CE
goodhealth
-
closing this thread since there is a previous one about this matter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|