how to changing the RAC 10g Database Archiving Mode

 === ODM Answer ===

Que:
how to changing the RAC 10g Database Archiving Mode?



Ans:
The following steps need to be taken to enable archive logging in a RAC database environment:


--1. set your log_archive_dest1 parameters to a shared location
SQL> conn / as sysdba
SQL> alter system set log_archive_dest_1='location=<ASM_DISKGROUP_NAME>' ;


--2. shutdown immediate all database instances
$ srvctl stop database -d <db_unique_name>


--3. startup database in mount mode
$ srvctl start database -d <db_unique_name> -o mount


--4. enable archvive logging
$ sqlplus / as sysdba
sql> alter database archivelog;
sql> exit;


--5. stop database
$ srvctl stop database -d <db_unique_name>


--6. restart all database instances
$ srvctl start database -d <db_unique_name>


--7. verify archiving is enabled by means of:
sql> archive log list;

 

=== ODM Answer ===

There's two questions:
1.Needn't set the parameter LOG_ARCHIVE_FORMAT?
==>LOG_ARCHIVE_FORMAT has the default value, so we need not set it, but if you want to change the archived log format, you can set this init parameter.

2.In the third step,is it just start mount one instance?
==>yes, change database to archivelog mode, which need in the mount status. This is the same with standalone database.