RE: changing archive from noarchive

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@xxxxxxxxxxxxx 

                From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Onkar N Tiwary
                Sent: Friday, December 23, 2005 7:27 AM
                To: oracle-l@xxxxxxxxxxxxx
                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<sid>.ora/spfile<sid>.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@xxxxxxxxx  <mailto:to_onkar@xxxxxxxxx> 
                       onkarnath.tiwary@xxxxxxxxx
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)

Other related posts: