Re: recover standby database failure
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: mike.mitchell@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 May 2008 22:36:15 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
