RE: Data Guard
Date: Fri, 16 Dec 2011 18:27:34 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3156900_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of P D
Sent: Thursday, December 15, 2011 10:48 AM
To: oracle-l_at_freelists.org
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.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 16 2011 - 12:27:34 CST