![]() ![]() ORA-01152: file 1 was not restored from a sufficiently old backup RMAN-03002: failure of sql statement command at 20:34:49 RMAN-06556: datafile 1 must be restored from backup older than SCN 7441809 RMAN-03002: failure of recover command at 20:33:06 Select 'L', group#, first_change#, status from V$log order by 1,3,2 Īllocate channel c0 device type sbt parms="SBT_LIBRARY=/opt/commvault/Base/libobk.so,BLKSIZE=1048576" Select 'D' file_type, file#, checkpoint_change#, status from V$datafile_header SQL> select CHECKPOINT_CHANGE# from v$datafile_header So, I tried to find out what SCN I can use to recover: RMAN-06556: datafile 1 must be restored from backup older than SCN 7460264 RMAN-03002: failure of recover command at 20:29:06 RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = You can see below error:Īllocate channel c0 device type sbt parms="SBT_LIBRARY=/u01/tivoli/Base/libobk.so,BLKSIZE=1048576" Ĭhannel c0: CommVault Systems for Oracle: Version 11.0.0(BUILD80) In this scenario, I am facing with until SCN. Using SCN or using LOG Sequence or using UNTIL time you can recover the database. There are many ways to solve this issues. ![]() Sample Restore and Recover scenario in Oracle using RMAN:Īfter restoring database, when I tried to recover database, found "RMAN-06556: datafile 1 must be restored from backup." error which is common in most of the recover scenarios. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |