Reset incarnation Failed - ORA-19507

[goodhealth]

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

[sambavan]

There are a number of flaws in your script. Where do you allocate channels d1 .. d3. You would onlu want to release the channel that you allocated i.e. t1 .. t2


Follow the documentation for more details.

http://www.oradoc.com/ora817/server....eco.htm#439096

Sam