Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bringing physical standby database to online

597802Jan 23 2008 — edited Feb 28 2008
Dear 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...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2008
Added on Jan 23 2008
47 comments
10,757 views