Oracle-rac开启数据库归档

关闭/启动数据库实例

su - oracle
srvctl stop database -d b19c0

开启单个节点到mount模式

srvctl start instance -d b19c0 -i b19c01 -o mount

开启归档

sqlplus / as sysdba
alter database archivelog;

设置归档路径

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA';
exit;

重启数据库实例

srvctl stop instance -d b19c0 -i b19c01
srvctl start database -d b19c0

检查归档

sqlplus / as sysdba
archive log list

rac1 (b19c01)

[oracle@b19c01:/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 20 19:06:03 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA
Oldest online log sequence     6
Next log sequence to archive   7
Current log sequence           7
SQL>

rac2 (b19c02)

[oracle@b19c02:/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 20 19:05:40 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DATA
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1
SQL>

此时可以看到，两个节点都已开启归档。