11g RAC开启归档模式
阅读原文时间:2023年07月14日阅读:3

1、关闭集群数据库

[oracle@rac01-+ASM1 ~]$ srvctl stop database -d rac

2、开启节点一数据库到mount状态

SQL> startup mount;

或者

[oracle@rac01-+ASM1 ~]$ srvctl stop database -d rac -i rac1 -o mount

3、开启数据库归档

SQL> alter database archivelog;

Database altered.

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

4、关闭节点一数据库

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

5、开启集群数据库(节点一、节点二)

[oracle@rac01-+ASM1 ~]$ srvctl start database -d rac

6、查看数据库归档模式

节点一:

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

节点二:

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