Linux 9i下Dataguard配置

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

修改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= (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) 的tnsnames.ora文件5. 在副节点(standby)上配置listener.ora文件, 添加监听服务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 LSNRCTL>start # 启动监听服务

[1][2][3][4][5][6]

把你的脸迎向阳光,那就不会有阴影

Linux 9i下Dataguard配置

相关文章:

你感兴趣的文章:

标签云: