Linux 9i下Dataguard配置
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oracleXDB)' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='oracle' *.java_pool_size=83886080 *.job_queue_processes=10 *.large_pool_size=16777216 *.log_archive_dest_1='LOCATION=/home/oracle/oradata/archivelog/' *.log_archive_dest_2='service=standby mandatory reopen=60' *.log_archive_dest_state_1='ENABLE' *.log_archive_format='log_%t_%s.arc' *.log_archive_start=TRUE *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.query_rewrite_enabled='FALSE' *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_size=83886080 *.sort_area_size=524288 *.star_transformation_enabled='FALSE' *.timed_statistics=TRUE *.undo_management='AUTO' *.undo_retention=10800 *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/home/oracle/admin/oracle/udump'
修改standby主机的initoracle.ora文件(先备份),我的initoracle.ora如下,供参考
*.aq_tm_processes=1 *.background_dump_dest='/home/oracle/admin/primary/bdump' *.compatible='9.2.0.0.0' *.control_files='/home/oracle/oradata/primary/standby.ctl' *.core_dump_dest='/home/oracle/admin/primary/cdump' *.db_block_size=8192 *.db_cache_size=33554432 *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=oracleXDB)' *.fast_start_mttr_target=300 *.hash_join_enabled=TRUE *.instance_name='oracle' *.java_pool_size=83886080 *.job_queue_processes=10 *.large_pool_size=16777216 *.open_cursors=300 *.pga_aggregate_target=25165824 *.processes=150 *.query_rewrite_enabled='FALSE' *.remote_login_passwordfile='EXCLUSIVE' *.shared_pool_size=83886080 *.sort_area_size=524288 *.star_transformation_enabled='FALSE' *.timed_statistics=TRUE *.undo_management='AUTO' *.undo_retention=10800 *.undo_tablespace='UNDOTBS1' *.user_dump_dest='/home/oracle/admin/primary/udump' *.log_archive_format=log_%t_%s.arc *.log_archive_start=TRUE *.STANDBY_FILE_MANAGEMENT=AUTO *.log_archive_dest_1='LOCATION=/home/oracle/oradata/archivelog/' *.log_archive_dest_state_1 = ENABLE *.fal_server='primary' *.fal_client='standby' *.DB_FILE_NAME_CONVERT=("/home/oracle/oradata/oracle","/home/oracle/oradata/primary") ----(主辅数据库数据文件相互转换的目录) *.STANDBY_FILE_MANAGEMENT=AUTO 即可实现重命名主库的数据文件!! *.LOG_FILE_NAME_CONVERT=("/home/oracle/oradata/archivelog","/home/oracle/oradata/archivelog") ----(主辅数据库联机日志redolog相互转换的目录) *.STANDBY_ARCHIVE_DEST=/home/oracle/oradata/archivelog ----(从主数据库产生的archivelog传到辅数据库的目录) 加粗的是我新添加的选项,基本上都是必需的。红色是注释,实际文件里请不要添加。
4. 配置主节点(primary主机上)的tnsnames.ora文件 primary=(description= (address= |