oracle 12C dataguard搭建

1.oracle 12C dataguard搭建环境（主从库相同，从库只装软件不建库）

OS:

[oracle@oracle-two ~]$ more /etc/redhat-release

CentOS release 6.5 (Final)

ORACLE:

SQL> SELECT * FROM V$VERSION;

BANNER CON_ID

-------------------------------------------------------------------------------- ----------

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0

PL/SQL Release 12.2.0.1.0 - Production 0

CORE 12.2.0.1.0 Production 0

TNS for Linux: Version 12.2.0.1.0 - Production 0

NLSRTL Version 12.2.0.1.0 - Production 0

2.dataguard主库参数配置

2.1检查主库状态，pdb是否为open，

SQL> show pdbs;

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 CDB READ WRITE NO

2.2检查主库是否开启force_logging，否则要执行以下命令

SQL> select force_logging from v$database;

FORCE_LOGGING

---------------------------------------

YES

SQL> alter database force logging;

Database altered.

2.3检查主库归档模式开启情况

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled（未开启归档模式）

Archive destination /u01/app/oracle/oradata/arch

Oldest online log sequence 51

Current log sequence 53

执行名利开启归档

SQL> alter database archivelog;

Database altered.

再次查看，归档模式开启情况

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled（归档模式开启）

Archive destination /u01/app/oracle/oradata/arch

Oldest online log sequence 51

Next log sequence to archive 53

Current log sequence 53

2.4检查在线日志redolog，确认member和group#，根据在线日志添加standby logfile（以下操作均在CBD下操作）

SQL> select group#, members, bytes from v$log;

GROUP# MEMBERS BYTES

---------- ---------- ----------

1 2 209715200

3 2 209715200

2 2 209715200

添加standby logfile（3+1）

ALTER DATABASE ADD STANDBY LOGFILE '/u01/app/oracle/oradata/ORCL/onlinelog/stdredo01.log' size 50M;

ALTER DATABASE ADD STANDBY LO