OraFAQ Forum: Data Guard » Open mode for Standby Database

Home » Server Options » Data Guard » Open mode for Standby Database (linux 9.2.0.8)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Open mode for Standby Database [message #306232]

Thu, 13 March 2008 06:44

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.

Report message to a moderator

Re: Open mode for Standby Database [message #306238 is a reply to message #306232]

Thu, 13 March 2008 06:52

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Open mode for Standby Database [message #306710 is a reply to message #306238]

Sun, 16 March 2008 02:27

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.......

Report message to a moderator

Previous Topic:	Archive log rejected On Logical Standby database
Next Topic:	DATAGUARD - HOW TO CONFIGURE STANDBY ON THE SAME SYSTEM AS PRIMARY

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 15 07:07:16 CDT 2025