ORACLE11G(裸設(shè)備dataguard)

添加standby log

武夷山網(wǎng)站建設(shè)公司創(chuàng)新互聯(lián)建站,武夷山網(wǎng)站設(shè)計(jì)制作，有大型網(wǎng)站制作公司豐富經(jīng)驗(yàn)。已為武夷山上千多家提供企業(yè)網(wǎng)站建設(shè)服務(wù)。企業(yè)網(wǎng)站搭建\外貿(mào)網(wǎng)站建設(shè)要多少錢，請(qǐng)找那個(gè)售后服務(wù)好的武夷山做網(wǎng)站的公司定做！

主庫(kù)參數(shù)文件：

CRM.__db_cache_size=8254390272

CRM.__java_pool_size=33554432

CRM.__large_pool_size=33554432

CRM.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

CRM.__pga_aggregate_target=3288334336

CRM.__sga_target=9865003008

CRM.__shared_io_pool_size=0

CRM.__shared_pool_size=1476395008

CRM.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/CRM/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/dev/rctl1','/dev/rctl2','/dev/rctl3'

*.db_block_size=8192

*.db_domain=''

*.db_name='CRM'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4322230272

*.DB_UNIQUE_NAME='CRM'

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=CRMXDB)'

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(MES,CRM)'

*.log_archive_dest_1='location=/u01/app/oracle/fast_recovery_area/CRM/ valid_for=(all_logfiles,all_roles) db_unique_name=CRM'

*.LOG_ARCHIVE_DEST_2='SERVICE=MES LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=MES'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'

*.open_cursors=300

*.pga_aggregate_target=3288334336

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=9865003008

*.standby_file_management='auto'

*.undo_tablespace='UNDOTBS1'

備庫(kù)參數(shù)文件;

MES.__db_cache_size=8254390272

MES.__java_pool_size=33554432

MES.__large_pool_size=33554432

MES.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

MES.__pga_aggregate_target=3288334336

MES.__sga_target=9865003008

MES.__shared_io_pool_size=0

MES.__shared_pool_size=1476395008

MES.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/MES/adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/dev/rmes_ctl1','/dev/rmes_ctl2','/dev/rmes_ctl3'

*.db_block_size=8192

*.db_file_name_convert='/dev/rsystem01','/dev/rmes_system01','/dev/rusers01','/dev/rmes_users01','/dev/rsysaux01','/dev/rmes_sysaux01','/dev/rundotbs01','/dev/rmes_undotbs01','/dev/rtemp01','/dev/rmes_temp01'

*.log_file_name_convert='/dev/rredo01','/dev/rmes_redo01','/dev/rredo02','/dev/rmes_redo02','/dev/rredo03','/dev/rmes_redo03'

*.db_domain=''

*.db_name='CRM'

*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'

*.db_recovery_file_dest_size=4322230272

*.DB_UNIQUE_NAME='MES'

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=MESXDB)'

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(CRM,MES)'

*.log_archive_dest_1='location=/u01/app/oracle/fast_recovery_area/MES/ valid_for=(all_logfiles,all_roles) db_unique_name=MES'

*.LOG_ARCHIVE_DEST_2='SERVICE=CRM LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=CRM'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'

*.open_cursors=300

*.pga_aggregate_target=3288334336

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=9865003008

*.standby_file_management='auto'

*.undo_tablespace='UNDOTBS1'

文章題目：ORACLE11G(裸設(shè)備dataguard)
轉(zhuǎn)載注明：http://bm7419.com/article26/gosjcg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供虛擬主機(jī)、網(wǎng)站制作、服務(wù)器托管、網(wǎng)站營(yíng)銷、Google、全網(wǎng)營(yíng)銷推廣

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)