-- 主库的在线日志组数为 8 组 set line222 set pagesize1000 col member for a60 select t2.thread#,t1.group#,t1.member,t2.bytes/1024/1024 from v$logfile t1,v$log t2 where t1.group#=t2.group# order by 1,2;
TNSLSNR for Linux: Version 19.0.0.0.0 - Production Systemparameter file is /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/luciferdg/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=luciferdg)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=luciferdg)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 21-APR-2025 11:20:55 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/19.3.0/db/network/admin/listener.ora Listener LogFile /u01/app/oracle/diag/tnslsnr/luciferdg/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=luciferdg)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) The listener supports no services The command completed successfully
Prepare for db operation 22% complete Listener config step 44% complete Auxiliary instance creation 67% complete RMAN duplicate 89% complete Post duplicate database operations 100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcldg/orcldg5.log"for further details.
创建过程十分便捷，等待完成即可。
题外话，这里如果创建报错，可以执行以下命令删除对应的 DB 即可：
1
dbca -deleteDatabase -sourceDB orcl -silent
然后重新执行。
主库设置 ADG 参数
1 2 3 4 5 6
SQL> alter system setlog_archive_config='DG_CONFIG=(ORCL,ORCLDG)'; alter system setlog_archive_dest_1='LOCATION=/oradata/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCL'; alter system setlog_archive_dest_2='SERVICE=ORCL_STB VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCLDG'; alter system setfal_client='ORCL_PRI'; alter system setfal_server='ORCL_STB'; alter system setlog_archive_dest_state_2=enable;
备库设置 ADG 参数
1 2 3 4 5 6
SQL> alter system setfal_client='ORCL_STB'; alter system setfal_server='ORCL_PRI'; alter system setlog_archive_config='dg_config=(ORCL,ORCLDG)'; alter system setlog_archive_dest_1='LOCATION=/oradata/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ORCLDG'; alter system setlog_archive_dest_2='SERVICE=ORCL_PRI VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL'; alter system setstandby_file_management='AUTO';
-- 主库 SQL> set line2222 pages1000 col status for a10 col typefor a10 col error for a20 col gap_status for a20 col synchronization_status for a30 col recovery_mode for a60 select inst_id,status,DEST_ID,TYPE,ERROR,GAP_STATUS,SYNCHRONIZED,SYNCHRONIZATION_STATUS,RECOVERY_MODE from GV$ARCHIVE_DEST_STATUS where STatus <> 'INACTIVE'andtype = 'PHYSICAL';
INST_ID STATUS DEST_ID TYPE ERROR GAP_STATUS SYN SYNCHRONIZATION_STATUS RECOVERY_MODE ---------- ---------- ---------- ---------- -------------------- -------------------- --- ------------------------------ ------------------------------------------------------------ 1VALID2 PHYSICAL NO GAP NOCHECKCONFIGURATION MANAGED REALTIME APPLY WITH QUERY
-- 备库 set line2222 pages1000 select process,thread#,group#,sequence#,status from gv$managed_standby;
