Oracle 19c RAC to RAC DataGuard (ADG) 实施详细信息
本文详细介绍ORACLE 19C RAC集群到RAC集群的DataGuard 配置步骤
系统IP配置
[oracle@ora19c-pdb1:/home/oracle]$cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6#ora19c-pridb172.16.108.219 openfiler172.16.108.154 ora19c-pdb1172.16.108.155 ora19c-pvip110.10.10.155 ora19c-ppriv1172.16.108.156 ora19c-pdb2172.16.108.157 ora19c-pvip210.10.10.157 ora19c-ppriv2172.16.108.158 ora19c-pscan#ora19c-stddb172.16.108.202 ora19c-sdb1172.16.108.203 ora19c-svip110.10.10.203 ora19c-spriv1172.16.108.204 ora19c-sdb2172.16.108.205 ora19c-svip210.10.10.205 ora19c-spriv2172.16.108.206 ora19c-sscan主备库数据库配置信息
主库
[oracle@ora19c-pdb1:/home/oracle]$srvctl config database -d primarydbDatabase unique name: primarydbDatabase name: primarydOracle home: /u01/app/oracle/product/19.0.0/db_1Oracle user: oracleSpfile: +ORADATA/PRIMARYDB/PARAMETERFILE/spfile.256.1018264155Password file: +oradata/PRIMARYDB/PASSWORD/pwdprimarydb.288.1018264613Domain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools:Disk Groups: RECOVER,ORADATAMount point paths:Services:Type: RACStart concurrency:Stop concurrency:OSDBA group: dbaOSOPER group: operDatabase instances: ora19c1,ora19c2Configured nodes: ora19c-pdb1,ora19c-pdb2CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services:Database is administrator managed备库
[oracle@ora19c-sdb1:/home/oracle]$srvctl config database -d standbydbDatabase unique name: standbydbDatabase name: primarydOracle home: /u01/app/oracle/product/19.0.0/db_1Oracle user: oracleSpfile: +oradata/standbydb/PARAMETERFILE/spfile.374.1018532261Password file: +ORADATA/ASM/PASSWORD/pwdasm.362.1018532119Domain:Start options: read onlyStop options: immediateDatabase role: PHYSICAL_STANDBYManagement policy: AUTOMATICServer pools:Disk Groups: ORADATA,RECOVERMount point paths:Services:Type: RACStart concurrency:Stop concurrency:OSDBA group: dbaOSOPER group: operDatabase instances: ora19c1,ora19c2Configured nodes: ora19c-sdb1,ora19c-sdb2CSS critical: noCPU count: 0Memory target: 0Maximum memory: 0Default network number for database services:Database is administrator managedSPFILE文件配置
主库
[oracle@ora19c-pdb1:/home/oracle]$cat 19c-primarydb.oraora19c2.__data_transfer_cache_size=0ora19c1.__data_transfer_cache_size=0ora19c2.__db_cache_size=3841982464ora19c1.__db_cache_size=3825205248ora19c2.__inmemory_ext_roarea=0ora19c1.__inmemory_ext_roarea=0ora19c2.__inmemory_ext_rwarea=0ora19c1.__inmemory_ext_rwarea=0ora19c2.__java_pool_size=0ora19c1.__java_pool_size=0ora19c2.__large_pool_size=117440512ora19c1.__large_pool_size=117440512ora19c1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentora19c2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentora19c2.__pga_aggregate_target=1694498816ora19c1.__pga_aggregate_target=1694498816ora19c2.__sga_target=5049942016ora19c1.__sga_target=5049942016ora19c2.__shared_io_pool_size=134217728ora19c1.__shared_io_pool_size=134217728ora19c2.__shared_pool_size=939524096ora19c1.__shared_pool_size=956301312ora19c2.__streams_pool_size=0ora19c1.__streams_pool_size=0ora19c2.__unified_pga_pool_size=0ora19c1.__unified_pga_pool_size=0*.audit_file_dest='/u01/app/oracle/admin/primarydb/adump'*.audit_trail='db'*.cluster_database=true*.compatible='19.0.0'*.control_files='+ORADATA/PRIMARYDB/CONTROLFILE/current.261.1018184563','+RECOVER/PRIMARYDB/CONTROLFILE/current.256.1018184563'*.db_block_size=8192*.db_create_file_dest='+ORADATA'*.db_file_name_convert='PRIMARYDB','STANDBYDB'*.db_name='primaryd'*.db_recovery_file_dest='+RECOVER'*.db_recovery_file_dest_size=13332m*.db_unique_name='primarydb'ora19c1.dg_broker_config_file1='+ORADATA/dgmgr/ora19c1.dat'ora19c2.dg_broker_config_file1='+ORADATA/dgmgr/ora19c1.dat'ora19c1.dg_broker_config_file2='+RECOVER/dgmgr/ora19c2.dat'ora19c2.dg_broker_config_file2='+RECOVER/dgmgr/ora19c2.dat'*.dg_broker_start=TRUE*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora19cXDB)'*.enable_pluggable_database=true*.fal_client='primarydb'*.fal_server=''family:dw_helper.instance_mode='read-only'ora19c2.instance_number=2ora19c1.instance_number=1*.local_listener='-oraagent-dummy-'*.log_archive_config='dg_config=(primarydb,standbydb)'*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primarydb'*.log_archive_dest_2='service="standbydb"','ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 reopen=300 db_unique_name="standbydb" net_timeout=30','valid_for=(online_logfile,all_roles)'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.dbf'*.log_file_name_convert='PRIMARYDB','STANDBYDB'*.nls_language='AMERICAN'*.nls_territory='CHINA'*.open_cursors=300*.pga_aggregate_target=1605m*.processes=960*.remote_login_passwordfile='exclusive'*.sga_target=4812m*.standby_file_management='AUTO'ora19c2.thread=2ora19c1.thread=1ora19c2.undo_tablespace='UNDOTBS2'ora19c1.undo_tablespace='UNDOTBS1'[oracle@ora19c-pdb1:/home/oracle]$备库
[oracle@ora19c-sdb1:/home/oracle]$cat 19c-standbydb.oraora19c2.__data_transfer_cache_size=0ora19c1.__data_transfer_cache_size=0ora19c2.__db_cache_size=3841982464ora19c1.__db_cache_size=3841982464ora19c2.__inmemory_ext_roarea=0ora19c1.__inmemory_ext_roarea=0ora19c2.__inmemory_ext_rwarea=0ora19c1.__inmemory_ext_rwarea=0ora19c2.__java_pool_size=0ora19c1.__java_pool_size=0ora19c2.__large_pool_size=117440512ora19c1.__large_pool_size=117440512ora19c1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentora19c2.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentora19c2.__pga_aggregate_target=1694498816ora19c1.__pga_aggregate_target=1694498816ora19c2.__sga_target=5049942016ora19c1.__sga_target=5049942016ora19c2.__shared_io_pool_size=134217728ora19c1.__shared_io_pool_size=134217728ora19c2.__shared_pool_size=939524096ora19c1.__shared_pool_size=939524096ora19c2.__streams_pool_size=0ora19c1.__streams_pool_size=0ora19c2.__unified_pga_pool_size=0ora19c1.__unified_pga_pool_size=0*.audit_file_dest='/u01/app/oracle/admin/standbydb/adump'*.audit_trail='db'*.cluster_database=true*.compatible='19.0.0'*.control_files='+ORADATA/STANDBYDB/CONTROLFILE/current.371.1018533407','+RECOVER/STANDBYDB/CONTROLFILE/current.299.1018533407'#Restore Controlfile*.db_block_size=8192*.db_create_file_dest='+ORADATA'*.db_file_name_convert='PRIMARYDB','STANDBYDB'*.db_name='primaryd'*.db_recovery_file_dest_size=13332m*.db_recovery_file_dest='+RECOVER'*.db_unique_name='standbydb'ora19c1.dg_broker_config_file1='+ORADATA/dgmgr/ora19c1.dat'ora19c2.dg_broker_config_file1='+ORADATA/dgmgr/ora19c1.dat'ora19c1.dg_broker_config_file2='+RECOVER/dgmgr/ora19c2.dat'ora19c2.dg_broker_config_file2='+RECOVER/dgmgr/ora19c2.dat'*.dg_broker_start=TRUE*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora19cXDB)'*.enable_pluggable_database=true*.fal_client='standbydb'*.fal_server='primarydb'family:dw_helper.instance_mode='read-only'ora19c2.instance_number=2ora19c1.instance_number=1*.local_listener='-oraagent-dummy-'*.log_archive_config='dg_config=(standbydb,primarydb)'*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standbydb'*.log_archive_dest_2=''*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.dbf'*.log_file_name_convert='PRIMARYDB','STANDBYDB'*.nls_language='AMERICAN'*.nls_territory='CHINA'*.open_cursors=300*.pga_aggregate_target=1605m*.processes=960*.remote_login_passwordfile='exclusive'*.sga_target=4812m*.standby_file_management='auto'ora19c2.thread=2ora19c1.thread=1ora19c2.undo_tablespace='UNDOTBS2'ora19c1.undo_tablespace='UNDOTBS1'[oracle@ora19c-sdb1:/home/oracle]$监听配置-LISTENER.ORA
主库监听
[grid@ora19c-pdb1:/u01/app/19.0.0/grid/network/admin]$cat listener.ora# listener.ora Network Configuration File: /u01/app/19.0.0/grid/network/admin/listener.ora# Generated by Oracle configuration tools.ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ONSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = primarydb) (ORACLE_HOME = /u01/app/19.0.0/grid) (SID_NAME = ora19c1) ) (SID_DESC = (GLOBAL_DBNAME = standbydb) (ORACLE_HOME = /u01/app/19.0.0/grid) (SID_NAME = ora19c1) ) (SID_DESC = (GLOBAL_DBNAME = primarydb_DGMGRL) (SID_NAME = ora19c1) (ORACLE_HOME = /u01/app/19.0.0/grid) ) (SID_DESC = (GLOBAL_DBNAME = standbydb_DGMGRL) (SID_NAME = ora19c1) (ORACLE_HOME = /u01/app/19.0.0/grid) ) )SID_LIST_LISTENER_SCAN1 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = primarydb) (SID_NAME = ora19c1) (ORACLE_HOME = /u01/app/19.0.0/grid) ) )VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1 = OFFVALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM = SUBNETASMNET1LSNR_ASM = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = ASMNET1LSNR_ASM)) )VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNETLISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER)) )ADR_BASE_LISTENER = /u01/app/gridENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM = ONENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ONADR_BASE_ASMNET1LSNR_ASM = /u01/app/gridLISTENER_SCAN1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1)) )ADR_BASE_LISTENER_SCAN1 = /u01/app/grid[grid@ora19c-pdb1:/u01/app/19.0.0/grid/network/admin]$备库监听
[grid@ora19c-sdb1:/u01/app/19.0.0/grid/network/admin]$cat listener.ora# listener.ora Network Configuration File: /u01/app/19.0.0/grid/network/admin/listener.ora# Generated by Oracle configuration tools.ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ONSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = standbydb) (ORACLE_HOME = /u01/app/19.0.0/grid) (SID_NAME = ora19c1) ) (SID_DESC = (GLOBAL_DBNAME = primarydb) (ORACLE_HOME = /u01/app/19.0.0/grid) (SID_NAME = ora19c1) ) (SID_DESC = (GLOBAL_DBNAME = primarydb_DGMGRL) (SID_NAME = ora19c1) (ORACLE_HOME = /u01/app/19.0.0/grid) ) (SID_DESC = (GLOBAL_DBNAME = standbydb_DGMGRL) (SID_NAME = ora19c1) (ORACLE_HOME = /u01/app/19.0.0/grid) ) )SID_LIST_LISTENER_SCAN1 = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = standbydb) (SID_NAME = ora19c1) (ORACLE_HOME = /u01/app/19.0.0/grid) ) )VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1 = OFFVALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM = SUBNETASMNET1LSNR_ASM = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = ASMNET1LSNR_ASM)) )VALID_NODE_CHECKING_REGISTRATION_LISTENER = SUBNETLISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER)) )ADR_BASE_LISTENER = /u01/app/gridENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM = ONENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ONADR_BASE_ASMNET1LSNR_ASM = /u01/app/gridLISTENER_SCAN1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1)) )ADR_BASE_LISTENER_SCAN1 = /u01/app/grid[grid@ora19c-sdb1:/u01/app/19.0.0/grid/network/admin]$TNSNAME配置
主备库一致
[root@ora19c-pdb1 ~]# cat /u01/app/oracle/product/19.0.0/db_1/network/admin/tnsnames.ora# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/db_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.PRIMARYDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c-pscan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = primarydb) ) )STANDBYDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c-sscan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = standbydb) ) )PRIMARYDB1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c-pvip1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ora19c1) ) )PRIMARYDB2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c-pvip2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ora19c2) ) )STANDBYDB1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c-svip1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ora19c1) ) )STANDBYDB2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ora19c-svip2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ora19c2) ) )[root@ora19c-pdb1 ~]#配置过程
主库dg配置参数
[oracle@ora19c-pdb1:/home/oracle]$sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 12 10:59:39 2019Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL> set line 1000set pagesize 1000col name format a25col VALUE format a100SELECT a.NAME, i.instance_name, a.VALUEFROM v$parameter a, v$instance iWHERE a.name in ('dg_broker_start','db_name','db_unique_name','log_archive_config','log_archive_dest_1','log_archive_dest_2','log_archive_dest_state_1','log_archive_dest_state_2','log_archive_max_processes','remote_login_passwordfile','db_file_name_convert','log_file_name_convert','standby_file_management','fal_server','fal_client','dg_broker_config_file1','dg_broker_config_file2')ORDER BY a.name, i.instance_name;SQL> SQL> SQL> SQL> 2 3 4 5 6NAME INSTANCE_NAME VALUE------------------------- ---------------- ----------------------------------------------------------------------------------------------------db_file_name_convert ora19c1 PRIMARYDB, STANDBYDBdb_name ora19c1 primaryddb_unique_name ora19c1 primarydbdg_broker_config_file1 ora19c1 +ORADATA/dgmgr/ora19c1.datdg_broker_config_file2 ora19c1 +RECOVER/dgmgr/ora19c2.datdg_broker_start ora19c1 TRUEfal_client ora19c1 primarydbfal_server ora19c1log_archive_config ora19c1 dg_config=(primarydb,standbydb)log_archive_dest_1 ora19c1 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primarydblog_archive_dest_2 ora19c1 service="standbydb", ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 reopen=300 db _unique_name="standbydb" net_timeout=30, valid_for=(online_logfile,all_roles)log_archive_dest_state_1 ora19c1 enablelog_archive_dest_state_2 ora19c1 ENABLElog_archive_max_processes ora19c1 4log_file_name_convert ora19c1 PRIMARYDB, STANDBYDBremote_login_passwordfile ora19c1 EXCLUSIVEstandby_file_management ora19c1 AUTO17 rows selected.SQL>备库库dg配置参数 备注:由于使用了BROCKER所以查询配置被修改，以pfile文件为准
[oracle@ora19c-sdb1:/home/oracle]$sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 12 10:57:00 2019Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - ProductionVersion 19.3.0.0.0SQL>SQL>SQL> set line 1000set pagesize 1000col name format a25col VALUE format a100SELECT a.NAME, i.instance_name, a.VALUEFROM v$parameter a, v$instance iWHERE a.name in ('dg_broker_start','db_name','db_unique_name','log_archive_config','log_archive_dest_1','log_archive_dest_2','log_archive_dest_state_1','log_archive_dest_state_2','log_archive_max_processes','remote_login_passwordfile','db_file_name_convert','log_file_name_convert','standby_file_management','fal_server','fal_client','dg_broker_config_file1','dg_broker_config_file2')ORDER BY a.name, i.instance_name;SQL> SQL> SQL> SQL> 2 3 4 5 6NAME INSTANCE_NAME VALUE------------------------- ---------------- ----------------------------------------------------------------------------------------------------db_file_name_convert ora19c1 PRIMARYDB, STANDBYDBdb_name ora19c1 primaryddb_unique_name ora19c1 standbydbdg_broker_config_file1 ora19c1 +ORADATA/dgmgr/ora19c1.datdg_broker_config_file2 ora19c1 +RECOVER/dgmgr/ora19c2.datdg_broker_start ora19c1 TRUEfal_client ora19c1 standbydbfal_server ora19c1 primarydblog_archive_config ora19c1 dg_config=(standbydb,primarydb)log_archive_dest_1 ora19c1 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standbydblog_archive_dest_2 ora19c1log_archive_dest_state_1 ora19c1 enablelog_archive_dest_state_2 ora19c1 ENABLElog_archive_max_processes ora19c1 4log_file_name_convert ora19c1 PRIMARYDB, STANDBYDBremote_login_passwordfile ora19c1 EXCLUSIVEstandby_file_management ora19c1 AUTO17 rows selected.SQL>NAME INSTANCE_NAME VALUE------------------------- ---------------- ----------------------------------------------------------------------------------------------------#########################################################主库db_file_name_convert ora19c1 PRIMARYDB, STANDBYDBdb_name ora19c1 primaryddb_unique_name ora19c1 primarydbdg_broker_config_file1 ora19c1 +ORADATA/dgmgr/ora19c1.datdg_broker_config_file2 ora19c1 +RECOVER/dgmgr/ora19c2.datdg_broker_start ora19c1 TRUEfal_client ora19c1 primarydbfal_server ora19c1 standbydblog_archive_config ora19c1 dg_config=(primarydb,standbydb)log_archive_dest_1 ora19c1 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primarydblog_archive_dest_2 ora19c1 service=standbydb VALID_FOR=(online_logfiles,primary_role) DB_UNIQUE_NAME=standbydblog_archive_dest_state_1 ora19c1 enablelog_archive_dest_state_2 ora19c1 enablelog_archive_max_processes ora19c1 4log_file_name_convert ora19c1 PRIMARYDB, STANDBYDBremote_login_passwordfile ora19c1 EXCLUSIVEstandby_file_management ora19c1 AUTO#########################################################备库db_file_name_convert ora19c1 PRIMARYDB, STANDBYDBdb_name ora19c1 primaryddb_unique_name ora19c1 standbydbdg_broker_config_file1 ora19c1 +ORADATA/dgmgr/ora19c1.datdg_broker_config_file2 ora19c1 +RECOVER/dgmgr/ora19c2.datdg_broker_start ora19c1 TRUEfal_client ora19c1 standbydbfal_server ora19c1 primarydblog_archive_config ora19c1 dg_config=(primarydb,standbydb)log_archive_dest_1 ora19c1 LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standbydblog_archive_dest_2 ora19c1 service=primarydb VALID_FOR=(online_logfiles,primary_role) DB_UNIQUE_NAME=primarydblog_archive_dest_state_1 ora19c1 enablelog_archive_dest_state_2 ora19c1 enablelog_archive_max_processes ora19c1 4log_file_name_convert ora19c1 PRIMARYDB, STANDBYDBremote_login_passwordfile ora19c1 EXCLUSIVEstandby_file_management ora19c1 AUTO添加standby log
alter database add standby logfile thread 1 group 11 ('+RECOVER','+ORADATA') size 200m;alter database add standby logfile thread 1 group 12 ('+RECOVER','+ORADATA') size 200m;alter database add standby logfile thread 1 group 13 ('+RECOVER','+ORADATA') size 200m;alter database add standby logfile thread 2 group 14 ('+RECOVER','+ORADATA') size 200m;alter database add standby logfile thread 2 group 15 ('+RECOVER','+ORADATA') size 200m;alter database add standby logfile thread 2 group 16 ('+RECOVER','+ORADATA') size 200m;dg参数配置查询脚本set line 1000set pagesize 1000col name format a25col VALUE format a100SELECT a.NAME, i.instance_name, a.VALUEFROM gv$parameter a, gv$instance iWHERE a.inst_id = i.inst_id and a.name in ('dg_broker_start','db_name','db_unique_name','log_archive_config','log_archive_dest_1','log_archive_dest_2','log_archive_dest_state_1','log_archive_dest_state_2','log_archive_max_processes','remote_login_passwordfile','db_file_name_convert','log_file_name_convert','standby_file_management','fal_server','fal_client','dg_broker_config_file1','dg_broker_config_file2')ORDER BY a.name, i.instance_name;参数修改配置alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primarydb' sid='*';alter system set LOG_ARCHIVE_DEST_2='service=standbydb VALID_FOR=(online_logfiles,primary_role) DB_UNIQUE_NAME=primarydb' sid='*';alter system set log_archive_config='dg_config=(primarydb,standbydb)' sid='*';alter system set db_file_name_convert='+ORADATA','+ORADATA','+RECOVER','+RECOVER' scope=spfile sid='*';alter system set log_file_name_convert='+ORADATA','+ORADATA','+RECOVER','+RECOVER' scope=spfile sid='*';alter system set standby_file_management=auto scope=spfile sid='*';alter system set fal_client='primarydb' sid='*';alter system set fal_server='standbydb' sid='*';备库添加数据库相关操作srvctl add database -d standbydb -o /u01/app/oracle/product/19.0.0/db_1 -n primaryd -p +oradata/standbydb/PARAMETERFILE/spfile.374.1018532261 -pwfile +ORADATA/ASM/PASSWORD/pwdasm.362.1018532119 -dbtype RACsrvctl modify database -d standbydb -a "ORADATA,RECOVER"srvctl add instance -d standbydb -i ora19c1 -n ora19c-sdb1srvctl add instance -d standbydb -i ora19c2 -n ora19c-sdb2rman target sys/oracle@primarydb auxiliary sys/oracle@standbydbduplicate target database for standby from active database nofilenamecheck;srvctl modify database -d standbydb -role PHYSICAL_STANDBYsrvctl modify database -d primarydb -p +ORADATA/PRIMARYDB/PARAMETERFILE/spfile.256.1018264155;srvctl modify database -d primarydb -pwfile +oradata/PRIMARYDB/PASSWORD/pwdprimarydb.288.1018264613srvctl add database -d standbydb -o /u01/app/oracle/product/19.0.0/db_1 -n primaryd -p +oradata/STANDBYDB/PARAMETERFILE/spfile.260.1018265063srvctl modify database -d standbydb -a "ORADATA,RECOVER"srvctl add instance -d standbydb -i ora19c1 -n ora19c-sdb1srvctl add instance -d standbydb -i ora19c2 -n ora19c-sdb2srvctl config database -d standbydbcreate configuration 'ora19c_cfg' as primary database is 'primarydb' connect identifier is 'primarydb';add database 'standbydb' as connect identifier is 'standbydb';