oracle data guard!!
用了兩天的時間終於完成拉data guard的培植!
primary database inin.ora
oradb.__db_cache_size=100663296
oradb.__java_pool_size=4194304
oradb.__large_pool_size=4194304
oradb.__shared_pool_size=54525952
oradb.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/oradb/adump'
*.background_dump_dest='/u01/app/oracle/admin/oradb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/oradb/control01.ctl','/u01/app/oracle/oradata/oradb/control02.ctl','/u01/app/oracle/oradata/oradb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/oradb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oradb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oradbXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/oradb/udump'
db_unique_name=mynode1
log_archive_config='dg_config=(mynode1,mynode2)'
log_archive_dest_2='service=stdb valid_for=(online_logfiles,primary_role) db_unique_name=mynode2'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=stdb
fal_client=prdb
standby_file_management=auto
standby database init.ora
oradb.__db_cache_size=100663296
oradb.__java_pool_size=4194304
oradb.__large_pool_size=4194304
oradb.__shared_pool_size=54525952
oradb.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/oradb/adump'
*.background_dump_dest='/u01/app/oracle/admin/oradb/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/u01/app/oracle/oradata/oradb/control01.ctl','/u01/app/oracle/oradata/oradb/control02.ctl','/u01/app/oracle/oradata/oradb/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/oradb/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='oradb'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oradbXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/u01/app/oracle/oradata'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/oradb/udump'
db_unique_name=mynode2
log_archive_config='dg_config=(mynode1,mynode2)'
log_archive_dest_2='service=prdb valid_for=(online_logfiles,primary_role) db_unique_name=mynode1'
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=prdb
fal_client=stdb
standby_file_management=auto
starup mount
alter database recover standby database disconnect from session
alter database recover standby database cancel
alter database open
alter database recover standby database disconnect from session
安裝配置好資料庫後出現的問題
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
修改 /etc/hosts
127.0.0.1 localhost.localdomain localhost
10.10.10.2 rac2
10.10.10.1 rac1
引數的理解是最為重要的!
[@more@]來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-1003820/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 介紹ORACLE DATA GUARD——DATA GUARD概念和管理Oracle
- Oracle Data Guard配置Oracle
- Oracle Data Guard Broker元件Oracle元件
- Oracle Data Guard簡介Oracle
- Oracle Data Guard 介紹Oracle
- ORACLE Data Guard--IOracle
- Oracle 11g Data Guard Enabling Active Data GuardOracle
- [Data Guard]Oracle10g Data Guard學習筆記(一)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(二)Oracle筆記
- [Data Guard]Oracle10g Data Guard學習筆記(三)Oracle筆記
- 1 關於 Oracle Data GuardOracle
- 2 Oracle Data Guard 安裝Oracle
- 1 Oracle Data Guard Broker 概念Oracle
- Oracle Data Guard和Broker概述Oracle
- Oracle 11g Data GuardOracle
- Oracle11g Data GuardOracle
- Oracle Data Guard Failover(activate)OracleAI
- 4.1.6 Oracle Restart 與 Oracle Data Guard 整合OracleREST
- 8 Oracle Data Guard Broker 屬性Oracle
- 9 Oracle Data Guard 故障診斷Oracle
- 【DG】Oracle Data Guard官方直譯Oracle
- ORACLE DATA GUARD -一般概念Oracle
- Oracle11g Data Guard[zt]Oracle
- Oracle RAC + Data Guard 環境搭建Oracle
- Oracle Data Guard 理論知識Oracle
- 技術白皮書:Oracle Data Guard 11gOracle Data Guard 理論知識OracleGo
- DATA GUARD部署模式——DATA GUARD概念和管理模式
- 使用Data Guard Broker進行Data Guard物理備用庫配置(Oracle 19c)Oracle
- 2 開始實用 Oracle Data GuardOracle
- 19 Oracle Data Guard 相關檢視Oracle
- 【DATAGUARD】Oracle19c Data Guard BrokerOracle
- oracle 11g data guard維護Oracle
- Oracle 12c Data Guard搭建(一)Oracle
- Oracle Active Data Guard調整案例[2]Oracle
- oracle 10g物理data guard 操作Oracle 10g
- Oracle Data Guard 12c 新功能Oracle
- 【ASK_ORACLE】Oracle Data Guard(一)DG架構Oracle架構
- Data guard搭建