最大效能Physical Standby設定記錄
---------------------------------------------------------------------------
Production DB:
---------------------------------------------------------------------------
EPD3-DB$cat init.ora
*.background_dump_dest='/u01/product/admin/epd/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/product/oradata/epd/control01.ctl','/u01/product/oradata/epd/control02.ctl','/u01/product/oradata/epd/control03.ctl'
*.core_dump_dest='/u01/product/admin/epd/cdump'
*.db_block_size=8192
*.db_cache_size=1073741824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1000
*.db_name='epd'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=epdXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='epd'
*.java_pool_size=33554432
*.job_queue_processes=36
*.large_pool_size=104857600
*.log_archive_dest_1='LOCATION=/data/epd/arch'
*.log_archive_dest_2='service=standby optional reopen=60'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=1000
*.pga_aggregate_target=209715200
*.processes=500
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=209715200
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/product/admin/epd/udump'
EPD3-DB$
---------------------------------------------------------------------------
Standby DB:
---------------------------------------------------------------------------
EPD3sty$cat init.ora
*.background_dump_dest='/u01/product/admin/epd/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/u01/product/oradata/epd/control01.ctl','/u01/product/oradata/epd/control02.ctl','/u01/product/oradata/epd/control03.ctl'
*.core_dump_dest='/u01/product/admin/epd/cdump'
*.db_block_size=8192
*.db_cache_size=1073741824
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/data/epd','/data/epd'
*.db_files=1000
*.db_name='epd'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=epdXDB)'
*.fal_client='standby'
*.fal_server='EPD3DB'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='epd'
*.java_pool_size=33554432
*.job_queue_processes=36
*.large_pool_size=104857600
*.log_archive_dest_1='LOCATION=/data/epd/arch'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.log_file_name_convert='/data/epd','/data/epd'
*.open_cursors=1000
*.pga_aggregate_target=209715200
*.processes=500
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=209715200
*.sort_area_size=524288
*.standby_archive_dest='/data/epd/arch'
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/product/admin/epd/udump'
EPD3sty$
---------------------------------------------------------------------------
Standby DB tnsnames.ora :
---------------------------------------------------------------------------
EPD3DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.8.84)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = epd)
)
)
standby =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.8.79)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = epd)
)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-503120/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- oracle實驗記錄 (flashback,physical standby resetlogs)Oracle
- oracle實驗記錄 (physical standby 日誌應用方面)Oracle
- Oracle physical standbyOracle
- DataGuard:Physical Standby Switchover
- 配置oracle 9i physical standby database時,duplicate命令的執行記錄OracleDatabase
- 建立Local Physical Standby Oracle9i standby 資料庫筆記Oracle資料庫筆記
- DataGuard:Physical Standby FailoverAI
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- 【DG】Data Guard搭建(physical standby)
- Oracle DG建立Physical Standby DatabaseOracleDatabase
- oracle Physical Standby failover stepOracleAI
- Creating a Physical Standby DatabaseDatabase
- Physical Standby Database 切換到 Snapshot Standby DatabaseDatabase
- Performing a Failover to a Physical Standby DatabaseORMAIDatabase
- open physical standby 為read write
- 物理Standby資料庫及邏輯Standby資料庫(Physical Standby & Logical Standby)資料庫
- Physical Standby Switchover_status Showing Not Allowed
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- Oracle10G Physical Standby Database setupOracleDatabase
- Performing a Switchover to a Physical Standby Database and failoverORMDatabaseAI
- Creating a physical standby from ASM primaryASM
- Script to Collect Data Guard Physical and Active Standby Diagnostic InformationORM
- oracle 10g physical standby 切換操作Oracle 10g
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- 關於建立DataGuard Physical Standby資料庫資料庫
- oracle 10g physical standby database creationOracle 10gDatabase
- Recover physical standby database after loss of archive log(2)DatabaseHive
- Physical Standby Switchover_status Showing Not Allowed._1392763.1
- 同事總結的 : 用RMAN建立Physical Standby DatabaseDatabase
- 在Oracle 10g下單機Physical StandbyOracle 10g
- Oracle 9i Logical Standby與Physical standby歸檔恢復區別Oracle
- django 專案日誌記錄設定Django
- Oracle10g RAC設定記錄Oracle
- oracle實驗記錄 (手動建立 physical datagurad)Oracle
- Oracle 12.2 physical standby備庫收集AWR報告Oracle
- Creating a physical standby from ASM primary [ID 787793.1]ASM
- Oracle Data Gurad Physical Standby 相關說明Oracle
- 配置 Oracle 10g RAC primary + RAC physical standby dataguardOracle 10g