How To Enable/Disable Archive Log Mode on Oracle9i

主题:	How To Enable/Disable Archive Log Mode on Oracle9i Real Application Cluster
	:	注释:235158.1	类型:	HOWTO
	上次修订日期:	03-APR-2006	状态:	PUBLISHED

goal: How to Enable/Disable Archive Log In Real Application Cluster
fact: Oracle Server - Enterprise Edition Oracle 9
fact: Oracle9i Real Application Cluster (RAC)



fix:

1. Shut down all instances. 

2. Set the CLUSTER_DATABASE parameter to false on one instance in the parameter 
file. If you are using the server parameter file, make an SID-specific entry 
for this, like:

     .CLUSTER_DATABASE= False
     .CLUSTER_DATABASE= False

For Modifying server parameter file (SPFILE) you can refer to :


3. Set the LOG_ARCHIVE_START parameter to true. 

4. Set the LOG_ARCHIVE_FORMAT and make sure the parameter containing the %t 
parameter includes the thread number in the archived logfile name. 

5. Set the cluster database wide LOG_ARCHIVE_DEST_1 parameter in the parameter 
file as follows: 

   LOG_ARCHIVE_DEST_1='LOCATION=$ORACLE_BASE/oradata//archive'

Note : You can multiplex the destination to up to ten locations, refer to:


To specify the archive log destinations on a per instance basis for a two-
instance cluster database, for example, set the parameter as follows:

   .LOG_ARCHIVE_DEST_1='LOCATION=$ORACLE_BASE/oradata/gt;/archive' 
   .LOG_ARCHIVE_DEST_1='LOCATION=$ORACLE_BASE/oradata/gt;/archive' 

Archive logs can be on the shared disk on platforms that support CFS 
(Cluster File System).  For more information on this see the following note:

  Note 183408.1
  Raw Devices and Cluster Filesystems With Real Application Clusters

6. Mount the database in exclusive mode for the instance on which you have set 
CLUSTER_DATABASE to false. 

7. Set the database in ARCHIVELOG mode :
    
     SQL> ALTER DATABASE ARCHIVELOG;

8. Shutdown the instance.

9. Change the value of the CLUSTER_DATABASE parameter to true.

10. Startup all your instances. 

To disable archive logging, follow the same steps but use the NOARCHIVELOG 
clause of the ALTER DATABASE statement.


我曾写过一个文章
http://blog.chinaunix.net/u/7667/showart.php?id=103063
可以和metalink的这个notes放在一起读。