下配置三呢

修改standby主机的a文件（先备份），我的a如下，供参考

*.aq_tm_processes=1

*.background_dump_dest=\'/home/oracle/admin/primary/bdump\'

*.compatible=\'9.2.0.0.0\'

*.control_files=\'/home/oracle/oradata/primary/l\'

*.core_dump_dest=\'/home/oracle/admin/primary/cdump\'

*.db_block_size=8192

*.db_cache_size=

*.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=

*.job_queue_processes=10

*.large_pool_size=

*.open_cursors=300

*.pga_aggregate_target=

*.processes=150

*.query_rewrite_enabled=\'FALSE\'

*.remote_login_passwordfile=\'EXCLUSIVE\'

*.shared_pool_size=

*.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_%c

*.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主机上)的a文件

primary=(description=

(address=

(protocol=tcp)

(port=1521)

(host=1.1.1.1))

(connect_data=

(SID=oracle)))

standby=(description=

(address=

(protocol=tcp)

(port=1521)

(host=1.1.1.2))

(connect_data=

(SID=oracle)))

同样，在副节点(standby) 的a文件

5. 在副节点(standby)上配置a文件, 添加监听服务standby_listener，在相应的节里添加有关的内容.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = oracle)

(GLOBAL_DBNAME = oracle)

(ORACLE_HOME = /home/oracle/oradata)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521))

)

)

在主副库上启动lsnrctl,

-bash-2.05b$ lsnrctl

LSNRCTLstart # 启动监听服务

查看本文来源

拉萨白癜风医院
重庆妇科
天津子宫内膜炎治疗多少钱