完成配置
配置 Oracle Data Guard、注册备用数据库以及同步内部部署和备用数据库口令。
配置 Oracle Data Guard 代理程序
通过在主数据库和备用数据库上启用 dg_broker_config_file 参数配置 Oracle Data Guard。对于 Oracle Automatic Storage Management (Oracle ASM )，将中介配置文件放在单独的磁盘组中。对于 Oracle Real Application Clusters (Oracle RAC )，中介配置文件必须位于共享存储上。
- 检查内部部署数据库主机的
dg_broker_start值。应将其设置为false。SQL> show parameter dg_broker_start;输出将类似于以下内容：NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean FALSE - 在备用 Oracle Database Exadata Cloud Service 上，检查 Oracle Data Guard 配置文件。
以下是示例输出：SQL> show parameter dg_broker_config_file1;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file1 string /u02/app/oracle/product/19.0.0.0/dbhome_5/dbs/dr1DB1_phx3g7.dat
以下是示例输出：SQL> show parameter dg_broker_config_file2;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file2 string /u02/app/oracle/product/19.0.0.0/dbhome_5/dbs/dr2DB1_phx3g7.dat - 显示数据文件，然后将要存储文件的位置更改为。例如，Oracle ASM、Oracle RAC 或设备。
SQL> select name from v$datafile;NAME -------------------------------------------------------------------------------- +DATAC1/DB1_PHX3G7/DATAFILE/system.348.1063638053 +DATAC1/DB1_PHX3G7/DATAFILE/sysaux.349.1063638055 +DATAC1/DB1_PHX3G7/DATAFILE/undotbs1.350.1063638057 +DATAC1/DB1_PHX3G7/DATAFILE/undotbs2.351.1063638057 +DATAC1/DB1_PHX3G7/DATAFILE/users.352.1063638059SQL> alter system set dg_broker_config_file1='+DATAC1/DB1_PHX3G7/dr1DB1_phx3g7.dat';SQL> alter system set dg_broker_config_file2='+RECOC1/DB1_PHX3G7/dr2DB1_phx3g7.dat'; - 在主内部部署 Oracle Exadata Database Machine 上，检查 Oracle Data Guard 配置文件。
以下是示例输出：SQL> show parameter dg_broker_config_file1;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file1 string /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/dr1db1.dat.dat
下面是输出示例：SQL> show parameter dg_broker_config_file2;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file2 string /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/dr2db1.dat - 显示数据文件，然后将要存储文件的位置更改为。
下面是输出示例：SQL> select name from v$datafile;
运行以下命令以更改配置文件位置：NAME -------------------------------------------------------------------------------- +DATAC1/DB1/DATAFILE/system.277.1063487795 +DATAC1/DB1/DATAFILE/sysaux.270.1063487827 +DATAC1/DB1/DATAFILE/undotbs1.259.1063487843 +DATAC1/DB1/DATAFILE/undotbs2.275.1063487867 +DATAC1/DB1/DATAFILE/users.269.1063487879SQL> alter system set dg_broker_config_file1='+DATAC1/DB1/dr1db1.dat';SQL> alter system set dg_broker_config_file2='+RECOC1/DB1/dr2db1.dat';SQL> alter system set dg_broker_start=false; SQL> alter system set dg_broker_config_file1='+DATAC1/DB1/dr1db1.dat'; SQL> alter system set dg_broker_config_file2='+RECOC1/DB1/dr2db1.dat'; - 在主内部部署 Oracle Exadata Database Machine 上，启动 Oracle Data Guard 中介进程。
SQL> alter system set dg_broker_start=true; SQL> show parameter dg_broker_startNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUESQL> select pname from v$process where pname like 'DMON%';PNAME ----- DMON - 在备用数据库上启动 Oracle Data Guard 中介进程。
SQL> alter system set dg_broker_start=true; SQL> show parameter dg_broker_startNAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUESQL> select pname from v$process where pname like 'DMON%';PNAME ----- DMON
注册备用数据库
使用 Oracle Data Guard 命令行界面 (command-line interface, DGMGRL) 将备用数据库概要文件注册或添加到主内部部署主机上的中介配置。
- 以
sys身份登录到主主机。$ dgmgrl sys/sys password@net service name for primary database - 创建使用主数据库名称的配置。
例如：DGMGRL> CREATE CONFIGURATION configuration_name AS PRIMARY DATABASE IS primary database name CONNECT IDENTIFIER IS primary database name;CREATE CONFIGURATION OnPremExaDR AS PRIMARY DATABASE IS DB1 CONNECT IDENTIFIER IS DB1; - 添加备用数据库。确保标识符与服务名相同，包括大写和小写。
例如：DGMGRL> ADD DATABASE standby unique database name AS CONNECT IDENTIFIER IS standby unique database name MAINTAINED AS PHYSICAL;ADD DATABASE DB1_PHX3G7 AS CONNECT IDENTIFIER IS DB1_phx3g7 MAINTAINED AS PHYSICAL;如果收到 ORA-16698 错误消息，请验证您的标识符是否与服务名相同。错误：ORA-16698：成员具有设置了 SERVICE 属性的 LOG_ARCHIVE_DEST_n 参数
- 更改日志归档目标状态。
SQL> alter system set log_archive_dest_state_10='DEFER';SQL> alter system set log_archive_dest_10=''; - 验证日志归档目标。
SQL> show parameter log_archive_dest;NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DB1_PHX3G7 log_archive_dest_10 string log_archive_dest_11 string log_archive_dest_12 string log_archive_dest_13 string log_archive_dest_14 string log_archive_dest_15 string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_16 string log_archive_dest_17 string log_archive_dest_18 string log_archive_dest_19 string log_archive_dest_2 string SERVICE=DB1 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB1 log_archive_dest_20 string log_archive_dest_21 string log_archive_dest_22 string log_archive_dest_23 string - 启用配置。
DGMGRL> enable configuration; - 显示配置。
DGMGRL> show configuration;输出将与以下内容类似：Configuration - onpremexadr Protection Mode: MaxPerformance Members: db1 - Primary database Warning: ORA-16809: multiple warnings detected for the member db1_phx3g7 - Physical standby database Error: ORA-16532: Oracle Data Guard broker configuration does not exist Fast-Start Failover: Disabled Configuration Status: ERROR (status updated 21 seconds ago) - 在备用 Oracle Database Exadata Cloud Service 上，登录以验证配置。
[oracle@exacs82-vm3sv1 ~]$ dgmgrl DGMGRL> connectUsername: sys Password: Connected to "DB1_phx3g7" Connected as SYSDBA.
输出将与以下内容类似：DGMGRL> show configuration;Configuration - onpremexadr Protection Mode: MaxPerformance Members: db1 - Primary database Warning: ORA-16809: multiple warnings detected for the member db1_phx3g7 - Physical standby database Warning: ORA-16809: multiple warnings detected for the member Fast-Start Failover: Disabled Configuration Status: WARNING (status updated 43 seconds ago
将重做日志文件从本地复制到 OCI
将 redo 日志文件和其他数据库文件从内部部署数据库复制到 Oracle Cloud Infrastructure (OCI) 实例。
- 查看内部部署数据库文件。
select name from v$datafile;输出将与以下内容类似：NAME -------------------------------------------------------------------------------- +DATAC1/DB1/DATAFILE/system.277.1063487795 +DATAC1/DB1/DATAFILE/sysaux.270.1063487827 +DATAC1/DB1/DATAFILE/undotbs1.259.1063487843 +DATAC1/DB1/DATAFILE/undotbs2.275.1063487867 +DATAC1/DB1/DATAFILE/users.269.1063487879 - 查看内部部署数据文件的每个组的大小。
select bytes, group# from v$log;输出将与以下内容类似：BYTES GROUP# ---------- ---------- 209715200 1 209715200 2 209715200 3 209715200 4 - 查看内部部署数据文件的
redo日志。select member from v$logfile;输出将与以下内容类似：MEMBER -------------------------------------------------------------------------------- +DATAC1/DB1/ONLINELOG/group_2.272.1063449917 +RECOC1/DB1/ONLINELOG/group_2.281.1063449917 +DATAC1/DB1/ONLINELOG/group_1.273.1063449917 +RECOC1/DB1/ONLINELOG/group_1.282.1063449919 +DATAC1/DB1/ONLINELOG/group_3.268.1063450555 +RECOC1/DB1/ONLINELOG/group_3.283.1063450557 +DATAC1/DB1/ONLINELOG/group_4.261.1063450557 +RECOC1/DB1/ONLINELOG/group_4.284.1063450557 - 为每个
redo日志添加备用日志文件组。例如，如果您有三个redo日志文件，请添加三个备用日志文件组。SQL> alter database add standby logfile group 5 ('+DATAC1','+RECOC1'); alter database add standby logfile group 6 ('+DATAC1','+RECOC1'); alter database add standby logfile group 7 ('+DATAC1','+RECOC1'); - 查看日志文件的成员。
SQL> select member from v$logfile;输出将类似于以下内容：MEMBER -------------------------------------------------------------------------------- +DATAC1/DB1/ONLINELOG/group_2.272.1063449917 +RECOC1/DB1/ONLINELOG/group_2.281.1063449917 +DATAC1/DB1/ONLINELOG/group_1.273.1063449917 +RECOC1/DB1/ONLINELOG/group_1.282.1063449919 +DATAC1/DB1/ONLINELOG/group_5.264.1063812687 +DATAC1/DB1/ONLINELOG/group_3.268.1063450555 +RECOC1/DB1/ONLINELOG/group_3.283.1063450557 +DATAC1/DB1/ONLINELOG/group_4.261.1063450557 +RECOC1/DB1/ONLINELOG/group_4.284.1063450557 +RECOC1/DB1/ONLINELOG/group_5.422.1063812687 +DATAC1/DB1/ONLINELOG/group_6.262.1063812785 +RECOC1/DB1/ONLINELOG/group_6.445.1063812785 +DATAC1/DB1/ONLINELOG/group_7.263.1063812807 +RECOC1/DB1/ONLINELOG/group_7.446.1063812807 - 查看日志文件的组号和成员。
SQL> select group#,member from v$logfile;输出将类似于以下内容：GROUP# MEMBER ------------ -------------------------------------------------- 2 +DATAC1/DB1/ONLINELOG/group_2.272.1063449917 2 +RECOC1/DB1/ONLINELOG/group_2.281.1063449917 1 +DATAC1/DB1/ONLINELOG/group_1.273.1063449917 1 +RECOC1/DB1/ONLINELOG/group_1.282.1063449919 5 +DATAC1/DB1/ONLINELOG/group_5.264.1063812687 3 +DATAC1/DB1/ONLINELOG/group_3.268.1063450555 3 +RECOC1/DB1/ONLINELOG/group_3.283.1063450557 4 +DATAC1/DB1/ONLINELOG/group_4.261.1063450557 4 +RECOC1/DB1/ONLINELOG/group_4.284.1063450557 5 +RECOC1/DB1/ONLINELOG/group_5.422.1063812687 6 +DATAC1/DB1/ONLINELOG/group_6.262.1063812785 6 +RECOC1/DB1/ONLINELOG/group_6.445.1063812785 7 +DATAC1/DB1/ONLINELOG/group_7.263.1063812807 7 +RECOC1/DB1/ONLINELOG/group_7.446.1063812807 - 在 Oracle Data Guard 中查看配置。
DGMGRL> show configuration输出将类似于以下内容：Configuration - onpremexadr Protection Mode: MaxPerformance Members: db1 - Primary database db1_phx3g7 - Physical standby database Warning: ORA-16809: multiple warnings detected for the member Fast-Start Failover: Disabled Configuration Status: WARNING (status updated 8 seconds ago) - 在备用 Oracle Database Exadata Cloud Service 上，查看重做日志。
select member from v$logfile;输出将类似于以下内容：MEMBER --------------------------------------------------- /opt/oracle/oradata/ORCLCDB/redo03.log /opt/oracle/oradata/ORCLCDB/redo02.log /opt/oracle/oradata/ORCLCDB/redo01.log - 使用
sys用户名和口令登录备用 Oracle Database Exadata Cloud Service 数据库实例上的 Oracle Data Guard 命令行界面 (command-line interface, DGMGRL) 会话。[oracle@droci admin]$ dgmgrl DGMGRL> connect - 在 OCI 中查看备用数据库上的配置。
DGMGRL> show configuration;输出将类似于以下内容：Configuration - OnPremDr Protection Mode: MaxPerformance Members: db1 - Primary database db1_phx3g7 - Physical standby database Warning: ORA-16809: multiple warnings detected for the member Fast-Start Failover: Disabled Configuration Status: WARNING (status updated 38 seconds ago) - 编辑 OCI 中的备用数据库实例并将状态设置为
apply-off。命令成功后，退出命令行界面。DGMGRL> edit database DB1_phx3g7 set state=apply-off;DGMGRL> exit - 以
sysdba身份登录 OCI 中的备用数据库实例。[oracle@exacs82-vm3sv1 ~]$ sqlplus / as sysdba - 查看日志文件的组号和成员。
SQL> select group#,member from v$logfile;输出将类似于以下内容：GROUP# ---------- MEMBER -------------------------------------------------------------------------------- 2 +DATAC1/DB1_PHX3G7/ONLINELOG/group_2.354.1063638089 3 +DATAC1/DB1_PHX3G7/ONLINELOG/group_3.355.1063638089 1 +DATAC1/DB1_PHX3G7/ONLINELOG/group_1.353.1063638089 4 +DATAC1/DB1_PHX3G7/ONLINELOG/group_4.356.1063638089 - 查看每个组的大小。
select bytes, group# from v$log;输出将类似于以下内容：BYTES GROUP# ---------- ---------- 209715200 1 209715200 2 209715200 3 209715200 4 - 将备用日志文件组添加到 OCI 中的数据库。
[oracle@exacs82-vm3sv1 ~]$ sqlplus / as sysdbaalter database add standby logfile group 5 ('+DATAC1','+RECOC1'); alter database add standby logfile group 6 ('+DATAC1','+RECOC1'); alter database add standby logfile group 7 ('+DATAC1','+RECOC1'); - 查看日志文件的组号和成员。
SQL> select group#,member from v$logfile;输出将类似于以下内容：GROUP# ---------- MEMBER -------------------------------------------------------------------------------- 2 +DATAC1/DB1_PHX3G7/ONLINELOG/group_2.354.1063638089 3 +DATAC1/DB1_PHX3G7/ONLINELOG/group_3.355.1063638089 1 +DATAC1/DB1_PHX3G7/ONLINELOG/group_1.353.1063638089 4 +DATAC1/DB1_PHX3G7/ONLINELOG/group_4.356.1063638089 5 +DATAC1/DB1_PHX3G7/ONLINELOG/group_5.358.1063813749 5 +RECOC1/DB1_PHX3G7/ONLINELOG/group_5.256.1063813749 6 +DATAC1/DB1_PHX3G7/ONLINELOG/group_6.359.1063813761 6 +RECOC1/DB1_PHX3G7/ONLINELOG/group_6.262.1063813761 7 +DATAC1/DB1_PHX3G7/ONLINELOG/group_7.360.1063813773 7 +RECOC1/DB1_PHX3G7/ONLINELOG/group_7.300.1063813773 - 在备用 OCI 数据库实例上，使用
sys用户名和口令登录到 Oracle Data Guard 命令行界面 (command-line interface, DGMGRL) 会话。[oracle@exacs82-vm3sv1 ~]$ dgmgrl DGMGRL> connect Username: sys Password:Connected to "DB1_phx3g7" Connected as SYSDBA. - 编辑 OCI 中的备用数据库实例并将状态设置为
apply-on。DGMGRL> edit database db1_phx3g7 set state=apply-on; - 在 OCI 中编辑备用数据库实例并将传输状态设置为
transport-on，然后退出命令行界面。命令成功后，退出 DGMGRL。DGMGRL> edit database DB1 set state=transport-on;DGMGRL> exit - 查看 OCI 上的备用数据库中的备用日志文件以验证备用数据库。
SQL> select * from v$logfile where type='STANDBY'; - 查看 OCI 上的备用数据库中的重做日志文件。
SQL> select member from v$logfile where type != 'STANDBY';输出将类似于以下内容：MEMBER -------------------------------------------------------------------------------- +DATAC1/DB1_PHX3G7/ONLINELOG/group_2.354.1063638089 +DATAC1/DB1_PHX3G7/ONLINELOG/group_3.355.1063638089 +DATAC1/DB1_PHX3G7/ONLINELOG/group_1.353.1063638089 +DATAC1/DB1_PHX3G7/ONLINELOG/group_4.356.1063638089 - 恢复管理的备用数据库。
SQL> recover managed standby database cancel;输出将类似于以下内容：Media recovery complete - 使用
convert参数查看文件。SQL> show parameter convert;输出将类似于以下内容：NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_file_name_convert string DB1, DB1_phx3g7 log_file_name_convert string DB1, DB1_phx3g7 pdb_file_name_convert string - 查看数据库文件。
select name from v$datafile;输出将类似于以下内容：NAME -------------------------------------------------------------------------------- +DATAC1/DB1_PHX3G7/DATAFILE/system.348.1063638053 +DATAC1/DB1_PHX3G7/DATAFILE/sysaux.349.1063638055 +DATAC1/DB1_PHX3G7/DATAFILE/undotbs1.350.1063638057 +DATAC1/DB1_PHX3G7/DATAFILE/undotbs2.351.1063638057 +DATAC1/DB1_PHX3G7/DATAFILE/users.352.1063638059 - 查看 Oracle Data Guard 档案详细信息。
SQL> SELECT ROLE, THREAD#, SEQUENCE#, ACTION FROM V$DATAGUARD_PROCESS;输出将类似于以下内容：ROLE THREAD# SEQUENCE# ACTION ------------------------ ---------- ---------- ------------ RFS ping 1 0 IDLE RFS ping 2 62 IDLE RFS async 2 62 RECEIVING broker instance worker 0 0 IDLE broker worker 0 0 IDLE archive redo 0 0 IDLE archive redo 0 0 IDLE archive redo 0 0 IDLE archive local 0 0 IDLE redo transport timer 0 0 IDLE gap manager 0 0 IDLE ROLE THREAD# SEQUENCE# ACTION ------------------------ ---------- ---------- ------------ broker monitor 0 0 IDLE broker net worker 0 0 IDLE redo transport monitor 0 0 IDLE log writer 0 0 IDLE RFS async 0 187 RECEIVING 16 rows selected. - 禁用使用日志文件恢复管理的备用数据库。
SQL> recover managed standby database using current logfile disconnect;Media recovery complete. - 使用目标参数显示文件并验证。
SQL>show parameter dest;