RE: Turn off Dataguard 9.2

  • From: "Leng Kaing" <Leng.Kaing@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Sep 2006 15:40:52 +1000

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: