【正文】 dgORSSB139。 scope=spfile。alter system set thread = 2 sid=39。adgORSSB239。 scope=spfile。alter system set _trace_files_public=true scope=spfile。alter system set _optimizer_use_feedback=false scope=spfile。alter system set LOG_ARCHIVE_MAX_PROCESSES=4。 注意：SERVICE=ORSSPRIMARY LGWR ASYNC ，redo傳輸以異步方式進(jìn)行傳輸，傳輸?shù)絋NS中配置的連接備庫(kù)的ORSSPRIMARY別名7. 用戶(hù)oracle登錄備節(jié)點(diǎn)p3orssadg1 $ sqlplus / as sysdbaSQL create pfile=‘/tmp/’ from spfile。SQLshutdown immediate。SQLstartup pfile=‘/tmp/’ nomount。SQL create spfile=‘+P3ORSADGDAT1DG/adgorssb/’ from pfile=‘/tmp/’。SQLshutdown immediate。$cd $ORACLE_HOME/dbs$rm $ vi 文件內(nèi)容如下：spfile=‘+P3ORSADGDAT1DG/adgorssb/’8. 用戶(hù)oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg2$ cd $ORACLE_HOME/dbs$ vi 文件內(nèi)容如下：spfile=‘+P3ORSADGDAT1DG/adgorssb/’9. 啟動(dòng)備數(shù)據(jù)庫(kù)實(shí)例adgORSSB1用戶(hù)oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1$sqlplus / as sysdbaSQL startup mount。10. 用戶(hù)grid登錄備節(jié)點(diǎn)p3orssadg1停止LISTENER_TMP監(jiān)聽(tīng)grid用戶(hù)登錄備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1su gridlsnrctl stop LISTENER_TMP 通過(guò)帶庫(kù)備份恢復(fù)初始化備數(shù)據(jù)庫(kù)(主數(shù)據(jù)庫(kù)備份必須存在)1. 在主節(jié)點(diǎn)p3orssetl1獲取參數(shù)文件Oracle用戶(hù)登錄主節(jié)點(diǎn)p3orssetl1數(shù)據(jù)庫(kù)主機(jī)$sqlplus / as sysdbaSQL create pfile=‘/tmp/’ from spfile。例如主節(jié)點(diǎn)p3orssetl1數(shù)據(jù)庫(kù)的參數(shù)配置如下：$ cat /tmp/*._gc_defer_time=3*._gc_policy_time=0*._optimizer_adaptive_cursor_sharing=FALSE*._optimizer_extended_cursor_sharing_rel=39。NONE39。*._partition_large_extents=39。FALSE39。*._undo_autotune=FALSE*._use_adaptive_log_file_sync=39。FALSE39。*._trace_files_public=true*._optimizer_use_feedback=false*.audit_file_dest=39。/oracle/app/oracle/admin/oraORSS/adump39。*.audit_sys_operations=TRUE*.audit_trail=39。db39。*.cluster_database=true*.patible=39。39。*.control_file_record_keep_time=31*.control_files=39。+P3ORSSDAT1DG/oraorss/controlfile/39。,39。+P3ORSSDAT1DG/oraorss/controlfile/39。,39。+P3ORSSDAT1DG/oraorss/controlfile/39。Restore Controlfile*.db_block_size=8192*.db_create_file_dest=39。+P3ORSSDAT1DG39。*.db_domain=39。39。*.db_files=2048*.db_name=39。oraORSS39。*.deferred_segment_creation=FALSE*.diagnostic_dest=39。/oracle/app/oracle39。=1=2*.log_archive_dest_1=39。location=/arch39。*.log_archive_max_processes=4*.max_dump_file_size=39。2048M39。*.open_cursors=300*.optimizer_use_sql_plan_baselines=FALSE*.parallel_force_local=TRUE*.parallel_max_servers=32*.pga_aggregate_target=10737418240*.processes=2048*.remote_listener=39。LISTENERS_ORAORSS39。*.remote_login_passwordfile=39。exclusive39。*.result_cache_max_size=0*.sec_case_sensitive_logon=FALSE*.sec_max_failed_login_attempts=6*.sessions=1105*.sga_max_size=32212254720*.sga_target=32212254720=1=2*.undo_retention=10800=39。UNDOTBS139。=39。UNDOTBS239。2. 在主節(jié)點(diǎn)p3orssetl1生成standby controlfileOracle用戶(hù)登錄主節(jié)點(diǎn)p3orssetl1數(shù)據(jù)庫(kù)主機(jī)$sqlplus / as sysdbaSQL alter database create standby controlfile as 39。/tmp/39。生成完畢后將生成的standby的控制文件傳輸?shù)絺涔?jié)點(diǎn)p3orssadg13. 在備節(jié)點(diǎn)p3orssadg1編輯數(shù)據(jù)庫(kù)參數(shù)文件Oracle用戶(hù)登錄備節(jié)點(diǎn)p3orssadg1數(shù)據(jù)庫(kù)主機(jī)，參考主節(jié)點(diǎn)數(shù)據(jù)庫(kù)的參數(shù)進(jìn)行修改，注意修改紅色部分$ vi /tmp/*._gc_defer_time=3*._gc_policy_time=0*._optimizer_adaptive_cursor_sharing=FALSE*._optimizer_extended_cursor_sharing_rel=39。NONE39。*._partition_large_extents=39。FALSE39。*._undo_autotune=FALSE*._use_adaptive_log_file_sync=39。FALSE39。*._trace_files_public=true*._optimizer_use_feedback=false*.audit_file_dest=39。/oracle/app/oracle/admin/adgORSSB/adump39。 *.audit_sys_operations=TRUE*.audit_trail=39。db39。*.cluster_database=true*.patible=39。39。*.control_file_record_keep_time=31*.control_files=39。+P3ORSADGDAT1DG/ADGORSSB/controlfile/39。,39。+P3ORSADGDAT1DG/ADGORSSB/controlfile/39。,39。+P3ORSADGDAT1DG/ADGORSSB/controlfile/39。39。 備節(jié)點(diǎn)數(shù)據(jù)庫(kù)的控制文件位置，注意ASMDG以及存放路徑*.db_block_size=8192 數(shù)據(jù)庫(kù)塊大小，需與實(shí)際情況相符*.db_create_file_dest=39。39。 備節(jié)點(diǎn)數(shù)據(jù)庫(kù)的數(shù)據(jù)文件默認(rèn)創(chuàng)建位置，注意設(shè)置為空，禁用備庫(kù)的OMF功能*.db_domain=39。39。*.db_files=2048*.db_name=39。oraORSS39。 與主節(jié)點(diǎn)數(shù)據(jù)庫(kù)的db_name保持不變*.db_unique_name=39。adgORSSB39。 備節(jié)點(diǎn)數(shù)據(jù)庫(kù)的db_unique_name，需與實(shí)際情況相符*.deferred_segment_creation=FALSE*.diagnostic_dest=39。/oracle/app/oracle39。=1 備節(jié)點(diǎn)實(shí)例一的參數(shù)=2 備節(jié)點(diǎn)實(shí)例二的參數(shù)*.log_archive_dest_1=39。location=/arch39。*.log_archive_max_processes=4*.max_dump_file_size=39。2048M39。*.open_cursors=300*.optimizer_use_sql_plan_baselines=FALSE*.parallel_force_local=TRUE*.parallel_max_servers=32*.pga_aggregate_target=10737418240 備節(jié)點(diǎn)PGA設(shè)置，需與實(shí)際情況相符*.processes=2048*.remote_listener=39。LISTENERS_ADGORSSB39。 備節(jié)點(diǎn)實(shí)例的REMOTE_LISTENER參數(shù)，*.remote_login_passwordfile=39。exclusive39。*.result_cache_max_size=0*.sec_case_sensitive_logon=FALSE*.sec_max_failed_login_attempts=6*.sessions=1105*.sga_max_size=32212254720 備節(jié)點(diǎn)SGA設(shè)置，需與實(shí)際情況相符*.sga_target=32212254720 備節(jié)點(diǎn)SGA設(shè)置，需與實(shí)際情況相符=1 備節(jié)點(diǎn)實(shí)例一的參數(shù)=2 備節(jié)點(diǎn)實(shí)例二的參數(shù)*.undo_retention=10800=39。UNDOTBS139。 備節(jié)點(diǎn)實(shí)例一的參數(shù)=39。UNDOTBS239。 備節(jié)點(diǎn)實(shí)例二的參數(shù) 并新增如下參數(shù)*.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ò)容加盤(pán)新建ASMDG的情況，且參數(shù)*.db_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)db_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對(duì)配置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ò)容加盤(pán)新建ASMDG的情況，且參數(shù)log_file_name_convert設(shè)置后需要重啟生效，因此將參數(shù)log_file_name_convert多設(shè)置23個(gè)ASMDG的轉(zhuǎn)換，按照顏色順序成對(duì)配置*.standby_file_management=39。AUTO39。4. 在備節(jié)點(diǎn)p3orssadg1啟動(dòng)備數(shù)據(jù)庫(kù)實(shí)例oraORSS1至nomount狀態(tài)用戶(hù)oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1$sqlplus / as sysdbaSQL startup nomount pfile=‘/tmp/’。5. 在備節(jié)點(diǎn)p3orssadg1生成DataGuard端的spfile參數(shù)文件用戶(hù)oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1$sqlplus / as sysdbaSQL create spfile=‘+P3ORSADGDAT1DG/adgorssb/’ from pfile=‘/tmp/’。6. 用戶(hù)oracle登陸備數(shù)據(jù)庫(kù)節(jié)點(diǎn)主機(jī)p3orssadg1$ cd $ORACL