Oracle_19C_ADG_数据网络_搭建思路

[root@pdg ~]# su - grid[grid@pdg ~]$ vim oracle/19.0.0/grid/network/admin/listener.oraLISTENER_DG =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1525)))))SID_LIST_LISTENER_DG =(SID_LIST =(SID_DESC =(ORACLE_HOME = /oracle/app/oracle/product/19.0.0/dbhome_1)(SID_NAME = test)(GLOBAL_DBNAME = test)))

lsnrctl start LISTENER_DGlsnrctl status LISTENER_DG

LISTENER_DG =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.21)(PORT = 1525)))))SID_LIST_LISTENER_DG =(SID_LIST =(SID_DESC =(ORACLE_HOME = /oracle/app/oracle/product/19.0.0/dbhome_1)(SID_NAME = test)(GLOBAL_DBNAME = test)))

lsnrctl start LISTENER_DGlsnrctl status LISTENER_DG

[root@pdg ~]# su - oracle[oracle@pdg ~]$ vim oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.orapdg =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1525)))(CONNECT_DATA =(SERVICE_NAME = test)))sdg =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.21)(PORT = 1525)))(CONNECT_DATA =(SERVICE_NAME = test)(UR=A)))

[root@sdg ~]# su – oracle[oracle@sdg ~]$ vim oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.orapdg =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1525)))(CONNECT_DATA =(SERVICE_NAME = test)))sdg =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.21)(PORT = 1525)))(CONNECT_DATA =(SERVICE_NAME = test)(UR=A)))

tnsping pdgtnsping sdg

SQL> shutdown immediate;SQL> startup mount;SQL> alter system set log_archive_dest_1='location=+data/arch';SQL> alter database archivelog;SQL> alter database open;

SQL> select name,log_mode,force_logging from v$database;NAME LOG_MODE FORCE_LOGGING--------- ------------ ---------------------------------------TEST ARCHIVELOG NOSQL>  alter database force logging;Database altered.SQL> select name,log_mode,force_logging from v$database;NAME LOG_MODE FORCE_LOGGING--------- ------------ ---------------------------------------TEST ARCHIVELOG YES

alter database add standby logfile group 11 '+data/test/onlinelog/stb01.log' size 200M;alter database add standby logfile group 12 '+data/test/onlinelog/stb02.log' size 200M;alter database add standby logfile group 13 '+data/test/onlinelog/stb03.log' size 200M;alter database add standby logfile group 14 '+data/test/onlinelog/stb04.log' size 200M;SQL> select group#,bytes/1024/1024 from v$standby_log;

alter system set db_unique_name='test' scope=spfile;alter system set log_archive_config='dg_config=(test,sdg)';alter system set log_archive_dest_1='LOCATION=+data/arch valid_for=(all_logfiles,all_roles) db_unique_name=test';alter system set log_archive_dest_2='service=sdg lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=sdg';alter system set log_archive_dest_state_1='enable';alter system set log_archive_dest_state_2='enable';alter system set fal_client='test';alter system set fal_server='sdg';alter system set standby_file_management='AUTO';alter system set db_file_name_convert='+data/test/adg','+data/test/adg'scope=spfile;alter system set log_file_name_convert='+data/test/adg','+data/test/adg'scope=spfile;

create pfile='/oracle/app/oracle/product/19.0.0/dbhome_1/dbs/pfile.ora'scp pfile.ora oracle@192.168.168.21: /oracle/app/oracle/product/19.0.0/dbhome_1/dbs/pfile.orascp orapwtest oracle@192.168.168.21: /oracle/app/oracle/product/19.0.0/dbhome_1/dbs/orapwtest

*.db_file_name_convert='+data/test','+data/test'*.db_name='test'*.db_unique_name='sdg'*.fal_client='sdg'*.fal_server='test'*.log_archive_config='dg_config=(sdg,test)'*.log_archive_dest_1='LOCATION=+data/arch valid_for=(all_logfiles,all_roles) db_unique_name=sdg'*.log_archive_dest_2='service=test lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=test'*.log_archive_dest_state_1='enable'*.log_archive_dest_state_2='enable'*.log_file_name_convert='+data/test','+data/test'

SQL> startup nomount pfile='/oracle/app/oracle/product/19.0.0/dbhome_1/dbs/pfile.ora';ORACLE instance started.Total System Global Area 2516581464 bytesFixed Size 8899672 bytesVariable Size 536870912 bytesDatabase Buffers 1962934272 bytesRedo Buffers 7876608 bytes

[oracle@sdg dbs]$ rman target='sys/oracle'@pdg auxiliary 'sys/oracle'@sdg

duplicate target database for standby nofilenamecheck from active database;

alter database recover managed standby database disconnect from session;

recover managed standby database cancel;

alter database open;

ALTER DATABASE recover managed standby database using current logfile disconnect;

SQL> select database_role,open_mode,switchover_status from v$database;DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS---------------- -------------------- --------------------PHYSICAL STANDBY READ ONLY NOT ALLOWED