Oracle Dataguard（主库为双节点集群）配置详解（3）：配置主库

Oracle Dataguard（主库为双节点集群）配置详解（3）：配置主库

一、开启归档

-- 查看主库归档状态
SQL> archive log list;
Database log mode	       No Archive Mode
Automatic archival	       Disabled
Archive destination	       USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     4
Current log sequence	       5

-- 停库
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

-- 启动数据库到mount状态
SQL> startup mount;
ORACLE instance started.

Total System Global Area  626327552 bytes
Fixed Size		    2255832 bytes
Variable Size		  297796648 bytes
Database Buffers	  322961408 bytes
Redo Buffers		    3313664 bytes
Database mounted.

-- 修改数据库为归档模式
SQL> alter database archivelog;

Database altered.

-- 打开数据库
SQL> alter database open;

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     4
Next log sequence to archive   5
Current log sequence	       5

二、开启强制日志

SQL> alter database force logging;

Database altered.

三、添加 standby 日志

创建主库的standby日志文件，每个实例的组数要比logfile多一组。

1、查看主库的日志信息

-- 查看日志组
select * from v$log;

-- 查看日志文件
select member from v$logfile;


SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE	  MEMBERS ARC STATUS	 FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
	 1	    1	      11  104857600	   512		2 NO  CURRENT		      986498 09-JAN-25	 2.8147E+14
	 2	    1	       0  104857600	   512		2 YES UNUSED			   0			  0
	 3	    1	       0  104857600	   512		2 YES UNUSED			   0			  0
	 4	    2	       9  104857600	   512		2 NO  CURRENT		      986588 09-JAN-25	 2.8147E+14
	 5	    2	       0  104857600	   512		2 YES UNUSED			   0			  0
	 6	    2	       0  104857600	   512		2 YES UNUSED			   0			  0

6 rows selected.


SQL> select member from v$logfile;

MEMBER
------------------------------------------------------------------------
+DATA/hisdb/onlinelog/group_1.266.1189965499
+BAK/hisdb/onlinelog/group_1.260.1189965507
+DATA/hisdb/onlinelog/group_2.265.1189965519
+BAK/hisdb/onlinelog/group_2.259.1189965527
+DATA/hisdb/onlinelog/group_3.262.1189965537
+BAK/hisdb/onlinelog/group_3.275.1189965547
+DATA/hisdb/onlinelog/group_4.261.1189965557
+BAK/hisdb/onlinelog/group_4.276.1189965567
+DATA/hisdb/onlinelog/group_5.272.1189965