RE: changing archive from noarchive
- From: "Jim Silverman" <jsilverman@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Dec 2005 07:45:49 -0500
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:
