10g RAC改归档模式步骤

 

记得第一次修改RAC数据库从非归档模式到归档模式费了我很大劲，并且当时，有客户在身边看着，可总是修改不过来，呵呵…，今天一个新系统割接，同样需要将这个新装的数据库从非归档模式改为归档模式，下面简单贴下我的操作过程，仅供刚入行的朋友们学习、参考。

 

数据库为Oracle 10g RAC，节点1和节点2的归档目录分别为：/arch1和/arch2

1.修改节点1上实例参数：

SQL> alter system set cluster_database=false scope=spfile sid='*';

System altered.

SQL> alter system set log_archive_dest_1='location=/arch1' scope=spfile sid='dzywdb1';

System altered.

2.关闭节点1的数据库实例：

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

3.修改节点2上实例参数并关闭数据库

SQL> alter system set log_archive_dest_1='location=/arch2' scope=spfile sid='dzywdb2';

System altered.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

4.启动节点1实例、打开归档并还原cluster_database参数

 

SQL> startup mount;

ORACLE instance started.

Total System Global Area 3.4360E+10 bytes

Fixed Size                  2144088 bytes

Variable Size            4362078376 bytes

Database Buffers         2.9981E+10 bytes

Redo Buffers               14630912 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination           /arch1

Oldest online log sequence     2068

Next log sequence to archive   2070

Current log sequence           2070

SQL> alter system set cluster_database=true scope=spfile sid='*';

System altered.

5.启动节点2实例并改为归档模式

SQL> startup mount

ORACLE instance started.

Total System Global Area 3.4360E+10 bytes

Fixed Size                  2144088 bytes

Variable Size            4362078376 bytes

Database Buffers         2.9981E+10 bytes

Redo Buffers               14630912 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination           /arch2

Oldest online log sequence     1236

Next log sequence to archive   1238

Current log sequence           1238

至此，数据库实例1的归档目录指定到了/arch1；实例2的归档目录指定到了/arch2。

 

 

CLUSTER_DATABASE

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	No
Range of values	true | false
Basic	Yes
Real Application Clusters	For all instances, the value must be set to TRUE.

CLUSTER_DATABASE is a Real Application Clusters parameter that specifies whether or not Real Application Clusters is enabled.

 

 

 

From:http://www.myoracleclinic.com/2011/12/10g-rac%e6%94%b9%e5%bd%92%e6%a1%a3%e6%a8%a1%e5%bc%8f%e6%ad%a5%e9%aa%a4/