RE: Data Guard

Date: Fri, 16 Dec 2011 21:52:35 +0000
Message-ID: <>

Also, DG can run in 3 different protection levels, like max_performance, max_protection. Maybe your DG is running on a mode other than max_performance ?

-----Original Message-----

From: [] On Behalf Of CRISLER, JON A Sent: Friday, December 16, 2011 1:28 PM
To:; Subject: RE: Data Guard

Why would you run a cold backup? Get rid of that and go to RMAN so you don't ever have to shut down the db for backups. Also, check the tns connect string you are using- perhaps you are accidentally connecting to the wrong host-

Select host_name, database_name from v$instance;

-----Original Message-----

From: [] On Behalf Of P D Sent: Thursday, December 15, 2011 10:48 AM To:
Subject: Data Guard

I have a Data Guard Logical configuration. When I shutdown the standby database, I receive alerts from the PRIMARY "ORA-01089: immediate shutdown in progress - no operations are permitted". Before shutting down the standby, I already altered database to stop logical apply and also altered the primary to defer. Even though I get the immediate shutdown in progress error in the primary, it is still up and I can run some queries like select * from v$instance; Why is it saying immediate shutdown in progress?  

Also, I have some trouble running a cold backup on the primary because when it tries to start and reopen the database afterward, it says database already open.                                                   



-- Received on Fri Dec 16 2011 - 15:52:35 CST

Original text of this message