【文章內(nèi)容簡(jiǎn)介】 _DATA = (SERVER = DEDICATED) (SERVICE_NAME = adgORSSB) ) )LISTENERS_ADGORSSB = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssadg1vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = p3orssadg2vip)(PORT = 1521)) )ADGORSSBTMP = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = adgORSSB) ) )8. 在主節(jié)點(diǎn)p3orssetl1上生成數(shù)據(jù)庫(kù)密碼文件orapworaORSS1，命令如下(其中紅色部分的oracle123為密碼，orapworaORSS1為密碼文件)：su oraclecd $ORACLE_HOME/dbsorapwd file=orapworaORSS1 password=oracle123sqlplus ‘/as sysdba’alter user sys identified by oracle123。9. 將節(jié)點(diǎn)p3orssetl1數(shù)據(jù)庫(kù)密碼文件orapworaORSS1拷貝到p3orssetlp3orssadg1和p3orssadg2節(jié)點(diǎn)后執(zhí)行以下命令p3orssetl1節(jié)點(diǎn)主機(jī)數(shù)據(jù)庫(kù)密碼文件為/oracle/app/oracle/product/$cd $ORACLE_HOME/dbs$mv orapworaORSS1 orapworaORSS2 在主節(jié)點(diǎn)p3orssetl2操作$chown oracle:oinstall orapworaORSS2 在主節(jié)點(diǎn)p3orssetl2操作$mv orapworaORSS1 orapwadgORSSB1 在備節(jié)點(diǎn)p3orssadg1操作$chown oracle:oinstall orapwadgORSSB1 在備節(jié)點(diǎn)p3orssadg1操作$mv orapworaORSS1 orapwadgORSSB2 在備節(jié)點(diǎn)p3orssadg2操作$chown oracle:oinstall orapwadgORSSB2 在備節(jié)點(diǎn)p3orssadg2操作其中紅色部分：oraORSSadgORSSBadgORSSB2為實(shí)例名，需要和每個(gè)主機(jī)實(shí)例名相符 另外如果需要修改sys用戶的密碼，則在節(jié)點(diǎn)p3orssetl1執(zhí)行以下命令后再將數(shù)據(jù)庫(kù)密碼文件拷貝到其他p3orssetlp3orssadg1和p3orssadg2節(jié)點(diǎn)上用戶oracle登陸主數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssetl1SQLalter user sys identified by oracle123。在備數(shù)據(jù)庫(kù)主機(jī)上創(chuàng)建adump目錄10. 用戶oracle登陸p3orssadg1和p3orssadg2節(jié)點(diǎn)mkdir –p /oracle/app/oracle/admin/adgORSSB/adump11. 用戶oracle登陸主數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssetl1和p3orssetl2執(zhí)行tnsping TNS別名ORSSPRIMARY和ORSSSTANDBYsu oracletnsping ORSSPRIMARYtnsping ORSSSTANDBY12. 用戶oracle登陸主數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssetl1和p3orssetl2用sys用戶登陸備數(shù)據(jù)庫(kù)和主數(shù)據(jù)庫(kù)$sqlplus sys/oracle123@ORSSPRIMARY as sysdba$sqlplus sys/oracle123@ORSSSTANDBY as sysdba13. 用戶oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1和p3orssadg2執(zhí)行tnsping TNS別名ORSSPRIMARY和ORSSSTANDBY$tnsping ORSSPRIMARY$tnsping ORSSSTANDBY14. 用戶oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1和p3orssadg2用sys用戶登陸主數(shù)據(jù)庫(kù)和備數(shù)據(jù)庫(kù)$sqlplus sys/oracle123@ORSSPRIMARY as sysdba$sqlplus sys/oracle123@ORSSSTANDBY as sysdba 備數(shù)據(jù)庫(kù)初始化備數(shù)據(jù)庫(kù)初始化意味著需要將主數(shù)據(jù)庫(kù)的控制文件、數(shù)據(jù)文件等全部復(fù)制到備數(shù)據(jù)庫(kù)環(huán)境上，即主數(shù)據(jù)庫(kù)和備數(shù)據(jù)庫(kù)進(jìn)行一次全庫(kù)復(fù)制?？梢圆捎靡韵路绞街械娜魏我环N對(duì)備數(shù)據(jù)庫(kù)進(jìn)行初始化: 通過duplicate active database初始化備數(shù)據(jù)庫(kù)(主數(shù)據(jù)庫(kù)備份無需存在)注意：此種方式為RMAN從網(wǎng)絡(luò)恢復(fù)數(shù)據(jù)庫(kù)，會(huì)占用大量的網(wǎng)絡(luò)帶寬，建議已經(jīng)投產(chǎn)的系統(tǒng)使用下面的從NBU帶庫(kù)恢復(fù)的方式進(jìn)行。1. 用戶oracle登錄備節(jié)點(diǎn)p3orssadg1創(chuàng)建dg_work工作目錄Oracle用戶登錄備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1$ mkdir dg_work2. 用戶grid登錄備節(jié)點(diǎn)p3orssadg1啟動(dòng)LISTENER_TMP監(jiān)聽grid用戶登錄備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1su gridlsnrctl start LISTENER_TMP3. Oracle用戶登錄備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1$ cd /home/oracle/dg_work$ vi 該文件內(nèi)容如下：DB_NAME=39。oraORSS39。 數(shù)據(jù)庫(kù)名稱DB_UNIQUE_NAME=39。adgORSSB39。 備數(shù)據(jù)庫(kù)DB_UNIQUE_NAMEDB_BLOCK_SIZE=8192SGA_TARGET=3221225472db_create_file_dest=39。 39。 備數(shù)據(jù)庫(kù)取消OMF功能control_files=39。+P3ORSADGDAT1DG/adgORSSB/controlfile/39。,39。+P3ORSADGDAT1DG/adgORSSB/controlfile/39。,39。+P3ORSADGDAT1DG/adgORSSB/controlfile/39。 備數(shù)據(jù)庫(kù)控制文件路徑其中主數(shù)據(jù)庫(kù)和備數(shù)據(jù)庫(kù)在DB_NAME和DB_BLOCK_SIZE必須一致$ vi 該文件內(nèi)容如下：sqlplus / as sysdba EOFstartup nomount pfile=39。/home/oracle/dg_work/39。connect sys/oracle123@ORSSSTANDBY AS SYSDBA oracle123為sys用戶密碼，ORSSSTANDBY備數(shù)據(jù)庫(kù)TNS別名connect sys/oracle123@ORSSPRIMARY AS SYSDBA oracle123為sys用戶密碼，ORSSPRIMARY為主數(shù)據(jù)庫(kù)TNS別名EOFexport NLS_DATE_FORMAT=39。YYYYMMDD HH24:MI:SS39。rman target sys/oracle123@ORSSPRIMARY auxiliary sys/oracle123@ADGORSSBTMP EOFORSSPRIMARY為備庫(kù)上配置的連接主庫(kù)的TNS別名，ADGORSSBTMP為主庫(kù)上配置的連接備庫(kù)的TNS別名run {allocate channel ch001 type disk。allocate channel ch002 type disk。allocate channel ch003 type disk。allocate channel ch004 type disk。allocate auxiliary channel ch005 type disk。allocate auxiliary channel ch006 type disk。duplicate target database for standby nofilenamecheck from active databaseDORECOVER 此命令在自動(dòng)restore完成后執(zhí)行recover，根據(jù)情況可決定是否設(shè)置spfile parameter_value_convert 39。oraORSS39。,39。adgORSSB39。 SET DB_UNIQUE_NAME=39。adgORSSB39。 SET FAL_SERVER=39。ORSSPRIMARY39。 備庫(kù)設(shè)置FAL_SERVER，為備庫(kù)中配置的連接主庫(kù)的TNS別名 SET LOG_ARCHIVE_DEST_1=39。LOCATION=/arch VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE) DB_UNIQUE_NAME=adgORSSB39。 set db_file_name_convert=39。+P3ORSSDAT1DG/ORAORSS/DATAFILE/39。,39。+P3ORSADGDAT1DG/ADGORSSB/DATAFILE/39。,39。+P3ORSSDAT2DG/ORAORSS/DATAFILE/39。,39。+P3ORSADGDAT2DG/ADGORSSB/DATAFILE/39。,39。+P3ORSSDAT3DG/ORAORSS/DATAFILE/39。,39。+P3ORSADGDAT3DG/ADGORSSB/DATAFILE/39。,39。+P3ORSSDAT1DG/ORAORSS/TEMPFILE/39。,39。+P3ORSADGDAT1DG/ADGORSSB/TEMPFILE/39。,39。+P3ORSSDAT2DG/ORAORSS/TEMPFILE/39。,39。+P3ORSADGDAT2DG/ADGORSSB/TEMPFILE/39。,39。+P3ORSSDAT3DG/ORAORSS/TEMPFILE/39。,39。+P3ORSADGDAT3DG/ADGORSSB/TEMPFILE/39。 考慮到后續(xù)系統(tǒng)存儲(chǔ)擴(kuò)容加盤新建ASMDG的情況，且參數(shù)db_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)db_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對(duì)配置 set log_file_name_convert=39。+P3ORSSDAT1DG/ORAORSS/ONLINELOG/39。,39。+P3ORSADGDAT1DG/ADGORSSB/ONLINELOG/39。,39。+P3ORSSDAT2DG/ORAORSS/ONLINELOG/39。,39。+P3ORSADGDAT2DG/ADGORSSB/ONLINELOG/39。,39。+P3ORSSDAT3DG/ORAORSS/ONLINELOG/39。,39。+P3ORSADGDAT3DG/ADGORSSB/ONLINELOG/39。 考慮到后續(xù)系統(tǒng)存儲(chǔ)擴(kuò)容加盤新建ASMDG的情況，且參數(shù)log_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)log_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對(duì)配置 set standby_file_management=39。AUTO39。 set diagnostic_dest=39。/oracle/app/oracle39。 set audit_file_dest=39。/oracle/app/oracle/admin/adgORSSB/adump39。 set remote_listener=39。LISTENERS_ADGORSSB39。 按照規(guī)范設(shè)置remote_listener參數(shù) set log_archive_dest_2=39。 39。 set sga_max_size = 39。11G39。 根據(jù)情況設(shè)置備數(shù)據(jù)庫(kù)的SGA參數(shù) set sga_target = 39。11G39。 根據(jù)情況設(shè)置備數(shù)據(jù)庫(kù)的SGA參數(shù) set pga_aggregate_target = 39。5G39。 根據(jù)情況設(shè)置備數(shù)據(jù)庫(kù)的PGA參數(shù) set memory_target = 39。039。 根據(jù)情況設(shè)置備數(shù)據(jù)庫(kù)的內(nèi)存自動(dòng)調(diào)整 set db_create_file_dest = 39。39。 設(shè)置備庫(kù)的db_create_file_dest參數(shù)為空，禁用OMF set instance_number = 39。139。 set control_files=39。+P3ORSADGDAT1DG/ADGORSSB/controlfile/39。,39。+P3ORSADGDAT1DG/ADGORSSB/controlfile/39。,39。+P3ORSADGDAT1DG/ADGORSSB/controlfile/39。release channel ch001。release channel ch002。release channel ch003。release channel ch004。release channel ch005。release channel ch006。