参考视频
- [bbk4436]第1集 - Oracle 11g DataGuard 概述
- [bbk4437]第2集 - Oracle 11g DataGuard 概述
- [bbk4742]第3集 - 创建一个物理备库
- [bbk4743]第4集 - 创建一个物理备库
Steps to Create a Physical Standby Database
- Prepare the primary database.
- Set parameters on the physical standby database.
- Configure Oracle Net Services.
- Start the standby database instance.(startup mount)
- Execute the DUPLICATE TARGE DATABASE FOR STANDBY FROM ACTIVE DATABASE RMAN command.
- Start the transport and application of redo.
Preparing the Primary Database
- Enable FORCE LOGGING at the database level.
- Create a pasword file if required.
- Create standby redo logs.
- Set initiablization parameters.
- 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'