Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enable Archivelog Mode On 2 Node RAC DATABASE

490001Feb 27 2008 — edited Feb 27 2008
hi,

We are having 2 Node Rac 10g Database Installed on Windows.
Currently the Database is in Non Archivelog Mode.
I want to convert it to Archivelog Mode.
I come to know the steps to convert cluster database to Archivelog mode.

i.e.
set archive parameters like Disk Location and Archivelog File format.
then Convert the database in Exclusive Mode

ALTER SYSTEM SET cluster_database=FALSE SCOPE=spfile;

then
C:\> srvctl stop database -d <Global_DB_SID>

then enable Archivelog Mode.

SQL> STARTUP MOUNT;

SQL> ARCHIVE LOG START;

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ALTER DATABASE SET cluster_database=TRUE SCOPE=spfile;

SQL> SHUTDOWN IMMEDIATE

C:\> srvctl start database -d <Global_DB_SID>

But I am confuse with Do i need to RUN this commands in both the nodes seperatly or only on any one node.


Please Reply,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2008
Added on Feb 27 2008
4 comments
1,107 views