Oracle 10g/11g RAC Start-Stop archive mode



Oracle 10g RAC Start-Stop archive mode

If the Oracle database is running in archive mode, you may need to pause the archive of the database when you perform database maintenance, and then restart the archive mode after maintenance is complete.
You can convert from archive mode to non-archive mode by using the following steps:

The following steps operate on a single machine. Node two remains down. After all the operations are completed, open the database in node two.
Sql>connect Sys/password
Sql>alter SYSTEM SET cluster_database=false scope=spfile;
Sql>shutdown immediate;
Sql>startup Mount Exclusive;
Sql>alter database Noarchivelog;
Sql>alter SYSTEM SET cluster_database=true scope=spfile;
Sql>shutdown immediate;
Sql>startup

-----Non-archive to archive
Sql>connect Sys/password
Sql>alter SYSTEM SET cluster_database=false scope=spfile;
Sql>shutdown immediate;
Sql>startup Mount Exclusive;
Sql>alter database Archivelog;
Sql>alter SYSTEM SET cluster_database=true scope=spfile;
Sql>shutdown immediate;
Sql>startup

Oracle 11g RAC Start-Stop archive mode:
-----Disabling archive mode
Suppose a RAC has 2 nodes, (or multiple nodes) gracefully shuts down all other nodes, leaving only one node open

On the remaining node, do the following:
Way One:
Sql>shutdown immediate;
Sql>startup Mount;
Sql>alter database Noarchivelog;
Sql>alter database open;
Sql> Archive Log list------Verify that the archive is turned off

Way two:
Sql>shutdown immediate;
Sql>startup Mount Exclusive;
Sql>alter database Noarchivelog;
Sql>shutdown Immediate
Sql>startup
Sql> Archive Log list------Verify that the archive is turned off

------Enable Archive mode
Suppose a RAC has 2 nodes, (or multiple nodes) gracefully shuts down all other nodes, leaving only one node open

On the remaining node, do the following:

Way One:

Sql>shutdown immediate;
Sql>startup Mount;
Sql>alter database Archivelog;
Sql>alter database open;
Sql> Archive Log list------Verify that the archive is turned off

Way two:

Sql>shutdown immediate;
Sql>startup Mount Exclusive;
Sql>alter database Archivelog;
Sql>shutdown Immediate
Sql>startup
Sql> Archive Log list------Verify that the archive is turned off