Hi,
I did a little simulation. I deleted all control files from the disk and tried to recover using backed up controlfiles.
This is what I get. I just hit <RET> to use the suggestion.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1186233 generated at 01/09/2012 01:35:02 needed for thread 1
ORA-00289: suggestion : +RECOV
ORA-00280: change 1186233 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log '+RECOV'
ORA-17503: ksfdopn:2 Failed to open file +RECOV
ORA-15045: ASM file name '+RECOV' is not in reference form
Then I tried to be more specific. I entered a log file name, but I wasn't sure if it's the required one.
SQL> recover database using backup controlfile;
ORA-00279: change 1186233 generated at 01/09/2012 01:35:02 needed for thread 1
ORA-00289: suggestion : +RECOV
ORA-00280: change 1186233 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
*+recov/ora11g/archivelog/2012_01_08/thread_1_seq_32.352.772065105*
ORA-00342: archived log does not have expected resetlogs SCN 1175813
ORA-00334: archived log:
'+RECOV/ora11g/archivelog/2012_01_08/thread_1_seq_32.352.772065105'
So, my question is, How do we know which log to specify. Which log contains SCN 1175813 ?
My archive log list and online log list are as follows,
ASMCMD> cd ../2012_01_08
ASMCMD> ls
thread_1_seq_10.399.772002829
thread_1_seq_11.400.772002831
thread_1_seq_12.401.772002831
thread_1_seq_13.402.772002835
thread_1_seq_14.403.772002837
thread_1_seq_15.404.772002981
thread_1_seq_16.405.772002985
thread_1_seq_17.406.772002987
thread_1_seq_18.407.772002987
thread_1_seq_19.408.772002991
thread_1_seq_20.411.772006353
thread_1_seq_21.412.772006367
thread_1_seq_22.413.772006401
thread_1_seq_23.414.772006421
thread_1_seq_24.416.772009165
thread_1_seq_25.409.772009703
thread_1_seq_26.382.772009931
thread_1_seq_27.373.772010387
thread_1_seq_28.369.772034721
thread_1_seq_29.363.772046209
thread_1_seq_3.392.771996663
thread_1_seq_30.362.772046585
thread_1_seq_31.359.772048557
thread_1_seq_32.352.772065105
thread_1_seq_4.393.772002391
thread_1_seq_5.394.772002457
thread_1_seq_6.395.772002669
thread_1_seq_7.396.772002685
thread_1_seq_8.397.772002699
thread_1_seq_9.398.772002825
ASMCMD>
ASMCMD> pwd
+data2/ora11g/onlinelog
ASMCMD> ls
group_1.257.771952803
group_1.265.772065125
group_2.258.772065137
group_3.259.772065149
Thanks and Regards,
Sajeeva Lakmal
Edited by: Sajeeva Lakmal on Jan 12, 2012 6:48 AM
Edited by: Sajeeva Lakmal on Jan 12, 2012 6:59 AM