RE: Turn off Dataguard 9.2

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Leng Kaing
Sent: Thursday, September 28, 2006 11:11 AM To: oracle-l_at_freelists.org
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_at_xxxxxxxxx>

• To: <oracle-l_at_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_at_freelists.org'
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  

--
http://www.freelists.org/webpage/oracle-l