RE: changing archive from noarchive

From: Jim Silverman <jsilverman_at_Solucient.com>
Date: 2005-12-23 13:45:49
Message-id: 2D1EFB433A527D4681B80C94B71E359803D2CC32@aaexchange01.HEALTH.AD

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_at_solucient.com 

		From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Onkar N Tiwary
		Sent: Friday, December 23, 2005 7:27 AM
		To: oracle-l_at_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_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

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) Received on Fri Dec 23 2005 - 13:45:49 CST