Home » Server Options » Data Guard » Open mode for Standby Database (linux 9.2.0.8)
Open mode for Standby Database [message #306232] Thu, 13 March 2008 06:44 Go to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

I have One question.

I have one production database and physical standby database of the Production. Now my stdby database is on mount state. If I fired ALTER DATABASE OPEN at the stdby database what will happen for the Production instance.

Will the production database goes to mount state automatically?

Pokhraj.
Re: Open mode for Standby Database [message #306238 is a reply to message #306232] Thu, 13 March 2008 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 58643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
If I fired ALTER DATABASE OPEN at the stdby database what will happen for the Production instance.

Nothing and you no more have a standby database.

Regards
Michel
icon14.gif  Re: Open mode for Standby Database [message #306710 is a reply to message #306238] Sun, 16 March 2008 02:27 Go to previous message
kumarkis
Messages: 5
Registered: March 2008
Junior Member
You can't issue "Alter database open " on a standby database;
Instead you can issue "Alter database open read only"

This does not harm your primary database in any way.
You can shutdown your read only standby database , mount as normal standy,start recovery and continue normal standby operations after that.......
Previous Topic: Archive log rejected On Logical Standby database
Next Topic: DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY
Goto Forum:
  


Current Time: Fri Aug 01 23:51:53 CDT 2014

Total time taken to generate the page: 0.54107 seconds