This content has been marked as final. Show 10 replies
Your backup that you are trying to use is no good.1 person found this helpful
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
RMAN duplication log shows restore finished without error, is that mean backup sets are working?
I think it might missing some archivelogs.
but googled internet, could not find a solid answer.
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.
ok, I will redo a backup. WIll keep you updated.
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?
You can try this :
recover database until cancel using backup controlfile; /*Then enter "auto"*/ auto alter database open resetlogs;
But I am using duplicate database to TargetID
Here's my supporting document :
While Duplicating the Database ,Rman Errors ora-1547,ora-1152,ora-1110 During Recovery [ID 274118.1]
You are right. Thanks.