添加standby log
創(chuàng)新互聯(lián)公司為企業(yè)級客戶提高一站式互聯(lián)網(wǎng)+設(shè)計服務,主要包括成都網(wǎng)站制作、成都網(wǎng)站建設(shè)、App定制開發(fā)、重慶小程序開發(fā)公司、宣傳片制作、LOGO設(shè)計等,幫助客戶快速提升營銷能力和企業(yè)形象,創(chuàng)新互聯(lián)各部門都有經(jīng)驗豐富的經(jīng)驗,可以確保每一個作品的質(zhì)量和創(chuàng)作周期,同時每年都有很多新員工加入,為我們帶來大量新的創(chuàng)意。主庫參數(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'
備庫參數(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'
另外有需要云服務器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn,海內(nèi)外云服務器15元起步,三天無理由+7*72小時售后在線,公司持有idc許可證,提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業(yè)上云的綜合解決方案,具有“安全穩(wěn)定、簡單易用、服務可用性高、性價比高”等特點與優(yōu)勢,專為企業(yè)上云打造定制,能夠滿足用戶豐富、多元化的應用場景需求。
標題名稱:ORACLE11G(裸設(shè)備dataguard)-創(chuàng)新互聯(lián)
分享地址:http://bm7419.com/article2/igdic.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供品牌網(wǎng)站制作、App設(shè)計、商城網(wǎng)站、微信小程序、外貿(mào)建站、網(wǎng)頁設(shè)計公司
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)
猜你還喜歡下面的內(nèi)容