I am an IT professional with 10 years of professional experience,I have good proficiency on Oracle technologies, and at last 2 years of my career to study Real Application Clusters,data guard and participate actively on Oracle community ,If you want to hire me on Contract or to quote on project basis contact me at khurrampc@hotmail.com.

Tuesday, October 7, 2008

RMAN-06025: no backup of log thread 1 seq

RMAN> run
2> {
3> RESTORE VALIDATE CHECK LOGICAL  ARCHIVELOG ALL;
4> }

Starting restore at 08-OCT-08
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/08/2008 11:40:16
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 31 lowscn 374582 found to restore
RMAN-06025: no backup of log thread 1 seq 30 lowscn 374398 found to restore
RMAN-06025: no backup of log thread 1 seq 29 lowscn 374337 found to restore
RMAN-06025: no backup of log thread 1 seq 28 lowscn 374159 found to restore
RMAN-06025: no backup of log thread 1 seq 27 lowscn 374073 found to restore
RMAN-06025: no backup of log thread 1 seq 26 lowscn 373814 found to restore
RMAN-06025: no backup of log thread 1 seq 25 lowscn 373756 found to restore
RMAN-06025: no backup of log thread 1 seq 24 lowscn 373318 found to restore
RMAN-06025: no backup of log thread 1 seq 23 lowscn 373184 found to restore
RMAN-06025: no backup of log thread 1 seq 22 lowscn 373004 found to restore
RMAN-06025: no backup of log thread 1 seq 21 lowscn 372946 found to restore
RMAN-06025: no backup of log thread 1 seq 20 lowscn 371604 found to restore
RMAN-06025: no backup of log thread 1 seq 19 lowscn 371598 found to restore
RMAN-06025: no backup of log thread 1 seq 18 lowscn 371198 found to restore
RMAN-06025: no backup of log thread 1 seq 17 lowscn 351033 found to restore
RMAN-06025: no backup of log thread 1 seq 16 lowscn 330912 found to restore
RMAN-06025: no backup of log thread 1 seq 15 lowscn 330901 found to restore
RMAN-06025: no backup of log thread 1 seq 14 lowscn 330754 found to restore
RMAN-06025: no backup of log thread 1 seq 13 lowscn 330749 found to restore
RMAN-06025: no backup of log thread 1 seq 12 lowscn 330449 found to restore
RMAN-06025: no backup of log thread 1 seq 11 lowscn 330444 found to restore
RMAN-06025: no backup of log thread 1 seq 10 lowscn 330119 found to restore
RMAN-06025: no backup of log thread 1 seq 9 lowscn 330114 found to restore
RMAN-06025: no backup of log thread 1 seq 8 lowscn 330052 found to restore
RMAN-06025: no backup of log thread 1 seq 7 lowscn 330046 found to restore
RMAN-06025: no backup of log thread 1 seq 6 lowscn 329222 found to restore

SQL> select sequence# from v$archived_log
  2  /


 SEQUENCE# S
---------- -
         6 D
         7 D
         8 D
         9 D
        10 D
        11 D
        12 D
        13 D
        14 D
        15 D
        16 D
        17 D
        18 D
        19 D
        20 D
        21 D
        22 D
        23 D
        24 D
        25 D
        26 D
        27 D
        28 D
        29 D
        30 D
        31 D
        32 A
        33 A
        34 A
        35 A

30 rows selected.
As you can see log sequence 6 to 31 either deleted by RMAN or deleted by OS and then crosschecked or these logs never backed up but deleted by OS and then crosschecked.Restore archivelog all will try to restore all archivelogs that are within repository (i.e controlfile). As you never backed up log sequence 6 to 31 but RMAN will try to restore those log sequence.
Workaround 1
RMAN> list archivelog all
2> ;


List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
27      1    32      A 07-OCT-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_07\O1_MF_1_32_4GQB1ZSD_.ARC
28      1    33      A 07-OCT-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_07\O1_MF_1_33_4GQB51GN_.ARC
29      1    34      A 07-OCT-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_08\O1_MF_1_34_4GRCZ11G_.ARC
30      1    35      A 08-OCT-08 C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_08\O1_MF_1_35_4GRM3Y0Z_.ARC


RMAN> run
2> {
3> RESTORE VALIDATE CHECK LOGICAL  ARCHIVELOG from sequence 32;
4> }

Starting restore at 08-OCT-08
using channel ORA_DISK_1

channel ORA_DISK_1: scanning archive log C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_07\O1_MF_1_32_4GQB1ZSD_.ARC
channel ORA_DISK_1: scanning archive log C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_07\O1_MF_1_33_4GQB51GN_.ARC
channel ORA_DISK_1: scanning archive log C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_08\O1_MF_1_34_4GRCZ11G_.ARC
channel ORA_DISK_1: scanning archive log C:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\POP\ARCHIVELOG\2008_10_08\O1_MF_1_35_4GRM3Y0Z_.ARC
Finished restore at 08-OCT-08
Workaround 2
You can go with recvoery catalog for detail see metalink note 235973.1

2 comments:

Unknown said...

Thanks. This helped me a lot.

daspeac said...

I have heard about another way of microsft outlook backup. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.

Followers

About Me

My photo
Melbourne, Victoria, Australia