RE: Turn off Dataguard 9.2
- From: "Satheesh Babu" <satheeshbabu.s@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 Sep 2006 11:46:59 +0530
Hi,
You can defer it by log_archive_dest_2=defer; or set disable logical
standby location by log_archive_dest_2=''
Regards,
Satheesh Babu.S
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Leng Kaing
Sent: Thursday, September 28, 2006 11:11 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Turn off Dataguard 9.2
Thanks for this, Sateesh. I should have said that I'm only using the logical
standby SQL command line interface. I'm not using data guard broker. So we
do "EXECUTE DBMS_LOGSTDBY.BUILD;" to build the logical standby. Is there a
command to "unbuild"?
From: "Satheesh Babu" <satheeshbabu.s@xxxxxxxxx>
* To: <oracle-l@xxxxxxxxxxxxx>
* Date: Thu, 28 Sep 2006 10:26:09 +0530
1. db_broker_start=false
2. log_archive_dest_2_state=defer
3. dgmgrl > connect / ;
dgmgrl > disable configuration;
_____
From: Leng Kaing
Sent: Thursday, 28 September 2006 2:24 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Turn off Dataguard 9.2
G'day all,
I know how to turn on data guard and also switch between primary and
secondary. Now, how do you go about turning off data guard altogether? What
if I don't want the database to be replicated anywhere? Is it simply a
matter of settting log_archive_dest_2 to null?
TIA,
Leng.
------------------------------------------------------------------
Leng Kaing
Senior Oracle DBA
Hansen Technologies; 2 Frederick St; Doncaster 3108
Ph: +61-3-9840-3832
Other related posts:
