12c单机DG
1 环境
1.1系统:CentOS 7.2
# uname -a
Linux dg-p 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
1.2数据库:12.1.0.2.0 - 64bit Production
实例名:主---orcl_p;备---orcl_s;
1.3机器名:dg-p和dg-s;
1.4SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB12C1 MOUNTED
4 PDB12C2 MOUNTED
从上面可以看出有一个CDB两个PDB,根据自己库的情况来决定后面所需要创建的目录。
1.5host文件
# cat /etc/hosts
127.0.0.1 localhost test
192.168.70.42 dg-p
192.168.70.43 dg-s
1.6主备库的时间
需要将主备库的时间设置为一致,不然有可能导致同步上出现未知问题
查看时间(主备)
# date
如时间不一致,修改
# date -s 时间
2 主库前期工作
2.1 主库启动FORCE LOGGING
Forced Logging ---主库设置强制日志,保证所有的操作都记录到日志文件;
SQL> select name,open_mode from v$pdbs;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED READ ONLY
PDB12C1 READ WRITE
PDB12C2 READ WRITE
查看force logging是否启动
SQL> select force_logging from v$database;
FORCE_LOGGING
---------------------------------------
NO
修改为强制日志(force logging)
SQL> alter database force logging;
Database altered.
SQL> select force_logging from v$database;
FORCE_LOGGING
---------------------------------------
YES
2.2 启动归档模式
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 12
Current log sequence 14
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 754974720 bytes
Fixed Size 2928968 bytes
Variable Size 524291768 bytes
Database Buffers 222298112 bytes
Redo Buffers 5455872 bytes
Database mounted.
SQL> alter database archivelog;
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 12
Next log sequence to archive 14
Current log sequence 14
SQL> show parameter recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 4560M
recovery_parallelism &nbs