This content has been marked as final. Show 10 replies
Your backup that you are trying to use is no good.
You need to perform a new backup and start over.
Just do a Full backup. Don't mess around with an incremental .
Or create the new database from an active duplicate.
When all else fails try something new :
h3. How to Duplicate a Standalone Database: ASM to ASM
Generally your error is bad news. If the database copy starts without error it starts.
Hopefully you have a way to measure a good restore if it starts without error. An enter date or some data like that.
When I see that error I'm think do over because signs point to the data files no all being on the same SCN.
hi, here is updates. I figured out the reason I got the issue.
I just re-did another duplicate and it ended with same errors. In order to prevent this in next duplication, I need your advice on this.
I found out the errors happens when archivelog seq#3906/5716 comesup:
archived log file name=+FRA/tst/archivelog/2012_11_15/thread_2_seq_3906.2225.799428195 thread=2 sequence=3906
archived log file name=+FRA/tst/archivelog/2012_11_15/thread_1_seq_5716.2223.799428195 thread=1 sequence=5716
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DAT/tst/datafile/system.432.799418497'
In the incremental backup log, you will find out those two archivelogs did not delet due to not been applied to standby:
archived log file name=+FRA/prds/archivelog/2012_11_14/thread_1_seq_5714.2836.799328615 RECID=1284 STAMP=799328617
archived log file name=+FRA/prds/archivelog/2012_11_14/thread_2_seq_3904.2835.799330067 RECID=1285 STAMP=799330068
archived log file name=+FRA/prds/archivelog/2012_11_14/thread_1_seq_5715.2837.799333241 RECID=1286 STAMP=799333242
RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
archived log file name=+FRA/prds/archivelog/2012_11_14/thread_2_seq_3905.2838.799333747 thread=2 sequence=3905
Finished backup at 14-NOV-12
I wonder how do I be sure those two archvielogs be backed up? And not cause issues?