• 一起搭建DataGuard环境


    参考视频

    • [bbk4436]第1集 - Oracle 11g DataGuard 概述
    • [bbk4437]第2集 - Oracle 11g DataGuard 概述
    • [bbk4742]第3集 - 创建一个物理备库
    • [bbk4743]第4集 - 创建一个物理备库

    Steps to Create a Physical Standby Database

    1. Prepare the primary database.
    2. Set parameters on the physical standby database.
    3. Configure Oracle Net Services.
    4. Start the standby database instance.(startup mount)
    5. Execute the DUPLICATE TARGE DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command.
    6. Start the transport and application of redo.

    Preparing the Primary Database

    1. Enable FORCE LOGGING at the database level.
    2. Create a pasword file if required.
    3. Create standby redo logs.
    4. Set initiablization parameters.
    5. Enable archiving.

    搭建DataGuard,修改初始化参数文件所需要的配置信息

    DB_UNIQUE_NAME='orcl'
    LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,FUNDDG)'
    LOG_ARCHIVE_DEST_1='LOCATION=/bak_center/arch/orcl/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
    LOG_ARCHIVE_DEST_2='SERVICE=FUNDDG LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FUNDDG'
    LOG_ARCHIVE_DEST_STATE_1='ENABLE'
    LOG_ARCHIVE_DEST_STATE_2='ENABLE'
    REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE'
    LOG_ARCHIVE_MAX_PROCESSES=3
    
    FAL_CLIENT='orcl'
    FAL_SERVER='FUNDDG'
    DB_FILE_NAME_CONVERT='/opt/oradata/orcl/','/gsfund/app/oracle/oradata/FUNDDG/'
    LOG_FILE_NAME_CONVERT='/opt/oradata/orcl/','/gsfund/app/oracle/oradata/FUNDDG/'
    STANDBY_FILE_MANAGEMENT='AUTO'
  • 相关阅读:
    CSS选择器规范
    利用form的“acceptcharset”在不同编码的页面间提交表单
    学习Ruby的基础知识
    Watir和watir webdriver的区别
    PHP in_array() 函数
    Ruby数组的基础知识
    PHP smarty if的条件修饰词
    很好的自动化学习资料 Ruby watir selenium
    $(document).ready() 和window.onload
    收藏:简单的PHP+SMARTY分页类
  • 原文地址:https://www.cnblogs.com/arcer/p/3142954.html
Copyright © 2020-2023  润新知