【正文】 L startup mount。SQLshutdown immediate。alter system set _trace_files_public=true scope=spfile。 scope=spfile。adgORSSB239。 scope=spfile。alter system set undo_tablespace=39。 scope=spfile。alter system set FAL_SERVER=39。LOCATION=/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=adgORSSB39。 scope=spfile。,39。,39。 考慮到后續(xù)系統(tǒng)存儲(chǔ)擴(kuò)容加盤新建ASMDG的情況，且參數(shù)db_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)db_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對配置，每對的配置順序與ADG正好相反 alter system set log_file_name_convert=39。+P3ORSADGDAT3DG/ADGORSSB/TEMPFILE/39。+P3ORSADGDAT2DG/ADGORSSB/TEMPFILE/39。+P3ORSADGDAT1DG/ADGORSSB/TEMPFILE/39。+P3ORSADGDAT3DG/ADGORSSB/DATAFILE/39。+P3ORSADGDAT2DG/ADGORSSB/DATAFILE/39。+P3ORSADGDAT1DG/ADGORSSB/DATAFILE/39。alter system set LOG_ARCHIVE_MAX_PROCESSES=4。*39。oraORSS239。*39。oraORSS239。DG_CONFIG=(oraORSS,adgORSSB)39。+P3ORSADGDAT1DG’) SIZE 1073741824。+P3ORSADGDAT1DG’) SIZE 1073741824。+P3ORSADGDAT1DG’) SIZE 1073741824。+P3ORSADGDAT1DG’) SIZE 1073741824。ALTER DATABASE ADD STANDBY LOGFILE thread 2 group 14 (39。) SIZE 1073741824。+P3ORSSDAT1DG39。ALTER DATABASE ADD STANDBY LOGFILE thread 1 group 10 (39。) SIZE 1073741824。+P3ORSSDAT1DG39。,………… 如果不能從表空間進(jìn)行分辨的話，可以在創(chuàng)建表空間或者添加數(shù)據(jù)文件時(shí)指定文件的名字進(jìn)行區(qū)分SSD磁盤組，例如：alter tablespace NETIND add datafile ‘+SSD1DG/netdb/datafile/’。,39。,………… 反向映射到主庫中時(shí)，可設(shè)置主庫的文件轉(zhuǎn)換參數(shù)類似如下：39。, 39。因此，可對主庫特殊的數(shù)據(jù)文件映射到ADG端的參數(shù)做特殊標(biāo)識(shí)配置，以便識(shí)別為與其他不同的文件名，例如： 主庫中表空間NETIND數(shù)據(jù)文件放置到SSD1DG磁盤組中，則NETIND表空間的數(shù)據(jù)文件在磁盤組中的名字類似于”+SSD1DG/netdb/datafile/”； ADG端可映射為類似于” +PNETADGDAT1DG/netdbadg/datafile/”，需要注意的是，不能有其他表空間名字前幾位字符與ssdnetind匹配，或者有其他不需要轉(zhuǎn)換的數(shù)據(jù)文件與之匹配； 在ADG端做數(shù)據(jù)文件映射時(shí)，參數(shù)可設(shè)置為如下（需保證如下參數(shù)在配置的前面首先被匹配到）：39。release channel ch004。,39。 設(shè)置備庫的db_create_file_dest參數(shù)為空，禁用OMF set instance_number = 39。 根據(jù)情況設(shè)置備數(shù)據(jù)庫的PGA參數(shù) set memory_target = 39。 根據(jù)情況設(shè)置備數(shù)據(jù)庫的SGA參數(shù) set sga_target = 39。 按照規(guī)范設(shè)置remote_listener參數(shù) set log_archive_dest_2=39。 set audit_file_dest=39。 考慮到后續(xù)系統(tǒng)存儲(chǔ)擴(kuò)容加盤新建ASMDG的情況，且參數(shù)log_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)log_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對配置 set standby_file_management=39。,39。,39。 考慮到后續(xù)系統(tǒng)存儲(chǔ)擴(kuò)容加盤新建ASMDG的情況，且參數(shù)db_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)db_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對配置 set log_file_name_convert=39。,39。,39。,39。,39。,39。 set db_file_name_convert=39。 SET FAL_SERVER=39。,39。allocate auxiliary channel ch005 type disk。rman target sys/oracle123ORSSPRIMARY auxiliary sys/oracle123ADGORSSBTMP EOFORSSPRIMARY為備庫上配置的連接主庫的TNS別名，ADGORSSBTMP為主庫上配置的連接備庫的TNS別名run {allocate channel ch001 type disk。 備數(shù)據(jù)庫控制文件路徑其中主數(shù)據(jù)庫和備數(shù)據(jù)庫在DB_NAME和DB_BLOCK_SIZE必須一致$ vi 該文件內(nèi)容如下：sqlplus / as sysdba EOFstartup nomount pfile=39。,39。 備數(shù)據(jù)庫DB_UNIQUE_NAMEDB_BLOCK_SIZE=8192SGA_TARGET=3221225472db_create_file_dest=39。1. 用戶oracle登錄備節(jié)點(diǎn)p3orssadg1創(chuàng)建dg_work工作目錄Oracle用戶登錄備數(shù)據(jù)庫節(jié)點(diǎn)主機(jī)p3orssadg1$ mkdir dg_work2. 用戶grid登錄備節(jié)點(diǎn)p3orssadg1啟動(dòng)LISTENER_TMP監(jiān)聽grid用戶登錄備數(shù)據(jù)庫節(jié)點(diǎn)主機(jī)p3orssadg1su gridlsnrctl start LISTENER_TMP3. Oracle用戶登錄備數(shù)據(jù)庫節(jié)點(diǎn)主機(jī)p3orssadg1$ cd /home/oracle/dg_work$ vi 該文件內(nèi)容如下：DB_NAME=39。配置完畢后進(jìn)行啟動(dòng)：su gridlsnrctl start LISTENER_TMPDUPLICAT方式初始化備庫完成后將此步操作回退：su gridlsnrctl stop LISTENER_TMP$cd $ORACLE_HOME/network/admin$ vi 刪除如上添加的內(nèi)容4. 用戶grid登錄備節(jié)點(diǎn)p3orssadg1創(chuàng)建LISTENER監(jiān)聽器su gridsrvctl add listener l listener p 1521 s其中紅色部分：LISTENER為監(jiān)聽器名稱，1521為監(jiān)聽端口5. 用戶grid登錄備節(jié)點(diǎn)p3orssadg1啟動(dòng) LISTENER監(jiān)聽器注意：如果使用DUPLICAT方式初始化備庫，則在上面第3步LISTENER_TMP完成前不啟動(dòng)監(jiān)聽，否則會(huì)有端口沖突無法啟動(dòng)srvctl start listener l listener 6. 用戶oracle登錄主節(jié)點(diǎn)p3orssetl1和p3orssetl2添加訪問主數(shù)據(jù)庫和備數(shù)據(jù)庫的TNS別名su oraclecd $ORACLE_HOME/network/admin/vi 添加如下內(nèi)容，紅色部分請根據(jù)環(huán)境進(jìn)行修改ORAORSS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl2vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraORSS) ) ) ORAORSS1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl1vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraORSS) (INSTANCE_NAME = oraORSS1) ) ) ORAORSS2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl2vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraORSS) (INSTANCE_NAME = oraORSS2) ) )LISTENERS_ORAORSS = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl2vip)(PORT = 1521)))ORSSSTANDBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = adgORSSB) ) )ORSSPRIMARY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssetl2vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oraORSS) ) ) ADGORSSBTMP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = adgORSSB) ) )7. 用戶oracle登錄備節(jié)點(diǎn)p3orssadg1和p3orssadg2添加訪問主數(shù)據(jù)庫和備數(shù)據(jù)庫的TNS別名su oraclecd $ORACLE_HOME/network/admin/vi 添加如下內(nèi)容，紅色部分請根據(jù)環(huán)境進(jìn)行修改ORSSPRIMARY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = oraORSS) ) )ORSSSTANDBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssadg1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssadg2vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = adgORSSB) ) )ADGORSSB2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssadg2vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = adgORSSB) (INSTANCE_NAME = adgORS