How to open Physical standby database in read write mode

Steps are follows

If your primary Server has crashed and no hope to start it up, than follow the steps to open Physical stand by database to read write mode .

But be very care full once you open the Physical standby in read write mode, there is no rollback.

SQL> conn /as sysdba
Connected.
SQL> select database_role from v$database;
DATABASE_ROLE
----------------
PHYSICAL STANDBY

SQL> alter database open;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ ONLY

shutdown database

SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2096632 bytes
Variable Size 385876488 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14680064 bytes
Database mounted.

Activate Physical standby database

SQL> alter database activate standby database;
Database altered.

 

Set path for redo logfile to be created on opening database

SQL> alter system set log_file_name_convert='+DGROUP1/prod/onlinelog/','/database/oradata/' scope=spfile;
System altered.
SQL> shudown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2096632 bytes
Variable Size 385876488 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14680064 bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
SQL>
Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle DataGaurd. Bookmark the permalink.

2 Responses to How to open Physical standby database in read write mode

  1. Pingback: “That’s Not What I Wanted.” | Oracle Tips and Tricks -- David Fitzjarrell

  2. Pingback: “That’s Not What I Wanted.” - Oracle Blog - Oracle - Toad World

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s