Bringing physical standby database to online
597802Jan 23 2008 — edited Feb 28 2008Dear Guru's,
These steps were taken to create the physical standby DB with Oracle9i rel. 2 as described in http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/toc.htm:
0. on the primary DB: ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/2stdby/orastdby.ctl';
Edit the initorastdby.ora to reflect the correct settings as described in http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#58021
1. shutdown the primary DB
2. copy the orastdby.ctl and all dbf files to the standby machine
3. restart primary DB
4. on the standby DB machine:
i. startup nomount
ii. alter database mount standby database;
iii. alter database recover managed standby database disconnect from session;
5. on the primary DB:
i. alter system set log_archive_dest_2='service=orastdby' scope=both;
ii. alter system set log_archive_dest_state_2=enable scope=both;
iii. alter system archive log current;
6. verify that the new archived redo log are received & applied
7. But: alter database open read only; results in:
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/usr/oradata/orastdby/oradata2/system01.dbf'
And: recover standby database; after answering auto for "Specify log: {<RET>=suggested | filename | AUTO | CANCEL}" results in:
ORA-16145: archival for thread# 1 sequence# 248 in progress
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/usr/oradata/orastdby/oradata2/system01.dbf'
Did I overlooked something here? Please help...
Thanks a lot in advance...