Re: recover standby database failure

The recover command would have started with the first archivelog generated after the first datafile backup began.
If your database backup is supposed to have begun in, say, the fourth or fifth archivelog and the recover command isn't even attempting them but going straight to the 9th archivelog, you must likely have a database copy that is NOT in hot backup mode.

Hemant K Chitale

At 04:43 AM Thursday, Michael Mitchell wrote:
>I'm trying to build a physical standby server and have been following
>an article I found at 'http://www.dbasupport.com/oracle/ora10g/
>manual_standby.shtml'.
>Everything is great until I execute the recover command.
>
><deleted>
>- There are 7 archive files in the standby's archivelog directory
>(arch2 - arch8) but the recover command keeps looking for the 8th
>arch file which doesn't exist on the primary.
>
>Here's the full transcript from command.
>
>Mike
>
>
>SQL> recover standby database;
>ORA-00279: change 583284 generated at 05/14/2008 12:25:44 needed for
>thread 1
>ORA-00289: suggestion :
>/home/oracle/standby/archivelog/ETP10GSE/archivelog/2008_05_14/
>o1_mf_1_9_%u_.arc
>ORA-00280: change 583284 for thread 1 is in sequence #9
>
>
>Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
>AUTO
>ORA-00308: cannot open archived log
>'/home/oracle/standby/archivelog/ETP10GSE/archivelog/2008_05_14/
>o1_mf_1_9_%u_.ar
>c'
>ORA-27037: unable to obtain file status
>Linux Error: 2: No such file or directory
>Additional information: 3
>
>
>ORA-00308: cannot open archived log
>'/home/oracle/standby/archivelog/ETP10GSE/archivelog/2008_05_14/
>o1_mf_1_9_%u_.ar
>c'
>ORA-27037: unable to obtain file status
>Linux Error: 2: No such file or directory
>Additional information: 3
>
>
>ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get
>error below
>ORA-01195: online backup of file 1 needs more recovery to be consistent
>ORA-01110: data file 1: '/home/oracle/standby/system01.dbf'
>
>
>SQL>
Hemant K Chitale
http://hemantoracledba.blogspot.com

"A 'No' uttered from the deepest conviction is better than a 'Yes' merely uttered to please, or worse, to avoid trouble." Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

--
http://www.freelists.org/webpage/oracle-l