Data Backup and Recovery

Help restoring Oracle 11G database from a SC backup

michaeldparker
204,419 Views

Hi,

So, last week we fought through our ignorance and figured out how to configure SC to backup our Oracle DB.  Now my DBA is attempting to open an SC backup in Oracle to test the backup.  When he does his recovery steps, he's getting this output:

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 237775255263 generated at 12/17/2012 09:30:02 needed for thread 1

ORA-00289: suggestion : +AGILE_ARCH1

ORA-00280: change 237775255263 for thread 1 is in sequence #197029

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '+AGILE_ARCH1'

ORA-17503: ksfdopn:2 Failed to open file +AGILE_ARCH1

ORA-15045: ASM file name '+AGILE_ARCH1' is not in reference form

ORA-10879: error signaled in parallel recovery slave

Any suggestion on what is going on?  We have 3 ASM volumes: ctrl, data, and arch.  Using SC, we are snapping those 3 volumes just like we do for our SMO backup.  I think he is attempting to use the ctrl file in the ctrl volume.

Thanks

Michael

11 REPLIES 11
Public