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