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