RMAN-06025: no backup of log thread 1 seq ...
Hi,
I have a database testdb for which i took backups on tape drive. Then i performed a cancel based recovery for testing purposes and opened myd atabase with reset logs option. Then i took a fresh backup of my database on tape and also fresh backup of archive logs on the tape. I also used delete input for archived redo logs when i took backup; Please see bellow the result of my reporting commands.
RMAN> run{
2> allocate channel c1 type 'sbt_tape';
3> crosscheck backup;
4> }
allocated channel: c1
channel c1: sid=147 devtype=SBT_TAPE
channel c1: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0gk8d78v_1_1 recid=14 stamp=679910688
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=0ik8d9ni_1_1 recid=16 stamp=679913203
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=c-2463099035-20090227-01 recid=17 stamp=679913449
Crosschecked 3 objects
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14 Full 540.50M SBT_TAPE 00:37:51 27-FEB-09
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20090227T080447
Handle: 0gk8d78v_1_1 Media:
List of Datafiles in backup set 14
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 532683 27-FEB-09 /dwdata/oracle/oradata/testdb/system01.dbf
2 Full 532683 27-FEB-09 /dwdata/oracle/oradata/testdb/undotbs01.dbf
3 Full 532683 27-FEB-09 /dwdata/oracle/oradata/testdb/sysaux01.dbf
4 Full 532683 27-FEB-09 /dwdata/oracle/oradata/testdb/users01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
16 20.50M SBT_TAPE 00:03:56 27-FEB-09
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20090227T084642
Handle: 0ik8d9ni_1_1 Media:
List of Archived Logs in backup set 16
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 5 506182 26-FEB-09 506423 26-FEB-09
1 6 506423 26-FEB-09 506425 26-FEB-09
1 7 506425 26-FEB-09 506446 26-FEB-09
1 8 506446 26-FEB-09 506667 26-FEB-09
1 9 506667 26-FEB-09 506768 26-FEB-09
1 10 506768 26-FEB-09 533628 27-FEB-09
1 11 533628 27-FEB-09 533630 27-FEB-09
1 12 533630 27-FEB-09 533634 27-FEB-09
1 13 533634 27-FEB-09 533636 27-FEB-09
1 14 533636 27-FEB-09 533638 27-FEB-09
1 15 533638 27-FEB-09 533641 27-FEB-09
1 16 533641 27-FEB-09 533658 27-FEB-09
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17 Full 7.25M SBT_TAPE 00:00:59 27-FEB-09
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20090227T085049
Handle: c-2463099035-20090227-01 Media:
Control File Included: Ckp SCN: 533747 Ckp time: 27-FEB-09
SPFILE Included: Modification time: 26-FEB-09
Now i want to restore all archive logs and i issue following statement and you can see the error messages.
RMAN> run{
2> allocate channel c type 'sbt_tape';
3> restore archivelog all;
4> }
allocated channel: c
channel c: sid=147 devtype=SBT_TAPE
channel c: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)
Starting restore at 27-FEB-09
released channel: c
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/27/2009 09:54:25
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 4 lowscn 506180 found to restore
RMAN-06025: no backup of log thread 1 seq 3 lowscn 506176 found to restore
RMAN-06025: no backup of log thread 1 seq 2 lowscn 506174 found to restore
RMAN-06025: no backup of log thread 1 seq 1 lowscn 505956 found to restore
RMAN-06025: no backup of log thread 1 seq 30 lowscn 505931 found to restore
RMAN-06025: no backup of log thread 1 seq 29 lowscn 505929 found to restore
RMAN-06025: no backup of log thread 1 seq 28 lowscn 505927 found to restore
RMAN-06025: no backup of log thread 1 seq 27 lowscn 505924 found to restore
RMAN-06025: no backup of log thread 1 seq 26 lowscn 505922 found to restore
RMAN-06025: no backup of log thread 1 seq 25 lowscn 499372 found to restore
RMAN-06025: no backup of log thread 1 seq 24 lowscn 489463 found to restore
Seq 24 - 30 belong to old incarnation of the database as i told you that i performed an incomplete recovery of my database.
Seq 1 - 4 are deleted from the disk when i took backup of my database using "delete input" option for my archived log backups.
My question is, why it is checking for these un available archvied redol logs for restoration? i have done cross check and have also delete all obsolete backups, then why it is behaving like this? any idea and how to resolve this? It is also amaizing that it is trying tor estore archives from old incarnation number.
Thanks
Salman