Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> changing archive from noarchive

changing archive from noarchive

From: Onkar N Tiwary <onkarnath.tiwary_at_gmail.com>
Date: 2005-12-23 13:26:40
Message-id: a144e5210512230426i7cf9ea9cr4eff2cae1a0b996c@mail.gmail.com


hi all,

This is the first time, I am going to put one production server, which is running in Active-Passive cluster, in archivelog mode from noarchive log mode. As I said since this is the first time , I am going to do this , so I don know what are the changes required. My plan is as :

  1. setting log_archive_dest,log_archive_format & log_archive_start parameters in init.ora/spfile.ora on both the nodes
  2. connecting to oracle server with sys/pass_at_string as sysdba
  3. shutting down the database using SHUTDOWN IMMEDIATE
  4. starting the database normally using STARTUP

Do I need to do something else??? Plz. sugges.

--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
       to_onkar_at_yahoo.com
       onkarnath.tiwary_at_gmail.com
Received on Fri Dec 23 2005 - 13:26:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US