本文包含以下两个知识点,环境信息如下图所示:
- 部署Data Guard服务;
- Data Guard Broker的配置以及使用。
一、部署Physical Standby
1.1 主库准备工作
1.1.1启用force logging
SQL> ALTER DATABASE FORCE LOGGING;
1.1.2 创建standby数据库redo文件
SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200M; SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200M; SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200M; SQL> ALTER DATABASE ADD STANDBY LOGFILE SIZE 200M;
1.1.3 设置主库参数
SQL> alter system set log_archive_config='dg_config=(cdb,cdb_stby)' scope=both; SQL> alter system set log_archive_dest_2='service=cdb_stby async valid_for=(online_logfile,primary_role) db_unique_name=cdb_stby'; SQL> alter system set standby_file_management=auto;
1.1.4 确保主库处于归档模式
1.1.5 编辑tnsnames.ora
[oracle@db03 admin]$ vi tnsnames.ora
CDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.120.83)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cdb)
)
)
CDB_STBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.120.82)(PORT = 1521))
(CONNECT_DATA &