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


 You can defer it by log_archive_dest_2=defer; or set disable logical
standby location by log_archive_dest_2=''



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? 







Leng Kaing

Senior Oracle DBA

Hansen Technologies; 2 Frederick St; Doncaster 3108

Ph: +61-3-9840-3832


Other related posts: