配置基础环境,操作步骤如下:
A.在主库上操作:
1.安装数据库软件,以及DBCA建库;
2.配置网路环境,包括(监听,TNSNAME,密码文件);
3.配置相关参数,如下:
DB_UNIQUE_NAME=qjh10gpr
LOG_ARCHIVE_CONFIG='DG_CONFIG=(qjh10gpr,qjh10gdg)'
LOG_ARCHIVE_DEST_1='LOCATION=/opt/u01/oracle/oradata/qjh10gpr/arclog'
LOG_ARCHIVE_DEST_2='SERVICE=qjh10gdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=qjh10gdg'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=2
FAL_SERVER=qjh10gdg
FAL_CLIENT=qjh10gpr
DB_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gdg/','/opt/u01/oracle/oradata/qjh10gpr/'
LOG_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gdg/','/opt/u01/oracle/oradata/qjh10gpr/'
STANDBY_FILE_MANAGEMENT=AUTO
4.在主库上运行备份:rman target /
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
sql 'alter system archive log current';
backup current controlfile for standby;
BACKUP DATABASE;
sql 'alter system archive log current';
BACKUP ARCHIVELOG ALL DELETE INPUT;
release channel c2;
release channel c1;
}
5.将备份片SCP复制到备库相同目录
(如果是复制到不同目录,需要到RMAN中使用catalog 命令注册备份集,但是需要保证主库和备库都能访问到这个目录,需要配置NFS,一般不推荐);
B.在备库上操作:
1.安装数据库软件,不建库;
2.配置网路环境,包括(监听,TNSNAME,密码文件----注意密码要和主库一样);
3.建立相关目录;
4.配置相关参数,如下:
DB_UNIQUE_NAME=qjh10gdg
LOG_ARCHIVE_CONFIG='DG_CONFIG=(qjh10gdg,qjh10gpr)'
LOG_ARCHIVE_DEST_1='LOCATION=/opt/u01/oracle/oradata/qjh10gdg/arclog'
LOG_ARCHIVE_DEST_2='SERVICE=qjh10gpr LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=qjh10gpr'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=DEFER
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=2
FAL_SERVER=qjh10gpr
FAL_CLIENT=qjh10gdg
DB_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gpr/','/opt/u01/oracle/oradata/qjh10gdg/'
LOG_FILE_NAME_CONVERT='/opt/u01/oracle/oradata/qjh10gpr/','/opt/u01/oracle/oradata/qjh10gdg/'
STANDBY_FILE_MANAGEMENT=AUTO
5.备库启动到nomount;
6.登陆rman:(qjh10gpr 和 qjh10gdg 是在tnsname.ora中配置的连接字符串)
rman target sys/oracle@qjh10gpr auxiliary sys/oracle@qjh10gdg
DUPLICATE TARGET DATABASE FOR STANDBY
DORECOVER;
运行完成后,备库处于mount状态,但是不能应用日志
7.在sqlplus 运行:
alter database recover managed standby database disconnect from session;
完成后备库开始应用日志。
基础环境搭建的知识参考:http://blog.csdn.net/plwsab6000/article/details/7916361
ps .
rename datafile 和logfile 的其他两种方法:
Naming Standby Database Files with SET NEWNAME
Naming Standby Database Files with CONFIGURE AUXNAME
详细见官方文档。