RAC修改归档模式

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            /oracle/product/11.2.0/dbs/arch

Oldest online log sequence     20

Current log sequence           21

SQL> select instance_name,host_name,status from gv$instance; 

INSTANCE_NAME        HOST_NAME            STATUS

-------------------- -------------------- --------------------

racdb1               ract1                OPEN

racdb2               ract2                OPEN

SQL> show parameter cluster -->查看集群的参数,cluster_database为true表示为集群数据库，否则，非集群数据库

SQL> show parameter cluster

NAME                                 TYPE                   VALUE

------------------------------------ ---------------------- ------------------------------

cluster_database                     boolean                TRUE

cluster_database_instances           integer                2

cluster_interconnects                string

SQL> create pfile='/oracle/tmp/racdb_0109_spfile.ora' from spfile;          --备份spfile

File created.

SQL> alter system set cluster_database=false scope=spfile sid='*'; -->修改为非集群数据库，该参数为静态参数，需要使用scope=spfile

[oracle@ract1 oracle]$ srvctl stop database -d racdb   --关闭数据库

[oracle@ract1 oracle]$ srvctl start instance -d racdb -i racdb1 -o mount    --启动单个instance到mount状态

SQL> select instance_name,status from v$instance;

INSTANCE_NAME                    STATUS

-------------------------------- ------------------------

racdb1                           MOUNTED

SQL> alter database archivelog; -->改变数据库到归档模式

SQL> alter system set cluster_database=true scope=spfile sid='*'; -->在将数据库改为集群模式

SQL> ! srvctl stop instance -d racdb -i racdb1

SQL> ! srvctl start database -d racdb

SQL> alter system set db_recovery_file_dest_size=15G;         --设置闪回去大小

System altered.

SQL> alter system set db_recovery_file_dest='+DATAFILE';         --修改归档路劲

System altered.

归档验证：

SQL> alter system switch logfile;              --只归档一个实例

System altered.

SQL> alter system archive log current;          --所有实例都进行归档

System altered.

SQL> select name from gv$archived_log;

NAME

----------------------------------------------------------------------

+DATAFILE/racdb/archivelog/2013_01_09/thread_1_seq_26.272.804259111

+DATAFILE/racdb/archivelog/2013_01_09/thread_2_seq_13.269.804259113