oracle dg parameter files

最新推荐文章于 2024-06-05 16:54:57 发布
最新推荐文章于 2024-06-05 16:54:57 发布
阅读量583 收藏
点赞数
分类专栏： Oracle Oracle EBS 文章标签： oracle archive service list network file
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/aicon/article/details/4640086
版权

primary host vmdw1:

192.168.0.185

standby host vmdw2:

192.168.0.186

vmdg1:primary role pfile:

 

 

vmdw1->cat pfile.ora
vmdp1.__db_cache_size=100663296
vmdp1.__java_pool_size=4194304
vmdp1.__large_pool_size=4194304
vmdp1.__shared_pool_size=67108864
vmdp1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/vmdp1/adump'
*.background_dump_dest='/u01/app/oracle/admin/vmdp1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/oradata/vmdp1/control01.ctl','/u01/oradata/vmdp1/control02.ctl','/u01/oradata/vmdp1/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/vmdp1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='vmdp1'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=vmdp1XDB)'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=60817408
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=184549376
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/vmdp1/udump'

 

*.db_unique_name='10gpri'

*.fal_client='10gstandby'

*.fal_server='10gpri'

*.log_archive_config='DG_CONFIG=(10gpri,10gstandby)'
*.log_archive_dest_1='LOCATION=/u01/oradata/log VALID_FOR=(all_logfiles,all_roles) db_unique_name=10gpri'
*.log_archive_dest_2='service=10gstandby arch async valid_for=(online_logfiles,primary_role) db_unique_name=10gstandby'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'

*.undo_management='AUTO'
vmdw1->

 

########################################################

########################################################

 

vmdg2:standby role pfile.ora:

 

 

vmdw2->cat pfile.ora
vmdp1.__db_cache_size=109051904
vmdp1.__java_pool_size=4194304
vmdp1.__large_pool_size=4194304
vmdp1.__shared_pool_size=58720256
vmdp1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/vmdp1/adump'
*.background_dump_dest='/u01/app/oracle/admin/vmdp1/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/oradata/vmdp1/control01.ctl','/u01/oradata/vmdp1/control02.ctl','/u01/oradata/vmdp1/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/vmdp1/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='vmdp1'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=vmdp1XDB)'
*.job_queue_processes=10
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=60817408
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=184549376
*.standby_file_management='auto'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/vmdp1/udump'

 

*.db_unique_name='10gstandby'

*.fal_client='10gpri'
*.fal_server='10gstandby'

*.log_archive_config='DG_CONFIG=(10gpri,10gstandby)'
*.log_archive_dest_1='LOCATION=/u01/oradata/log VALID_FOR=(all_logfiles,all_roles) db_unique_name=10gstandby'
*.log_archive_dest_2='service=10gpri arch async valid_for=(online_logfiles,primary_role) db_unique_name=10gpri'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'

*.undo_management='AUTO'


vmdw2->

 

########################################################

########################################################

 

vmdg1:primary network file :

 

 

vmdw1->cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
10GPRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
VMDP1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmdp1)
    )
  )
10GSTANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.186)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
vmdw1->cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = vmdp1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = vmdp1)
    )
  )
vmdw1->

 

########################################################

########################################################

 

vmdg2 : standby network file :

 

vmdw2->cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
10GPRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
VMDP1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.185)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmdp1)
    )
  )
10GSTANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.186)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vmdp1)
    )
  )
vmdw2->cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.186)(PORT = 1521))
      )
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = vmdp1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = vmdp1)
    )
  )
vmdw2->

 

########################################################

########################################################

