RE: Turn off Dataguard 9.2

1. db_broker_start=false
2. log_archive_dest_2_state=defer
3. dgmgrl > connect / ;

dgmgrl > disable configuration;    

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 9:54 AM 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  

Notice:

This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Hansen Technologies Limited or third parties. Copying, distributing, disclosing, commercialising or otherwise acting in reliance on this e-mail and any attachments is strictly prohibited unless you are the addressee of this e-mail and have written permission to do so. If you have received this e-mail in error please delete this e-mail (including any copies and attachments) and contact Hansen Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of or be a commitment by the organisation, except where the individual sender has the authority and expressly states them to be so.         

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 27 2006 - 23:56:09 CDT