---------------------------------------------------------------------------
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-503120/