aicon
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
oracle dg 参数文件,ORACLE DG之参数详解
weixin_42522518的博客
04-05 623
1.DB_NAME数据库名字，需要保持同一个Data Guard中所有数据库DB_NAME相同。主库和备库相同DB_NAME='chicago'DB_NAME='chicago'2.DB_UNIQUE_NAMEDB_UNIQUE_NAME = unique_service_provider_name_for_this_database为每一个数据库指定一个唯一的名称。主库：DB_UNIQUE_NA...
oracle dg如何取消,Oracle DG 之-- Remove DG Broker
weixin_30618305的博客
04-03 713
Remove the Data Guard Broker ConfigurationDGMGRL> remove configuration;b) Using Data Guard Manager or Grid Control:Follow the Wizard as mentioned in the Chapter'Scenarios Using Oracle Enterprise Ma...
ORACLE-DG总结
BABAJack的博客
08-03 1030
安装软件&监听&数据库：只安装数据库软件&监听配置互信。
Oracle DG 和 物理 standby 数据库的创建
qq_34254018的博客
03-15 617
Oracle DG 和 物理 standby 数据库的创建
oracle dg 实例,单实例DG搭建(DUPLICATE)
weixin_42613017的博客
04-05 374
实例名均为ora11g1.主库添加静态监听和tnsname.ora条目如下SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(GLOBAL_DBNAME = ora11g)(SID_NAME = ora11g)(ORACLE_HOME = /u01/oracle/product/11.2.0/)))stdbytns =(DESCRIPTION =(ADDRESS =...
oracle 查看dg 配置,oracle官方dg举例初始化参数配置
weixin_35972313的博客
04-08 474
#Primary Role Initialization ParametersDB_NAME=chicagoDB_UNIQUE_NAME=chicagoLOG_ARCHIVE_CONFIG='DG_CONFIG=(chicago,boston)'CONTROL_FILES='/arch1/chicago/control1.ctl', '/arch2/chicago/control2.ctl'LOG...
ORACLE DG断档处理
m0_37490944的博客
05-03 568
问题描述：DG备库硬件故障，主库defer掉日志后，备库做硬件更换，更换完成后启动备库，报错。 处理： 启动备库 02:17:49 > startup ORACLE instance started. Total System Global Area 3.4206E+11 bytes Fixed Size 2275496 bytes Variable Size 2.6307E+10 bytes Database Buffers
oracle dg搭建gc方式,数据库迁移方案之DG方式迁移
weixin_29442503的博客
04-09 868
一：环境信息1)主库(单实例)主机平台：AIX6.1数据库版本：11.2.0.3(psu5)2)备库(部署了crs)主机平台：AIX6.1数据库版本：11.2.0.3(psu5)二：方案背景由于业务量增加，数据库需要由单实例，改成两节点rac。为了减少停机时间，采用DG方式迁移。三迁移方案：1.检查数据库是否支持DataGuard(只有企业版才支持DG)SQL> select * from...
跨Nginx代理搭建Oracle DG
Sebastien23的博客
07-16 977
中通过配置参数来开启http客户端连接保活机制，可以设置得大一些（这里为2分钟）。http {# nginx与客户端连接在空闲状态下的超时时间 }中通过配置参数开启TCP层探活机制。.. . # 反向代理监听端口，访问nginx_ip:1522就可以访问到oracle_primary server {# 开启socket探活，走操作系统默认策略 proxy_connect_timeout 3s;# 建立连接的超时时间，默认60s #proxy_timeout 60s;
oracle dg 文档
04-12
oracle11g dg 搭建参考手册，欢迎下载！oracle11g dg 搭建参考手册，欢迎下载！
oracle 19c DG
12-20
1、环境说明 ...hostname dg1 dg2 SID orcl orcl DB_UNQUE_NAME orcl_p orcl_s 数据库文件路劲 /u01/app/oracle/oradata /u01/app/oracle/oradata 归档文件路劲 /u01/archivelog /u01/archivelog_s
ORACLE DG日常运维手册
10-24
Oracle DataGuard主库丢失归档日志后备库的RMAN增量恢复一例，
ORACLE DG 安装文档
12-08
前提需要主库安装数据库软件、创建实例，备库安装数据库软件，然后再按照文档做下去，注意相关路径
ORACLE DG（Oracle白皮书）.pdf
12-01
Oracle Data Guard 是当今保护企业核心资产（数据）的最有效解决 方案，它能够使数据在 24x7 的基础上可用，而无论是否发生灾难或 其他中断。本白皮书将讨论 Oracle 数据库 10g 中的 Data Guard 技 术，并说明它...
oracle中的INTERVAL函数学习总结
weixin_42821740的博客
05-30 600
简单学懂interval函数
【Oracle篇】rman全库异机恢复：从RAC环境到单机测试环境的转移（第四篇，总共八篇）
奈斯DBA的博客
06-03 879
使用RMAN从RAC环境的备份片中恢复数据到单机环境。包括恢复控制文件、数据文件、参数文件、归档等关键组件
ArangoDB 学习笔记
最新发布
qq_38736877的博客
06-05 555
新工作需要用到 arangodb，由于之前没有接触过，所以从头开始学，记录一下学习过程中的重点。
[图解]企业应用架构模式2024新译本讲解06-表模块3
rolt的专栏
06-02 609
产品那个表模块在这里
oracle dg switch
07-27
- *1* *2* [Oracle DG 搭建 生产版](https://blog.csdn.net/demonson/article/details/126597978)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值