-
hi all,
I am on OPS and aix 4.3, 8.1.6, tsm. I have taken a backup, fine. I have restored it, fine. Now I want to recover but it fails with the error stack below. But the log "11205" that RMAN complains about was backed up. My backup log shows it.
Secondly I have run a "list archivelog all" and it is in the catalog.
Here is the output from the catalog.
Seq Low SCN Next SCN Low Time Next Time
------- ---------- ---------- --------------- --------------
11205 1658164724 1658175224 Jan 29 2002 23:55:26 Jan 30 2002 00:20:22
it looks like it was generation started on the 29th and was completed on the 30th. Is this the problem? How do I solve it. take a look at my script.
run
{
allocate channel t1 type 'sbt_tape' connect internal/XXXX@XXXXX;
allocate channel t2 type 'sbt_tape' connect internal/XXXX@XXXXX;
backup full
format 's80_d%d_s%s'
(database);
backup current controlfile;
sql 'alter system switch logfile';
sql 'alter system archive log current';
backup
format 's80_d%d_arch_s%s'
(archivelog
from time 'SYSDATE-2'
thread 1
channel t1);
backup
format 's80_d%d_arch_s%s'
(archivelog
from time 'SYSDATE-2'
thread 2
channel t2);
release channel t1;
release channel t2;
}
RMAN-08024: channel t2: restore complete
RMAN-08060: unable to find archivelog
RMAN-08510: archivelog thread=2 sequence=11205
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: 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-06003: ORACLE error from target database: ORA-19634: filename required for
this function
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 1959
ORA-06512: at line 1
Thanks so much
-
Try to execute this and after run "list archivelog all" command. Will you see your log?
allocate channel for maintenance type 'sb_tape';
crosscheck backup;
change archivelog all crosscheck;
change archivelog all vaildate;
crosscheck backup of archivelog all;
release channel;
-
