开源中文网

您的位置: 首页 > 数据库应用 > Oracle > 正文

oracle之DG搭建

来源:  作者:

1、  测试环境

ORACLE主库IP:10.1.1.14  SID:YEYEAI
ORACLE 从库IP:10.1.1.25  SID:STANDBY
2、  修改主库参数文件为:fuck.ora (红色为修改的部分)
YEYEAI.__db_cache_size=88080384
YEYEAI.__java_pool_size=4194304
YEYEAI.__large_pool_size=4194304
YEYEAI.__shared_pool_size=67108864
YEYEAI.__streams_pool_size=0
*.audit_file_dest='/oracle/app/admin/YEYEAI/adump'
*.background_dump_dest='/oracle/app/admin/YEYEAI/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/app/oradata/YEYEAI/control01.ctl','/oracle/app/oradata/YEYEAI/control02.ctl','/oracle/app/oradata/YEYEAI/co
ntrol03.ctl'
*.core_dump_dest='/oracle/app/admin/YEYEAI/cdump'
*.db_block_size=8192
*.db_name='YEYEAI'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_recovery_file_dest='/oracle/app/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=YEYEAIXDB)'
*.job_queue_processes=10
*.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='/oracle/app/admin/YEYEAI/udump'
STANDBY_ARCHIVE_DEST='/oracle/app/flash_recovery_area/YEYEAI/archivelog'
db_unique_name='yeyeai'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(yeyeai,standby)'
LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/flash_recovery_area/YEYEAI/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=YEYEAI'
LOG_ARCHIVE_DEST_2='SERVICE=standby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'
FAL_SERVER=standby
FAL_CLIENT=yeyeai
DB_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'
LOG_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'
STANDBY_FILE_MANAGEMENT=AUTO
3、  修改从库的配置文件为:fuck.ora
*.audit_file_dest='/oracle/app/admin/STANDBY/adump'
*.background_dump_dest='/oracle/app/admin/STANDBY/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/oradata/STANDBY/control01.ctl','/oracle/oradata/STANDBY/control02.ctl','/oracle/oradata/STANDBY/control03.ctl'
*.core_dump_dest='/oracle/app/admin/STANDBY/cdump'
*.db_16k_cache_size=16777216
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_recovery_file_dest='/oracle/app/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=STANDBYXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.undo_management='AUTO'
*.db_name='YEYEAI'
*.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/oracle/app/admin/STANDBY/udump'
DB_UNIQUE_NAME='YEYEAI'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(yeyeai,standby)'
DB_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'
LOG_FILE_NAME_CONVERT='/oracle/app/oradata/YEYEAI','/oracle/oradata/STANDBY'
LOG_ARCHIVE_DEST_1='LOCATION=/oracle/app/flash_recovery_area/YEYEAI/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby'
LOG_ARCHIVE_DEST_2='SERVICE=yeyeai LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=YEYEAI'
FAL_SERVER=yeyeai
FAL_CLIENT=standby
STANDBY_FILE_MANAGEMENT=AUTO
4、  修改主库的listener.ora文件
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = YEYEAI)
      (ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1)
      (SID_NAME = YEYEAI)
    )
  )
 
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.14)(PORT = 1521))
  )
5、  修改主库的tnsnames.ora文件
YEYEAI =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.1.1.14)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = YEYEAI)
    )
  )
STANDBY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =10.1.1.25)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = standby)
    )
  )
 
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
 
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PL***tProc)
      (PRESENTATION = RO)
    )
  )
6、  修改从库的listener.ora文件
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = STANDBY)
      (ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_1)
      (SID_NAME = STANDBY)
    )
  )
 
LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.25)(PORT = 1521))
  )
7、  修改从库的tnsnames.ora文件
 
yeyeai =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.14)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = YEYEAI)
    )
  )
8、 主库和从库都启动监听:lsnrctl start
9、设置服务器为归档模式
alter database archivelog
设置主数据库为日志强制写状态
alter database force logging;
查看状态日志强制写状态为YES
select t.FORCE_LOGGING from v$database t
10.主库的数据用RMAN进行全备份:
 RMAN > connect target /
RMAN >backup full database include current controlfile for standby;
11.备份后将备份集传到从库(注意备份集的路径要相同)
主库:
   
从库:
 
12.在主库执行RMAN恢复备库数据:
RMAN > connect auxiliary sys/aiyeye@slave
RMAN > duplicate target database for standby nofilenamecheck;
完毕后从库回自动到mount状态
13.在从库执行自动恢复状态
alter database recover managed standby database disconnect from session;
14.主库执行:
    select process from v$managed_standby;
查看进程,看有没有LNS进程,如果没有
 
 
测试数据库同步成功

Tags:oracle DG
关于开源中文网 - 联系我们 - 广告服务 - 网站地图 - 版权声明