X-list: oracle-l Return-Path: Subject: RE: changing archive from noarchive From: Jim Silverman Message-id: 2D1EFB433A527D4681B80C94B71E359803D2CC32@aaexchange01.HEALTH.AD Date: 2005-12-23 13:45:49 Yes - you need to start up the database as follows: * STARTUP MOUNT; * ALTER DATABASE ARCHIVELOG; * ALTER DATABASE OPEN; Simply providing the log_archive% parameters in the initialization file is not sufficient. Note that the documentation also indicates that RAC must be disabled during this operation. ===================================== Jim Silverman Senior Systems Database Administrator Solucient, LLC Telephone: 734-669-7641 FAX: 734-930-7611 E-Mail: jsilverman@solucient.com From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Onkar N Tiwary Sent: Friday, December 23, 2005 7:27 AM To: oracle-l@freelists.org Subject: changing archive from noarchive 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@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@yahoo.com onkarnath.tiwary@gmail.com This message is a private communication. It may contain information that is confidential and legally protected from disclosure. If you are not an intended recipient, please do not read, copy or use this message or any attachments, and do not disclose them to others. \ Please notify the sender of the delivery error by replying to this message, and then delete it and any attachments from your system. Thank you, Solucient LLC (eXclaimer 4x)