配置oracle DG

主库名称：prod1 使用asm存储数据 11.2.03 同一机器
备库名称：dg 使用file存储数据 11.2.03

配置备库的参数文件
cd $ORACLE_HOME/dbs
vi initdg.ora

db_name=dg
配置主备库的网络文件
cd $ORACLE_HOME/network/admin

vi tnsnames.ora
dg =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dg.oracle.com)
)
)
prod1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = source)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD1.oracle.com)
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PROD1.oracle.com)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME=PROD1)
)
(SID_DESC=
(SID_NAME=dg)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
)
)

配置主库归档和强制日志附加模式
SQL> select log_mode,force_logging from v$database;

LOG_MODE FOR
------------ ---
ARCHIVELOG NO

SQL>
SQL>
SQL> alter database force logging;

Database altered.

SQL> select log_mode,force_logging from v$database;

LOG_MODE FOR
------------ ---
ARCHIVELOG YES
如果数据库是非归档的话
shutdown immediate
startup mount
alter database archivelog;
alter database open;

添加主库的备用日志
SQL> alter database add standby logfile ('/u01/app/oracle/oradata/PROD1/sdby01.log') size 100m;
SQL> alter database add standby logfile ('/u01/app/oracle/oradata/PROD1/sdby02.log') size 100m;
SQL> alter database add standby logfile ('/u01/app/oracle/oradata/PROD1/sdby03.log') size 100m;
SQL> alter database add standby logfile ('/u01/app/oracle/oradata/PROD1/sdby04.log') size 100m;

启动备库到nomount的状态
export ORACLE_SID=dg

 

用rman复制主库文件到备库
RUN {
ALLOCATE CHANNEL D1 TYPE DISK;
ALLOCATE CHANNEL D2 TYPE DISK;
ALLOCATE AUXILIARY CHANNEL AUX1 TYPE DISK;
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
DORECOVER
PASSWORD FILE
SPFILE
PARAMETER_VALUE_CONVERT 'PROD1','dg'
SET DB_UNIQUE_NAME='dg'
SET DB_CREATE_FILE_DEST='/u01/app/oracle/oradata'
SET DB_RECOVERY_FILE_DEST='/u01/app/oracle/fast_recovery_area'
SET DB_RECOVERY_FILE_DEST_SIZE='5G'
SET
CONTROL_FILES='/u01/app/oracle/oradata/dg/control01.ctl','/u01/app/oracle/fast_recovery_a
rea/dg/control02.ctl'
SET FAL_SERVER='PROD1'　
SET STANDBY_FILE_MANAGEMENT='AUTO';
}

配置dg　broker
dgmgrl sys/*****
create configuration 'DGCONFIG' as primary database is 'PROD1' connect identifier is prod1;　
add database 'PROD1' as connect identifier is prod1;
enble configuration;