oracle改成归档模式_ORACLE9I RAC 如果将非归档模式，更改成归档模式

I just finished a RAC testing. Some stuff to share with you.

Enable archive log

1. Shut down all instances.

2. modify some initial parameters on one instance in the parameter file with following steps:

a. SQL> create pfile='rman.ora' from spfile;

File created.

b. edit rman.ora and change some variables as follow:

*.cluster_database=TRUE

BEB1.log_archive_dest_1='LOCATION=?/arc_dest_1'

BEB2.log_archive_dest_1='LOCATION=?/arc_dest_2'

*.log_archive_start=TRUE

Set LOG_ARCHIVE_FORMAT and make sure the parameter containing the %t

parameter includes the thread number in the archived logfile name.

Ensure that each instance's archive log destination is mounted as read-write

for its node and read only for other nodes. In our case, Cluster2 mounts Cluster1's '?/arc_dest_2' on local directory, and Cluster1 mount Cluster2's '?/arc_dest_1' on local directory.

c. Recreate the SPFILE from the modified PFILE 'rman.ora':

SQL> create spfile from pfile='rman.ora';

File created.

3. Mount the database in exclusive mode for the instance on which you have set

CLUSTER_DATABASE to false.

4.Set the database in ARCHIVELOG mode :

SQL> ALTER DATABASE ARCHIVELOG;

5. Shutdown the instance.

6. Change the value of the CLUSTER_DATABASE parameter to true(use the steps described in step 2).

7. Startup all your instances.

To disable archive logging, follow the same steps but use the NOARCHIVELOG

clause of the ALTER DATABASE statement.