Oracle RAC 修改为归档模式

Rac架构数据库的归档模式启动方法与单机的不同。我们来看下步骤

当前系统状态

归档 – No

SQL> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u01/oracle/product/11.2.0/db/dbs/arch
Oldest online log sequence     43
Current log sequence           46

查看db名

SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offloadgroup_name               string
db_file_name_convert                 string
db_name                              string      neicedb
db_unique_name                       string      neicedb
global_names                         boolean     FALSE
instance_name                        string      neicedb1
lock_name_space                      string
log_file_name_convert                string
processor_group_name                 string
service_names                        string      neicedb

配置归档

调整参数

在一个节点上修改即可：

SQL> alter system set db_recovery_file_dest_size=500g;

System altered.

SQL> alter system set db_recovery_file_dest='+ARCH';

System altered.

SQL> alter system set log_archive_dest_1='location=use_db_recovery_file_dest' scope=spfile sid='*';

System altered.

修改为非集群数据库，该参数为静态参数，需要使用scope=spfile

SQL> alter system set cluster_database=false scope=spfile;

System altered.

关闭rac所有实例

我这里用的是很简单的方法，需要分别去各个节点执行shutdown。

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

启动归档模式

这里只需要在一个节点上执行，开启归档的命令。

SQL> startup mount
ORACLE instance started.

Total System Global Area 1.4999E+10 bytes
Fixed Size                  2267832 bytes
Variable Size            2583692616 bytes
Database Buffers         1.2382E+10 bytes
Redo Buffers               31125504 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

现在数据库是归档模式了，但不是集群，我们把参数在调整回来。
调整参数 --> 关库 --> 起库

SQL> alter system set cluster_database=true scope=spfile;

System altered.


SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

既然又回到cluster的模式了，我们可以把所有的节点都启动起来了：

SQL> startup
ORACLE instance started.

Total System Global Area 1.4999E+10 bytes
Fixed Size                  2267832 bytes
Variable Size            2583692616 bytes
Database Buffers         1.2382E+10 bytes
Redo Buffers               31125504 bytes
Database mounted.
Database opened.

验证归档

1. 查看数据库配置

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     43
Next log sequence to archive   46
Current log sequence           46

2. 切换日志，查看是否已经在指定路径下生成了归档文件。

SQL> alter system switch logfile;

System altered.

SQL> exit

[oracle@oracle11g1 ~]$ exit
logout
[root@oracle11g1 rules.d]# su - grid
Last login: Mon Jun 15 09:56:50 CST 2020 on pts/1
[grid@oracle11g1 ~]$ asmcmd
ASMCMD> cd arch
ASMCMD> ls
NEICEDB/
ASMCMD> cd neicedb
ASMCMD> ls
ARCHIVELOG/
ASMCMD> cd arch*
ASMCMD> ls
2020_06_15/
ASMCMD> cd 2020* 
ASMCMD> ls 
thread_1_seq_46.257.1043164887
thread_2_seq_22.256.1043164843

确认无误