RAC启动归档模式

1.设置归档路径

SQL> show parameter dest_1

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_1          string
log_archive_dest_1                   string
log_archive_dest_10                  string

 

SQL> alter system set log_archive_dest_1='location=+DATA/lgx' scope=both;

System altered.

 

2.shutdown两个节点. 在1节点设置为归档模式.

 

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

 

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size             100664676 bytes
Database Buffers           62914560 bytes
Redo Buffers                2945024 bytes
Database mounted.
SQL> select host_name,status from v$instance;

HOST_NAME                                                        STATUS
---------------------------------------------------------------- ------------
NODE1                                                            MOUNTED

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

3.shutdown 1 节点, 在2节点设置归档模式, 最后打开1节点, 完成cluster的启动归档模式.