Oracle10g/11gRAC start/stop archiving Mode

Oracle 10g rac start/stop archiving Mode

If the Oracle database runs in archive mode, you may need to suspend the archiving of the database during database maintenance. After the maintenance is complete, restart archive mode.
To switch from archive to non-archive, follow these steps:

Perform the following steps on a machine. Node 2 remains down. After all the operations are completed, open the database of Node 2.
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

----- Change from 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 archiving mode:
----- Disable archive Mode
Assume that RAC has two nodes (or multiple nodes) and closes all other nodes normally. Only one node is retained.

Perform the following operations on the remaining node:
Method 1:
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;
SQL> archive log list ------ verify whether archive is disabled

Method 2:
SQL> shutdown immediate;
SQL> startup mount exclusive;
SQL> alter database noarchivelog;
SQL> shutdown immediate
SQL> startup
SQL> archive log list ------ verify whether archive is disabled

------ Enable archive Mode
Assume that RAC has two nodes (or multiple nodes) and closes all other nodes normally. Only one node is retained.

Perform the following operations on the remaining node:

Method 1:

SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> archive log list ------ verify whether archive is disabled

Method 2:

SQL> shutdown immediate;
SQL> startup mount exclusive;
SQL> alter database archivelog;
SQL> shutdown immediate
SQL> startup
SQL> archive log list ------ verify whether archive is disabled