Oracle-rac开启数据库归档

精选原创

小宝大人 2022-08-20 19:09:26 博主文章分类：oracle ©著作权

文章标签 sql oracle rac归档 文章分类 Oracle 数据库 yyds干货盘点

©著作权归作者所有：来自51CTO博客作者小宝大人的原创作品，请联系作者获取转载授权，否则将追究法律责任

关闭数据库实例

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=+ARCHIVE';
exit;

重启数据库实例

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

检查归档

sqlplus / as sysdba
archive log list

整体操作过程

SYS@b19c01> archive log list
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            +ARCHIVE
Oldest online log sequence     72
Current log sequence           73
SYS@b19c01> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@b19c01:/home/oracle]$ srvctl start instance -d b19c0 -i b19c01 -o mount
[oracle@b19c01:/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 24 11:37:49 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

SYS@b19c01> alter database archivelog;

Database altered.

SYS@b19c01> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+ARCHIVE';

System altered.

SYS@b19c01> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@b19c01:/home/oracle]$ srvctl stop instance -d b19c0 -i b19c01
[oracle@b19c01:/home/oracle]$ srvctl start database -d b19c0
[oracle@b19c01:/home/oracle]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Sep 24 11:42:00 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

SYS@b19c01> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +ARCHIVE
Oldest online log sequence     72
Next log sequence to archive   73
Current log sequence           73
SYS@b19c01>

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>