完整的rac带dataguard实验

最新推荐文章于 2023-02-10 15:00:46 发布

纯洁之狼

最新推荐文章于 2023-02-10 15:00:46 发布

阅读量651

点赞数

分类专栏： rac 日常总结 dataguard 文章标签： rac dataguard 数据库

本文链接：https://blog.csdn.net/freedomx1oa/article/details/18838961

版权

这篇博客详细记录了一次完整的Oracle Real Application Clusters (RAC) 集群数据库与DataGuard灾备环境的配置过程。内容涵盖RAC数据库的各项参数设置，如缓存大小、内存池分配，以及在主库和备库上的配置步骤，包括日志归档、文件转换、数据库参数调整、监听和tnsnames.ora文件的修改。在配置过程中，博主遇到了并解决了一些问题，如日志同步延迟和连接错误，最终实现了高可用性和灾难恢复的架构。

摘要由CSDN通过智能技术生成

主库参数
RACDB1.__db_cache_size=67108864
RACDB2.__db_cache_size=50331648
RACDB2.__java_pool_size=4194304
RACDB1.__java_pool_size=4194304
RACDB2.__large_pool_size=4194304
RACDB1.__large_pool_size=4194304
RACDB1.__shared_pool_size=88080384
RACDB2.__shared_pool_size=104857600
RACDB2.__streams_pool_size=0
RACDB1.__streams_pool_size=0
*.audit_file_dest='/opt/ora10g/admin/RACDB/adump'
*.background_dump_dest='/opt/ora10g/admin/RACDB/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='10.2.0.1.0'
*.control_files='+RAC_DISK/racdb/controlfile/current.260.825266635'
*.core_dump_dest='/opt/ora10g/admin/RACDB/cdump'
*.db_block_size=8192
*.db_create_file_dest='+RAC_DISK'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='RACDB'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=RACDBXDB)'
RACDB2.instance_number=2
RACDB1.instance_number=1
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=167772160
RACDB2.thread=2
RACDB1.thread=1
*.undo_management='AUTO'
RACDB2.undo_tablespace='UNDOTBS2'
RACDB1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/ora10g/admin/RACDB/udump'

alter system set db_unique_name='RACDB' scope=spfile;
alter database force logging;
alter system set log_archive_config='DG_CONFIG=(RACDB,RACDG)';
alter system set log_archive_dest_1='LOCATION=+RAC_DISK/racdb valid_for=(all_logfiles,all_roles) db_unique_name=RACDB' scope=both;
alter system set log_archive_dest_2='SERVICE=RACDG lgwr ASYNC valid_for=(online_logfile,primary_role) db_unique_name=RACDG';
alter system set fal_client='RACDB1' sid='RACDB1';
alter system set fal_client='RACDB2' sid='RACDB2';
alter system set fal_server='RACDG';
alter system set standby_file_management=auto;
alter system set log_archive_dest_state_1='enable' scope=spfile;
alter system set log_archive_dest_state_2='enable' scope=spfile;
alter system set remote_login_passwordfile='exclusive' scope=spfile;

把pfile传到dg

RACDB2.__db_cache_size=62914560
RACDB1.__db_cache_size=62914560
RACDB2.__java_pool_size=4194304
RACDB1.__java_pool_size=4194304
RACDB2.__large_pool_size=4194304
RACDB1.__large_pool_size=4194304
RACDB2.__shared_pool_size=92274688
RACDB1.__shared_pool_size=92274688
RACDB2.__streams_pool_size=0
RACDB1.__streams_pool_size=0

最低0.47元/天解锁文章