recover standby database failure

From: Michael Mitchell <mike.mitchell_at_etouchpoint.com>
Date: Wed, 14 May 2008 13:43:30 -0700
Message-Id: <43AB7FE8-8451-4182-A16D-CF514C553F3F@eTouchPoint.com>


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.

Here is the back ground info:
- Two Linux (Centos 5) servers

  • Oracle Standard Edition version 10.2.0g on both servers (we're young and poor :)
  • Both database servers were installed at the same time with the same values (SID etc...)
  • The primary database is configured for ARCHIVELOG
  • I've done a hot backup of all tablespaces in the database where the 'included_in_database_backup' value is set to 'YES' (select name from v$tablespace where included_in_database_backup = 'YES';)
  • I've built a standby controlfile
  • Set the conversion parameters in the standby servers pfile to point to the correct location for database (.dbf) archives (.arc) files

The problem occurs on the 'recover standby database' command where I get the following errors 'Linux Error: 2: No such file of directory' on an archive file that isn't part of the archive set. (See the full output below)
- 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. Note that the directory path is as expected and the archive file naming convention is correct, it's just looking for a file that I don't seem to have yet. Any suggestions will be greatly appreciated and I thank you all in advance,

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>   

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 14 2008 - 15:43:30 CDT

Original text of this message