use rman duplicate create phyical standby database
来源:互联网 发布:淘宝试用报名金额 编辑:程序博客网 时间:2024/05/16 10:30
配置基础环境,操作步骤如下:
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
详细见官方文档。
- use rman duplicate create phyical standby database
- How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
- How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]
- 11g rman新特性 duplicate target database for standby from active database
- RMAN DUPLICATE TARGET DATABASE FOR STANDBY(Active Dataguard) FROM ACTIVE DATABASE (Oracle 11g)
- RMAN duplicate database
- RMAN - duplicate DATABASE
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE (Doc ID
- Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore
- Duplicate standby database from active database
- Duplicate standby database from active database
- Create Oracle Physical Standby Database
- RMAN duplicate for standby失败解决过程
- Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN
- Step By Step Guide To Create Physical Standby Database Using RMAN Backup and Restore (Doc ID 469493.
- 【RMAN】使用RMAN增量备份刷新 Standby Database
- Oracle 11g Dataguard Duplicate standby database from active database
- Use command to create database
- JS----- <<<<<alert>>>><<<<<confirm>>>>><<<<<prompt>>>>>
- 备忘
- Sublime Text2 快捷键 —— 好东西,备份下
- sql语句里的limit使用方法
- 关于html的一些基础知识
- use rman duplicate create phyical standby database
- jquery 绑定click事件
- 章节导学第10章 用户自定义数据类型
- 普通排序算法的C++实现
- HTTP状态码
- 享受寂寞
- 章节导学第11章 文件
- 黑马程序员——Eclipse,MyEclipse基本配置
- Android网络超时处理