Oracle 11gR2 dataguard搭建说明 --- rman方式

最新推荐文章于 2024-03-06 22:18:55 发布
最新推荐文章于 2024-03-06 22:18:55 发布
阅读量1.3k 收藏 2
点赞数
分类专栏： Oracle 11g 文章标签： Oracle dataguard
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/sandy9919/article/details/82909634
版权

Oracle 11gR2 dataguard 介绍

Oracle 11gR2 dataguard搭建说明 --- duplicate方式

 

1.配置参数文件

主库参数文件


INCA.__db_cache_size=18589155328
INCA.__java_pool_size=134217728
INCA.__large_pool_size=201326592
INCA.__oracle_base='/ora/app/oracle'#ORACLE_BASE set from environment
INCA.__pga_aggregate_target=3422552064
INCA.__sga_target=21474836480
INCA.__shared_io_pool_size=0
INCA.__shared_pool_size=2348810240
INCA.__streams_pool_size=67108864
*.audit_file_dest='/ora/app/oracle/admin/INCA/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/data/INCA/control01.ctl','/data/INCA/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='INCA'
*.diagnostic_dest='/ora/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=INCAXDB)'
*.job_queue_processes=1000
*.log_archive_dest_1='LOCATION=/data/arch'
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=3365928960
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=3305
*.sga_max_size=27917287424
*.sga_target=21474836480
*.undo_tablespace='UNDOTBS1'
#dg_parameter
*.db_file_name_convert='/data/INCA','/data/incadg'
*.db_unique_name='INCA'
*.fal_client='INCA'
*.fal_server='incadg'
*.log_archive_config='DG_CONFIG=(INCA,incadg)'
*.log_archive_dest_1='LOCATION=/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=INCA'
*.log_archive_dest_2='SERVICE=incadg ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=incadg COMPRESSION=ENABLE'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=30

备库参数文件

incadg.__db_cache_size=8589934592
incadg.__java_pool_size=134217728
incadg.__large_pool_size=201326592
incadg.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
incadg.__pga_aggregate_target=838860800
incadg.__sga_target=12884901888
incadg.__shared_io_pool_size=0
incadg.__shared_pool_size=1073741824
incadg.__streams_pool_size=67108864
*.audit_file_dest='/u01/app/oracle/admin/incadg/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/data/incadg/control01.ctl','/data/incadg/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='inca'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=INCAXDB)'
*.job_queue_processes=1000
*.log_archive_dest_1='LOCATION=/data/arch'
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=838860800
*.processes=3000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=3305
*.sga_max_size=12884901888
*.sga_target=12884901888
*.undo_tablespace='UNDOTBS1'
#dg_parameter
*.db_file_name_convert='/data/INCA','/data/incadg'
*.db_unique_name='incadg'
*.fal_client='incadg'
*.fal_server='INCA'
*.log_archive_config='DG_CONFIG=(INCA,incadg)'
*.log_archive_dest_1='LOCATION=/data/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=incadg'
*.log_archive_dest_2='SERVICE=INCA ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=INCA COMPRESSION=ENABLE'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=30

2.备库创建adump、dpdump、pfile目录

mkdir /u01/app/oracle/admin/incadg/adump
mkdir /u01/app/oracle/admin/incadg/dpdump
mkdir /u01/app/oracle/admin/incadg/pfile

3.备份主库

source /home/oracle/.bash_profile
export DB_BASE=$ORACLE_BASE
export DB_HOME=$ORACLE_HOME
export OPATCH=$ORACLE_HOME/OPatch
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/share/lib
CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/jdbc/lib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
PATH=$PATH:$ORACLE_HOME/bin:$OPATCH
export CLASSPATH
export LD_LIBRARY_PATH
export dt=`date +%Y%m%d`
export PATH

rman target / log=/backup/cerptraindb/log/cerptraindb_$dt.log <<eof
RUN {
ALLOCATE CHANNEL t1 TYPE disk maxpiecesize=20480m;
ALLOCATE CHANNEL t2 TYPE disk maxpiecesize=20480m;
ALLOCATE CHANNEL t3 TYPE disk maxpiecesize=20480m;
ALLOCATE CHANNEL t4 TYPE disk maxpiecesize=20480m;

BACKUP
format '/backup/cerptraindb/rman/%d_%s_%p_%T.bak'
DATABASE;
sql 'alter system archive log current';
backup 
format '/backup/cerptraindb/rman/%d_%s_%p_%T.arc'
archivelog all delete all input;
release channel t1;
release channel t2;
release channel t3;
release channel t4;
ALLOCATE CHANNEL c1 TYPE disk;
ALLOCATE CHANNEL c2 TYPE disk;
backup spfile include current controlfile 
format '/backup/cerptraindb/rman/%d_%s_%p_%T.ctl';
release channel c1;
release channel c2;
}
exit;
eof

4.同步密码文件

scp /ora/app/oracle/product/11.2.0/dbhome_1/dbs/orapwINCA cerp01:/u01/app/oracle/product/11.2.0/db_1/orapwincadg

5.恢复备库

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
set until sequence 1175 thread 1;
set newname for datafile 1 to '/data/incadg/system01.dbf';
set newname for datafile 2 to '/data/incadg/sysaux01.dbf';
set newname for datafile 3 to '/data/incadg/undotbs01.dbf';
set newname for datafile 4 to '/data/incadg/users01.dbf';
set newname for datafile 5 to '/data/incadg/tasly20180102_01.dbf';
set newname for datafile 6 to '/data/incadg/tasly20180102_02.dbf';
set newname for datafile 7 to '/data/incadg/tasly20180102_index_01.dbf';
set newname for datafile 8 to '/data/incadg/cerpzs.dbf';
set newname for datafile 9 to '/data/incadg/cerpzs_index.dbf';
set newname for datafile 10 to '/data/incadg/tasly20180123_01.dbf';
set newname for datafile 11 to '/data/incadg/tasly20180123_02.dbf';
set newname for datafile 12 to '/data/incadg/tasly20180123_index_01.dbf';
set newname for datafile 13 to '/data/incadg/tasly20180123_index_02.dbf';
set newname for tempfile 1 to '/data/incadg/temp01.dbf';
restore database;
switch datafile all; 
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}

6.主库创建standby控制文件

#创建standby_controlfile
SQL> alter database create standby controlfile as '/home/oracle/incadg.ctl';

#复制备机控制文件
scp /home/oracle/incadg.ctl cerp01:/home/oracle/incadg.ctl

7.备库使用pfile启动数据库

startup mount pfile=’ /u01/app/oracle/product/11.2.0/db_1/dbs/initincadg.ora’;

8.恢复备库

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
set until sequence 1175 thread 1;
set newname for datafile 1 to '/data/incadg/system01.dbf';
set newname for datafile 2 to '/data/incadg/sysaux01.dbf';
set newname for datafile 3 to '/data/incadg/undotbs01.dbf';
set newname for datafile 4 to '/data/incadg/users01.dbf';
set newname for datafile 5 to '/data/incadg/tasly20180102_01.dbf';
set newname for datafile 6 to '/data/incadg/tasly20180102_02.dbf';
set newname for datafile 7 to '/data/incadg/tasly20180102_index_01.dbf';
set newname for datafile 8 to '/data/incadg/cerpzs.dbf';
set newname for datafile 9 to '/data/incadg/cerpzs_index.dbf';
set newname for datafile 10 to '/data/incadg/tasly20180123_01.dbf';
set newname for datafile 11 to '/data/incadg/tasly20180123_02.dbf';
set newname for datafile 12 to '/data/incadg/tasly20180123_index_01.dbf';
set newname for datafile 13 to '/data/incadg/tasly20180123_index_02.dbf';
set newname for tempfile 1 to '/data/incadg/temp01.dbf';
restore database;
switch datafile all; 
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}

9.主库、备库创建standby redo文件

主库：

alter database add standby logfile group 4 ('/data/INCA/standby04.log') size 512M;
alter database add standby logfile group 5 ('/data/INCA/standby05.log') size 512M;
alter database add standby logfile group 6 ('/data/INCA/standby06.log') size 512M;
alter database add standby logfile group 7 ('/data/INCA/standby07.log') size 512M;
alter database add standby logfile group 8 ('/data/INCA/standby08.log') size 512M;

备库：

alter database add standby logfile group 4 ('/data/incadg/standby04.log') size 512M;
alter database add standby logfile group 5 ('/data/incadg/standby05.log') size 512M;
alter database add standby logfile group 6 ('/data/incadg/standby06.log') size 512M;
alter database add standby logfile group 7 ('/data/incadg/standby07.log') size 512M;
alter database add standby logfile group 8 ('/data/incadg/standby08.log') size 512M;
alter database add standby logfile group 9 ('/data/incadg/standby08.log') size 512M;

10.备库启动DG

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
recover managed standby database cancel;

11.查看DG状态

SQL> select open_mode,database_role,switchover_status from v$database;


 OPEN_MODE	     DATABASE_ROLE    SWITCHOVER_STATUS
-------------------- ---------------- --------------------
READ WRITE	     PRIMARY	      UNRESOLVABLE GAP


SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

 

吥輕誩放棄
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
利用RMAN复制功能在线或使用备份搭建单实例DG
03-14
搭建单实例文件系统ORACLE DG，分为2种情况： 1. 利用rman duplicate 在线搭建备库 2. 利用主库备份，离线方式搭建备库
Oracle 11g DG主从复制集群搭建
song12345xiao的博客
07-26 2715
Oracle 11g DG主从复制集群搭建
实战：Windows平台下搭建Oracle11g Dataguard
最新发布
专注于数据库技术分享，包含但不限于Oracle，MySQL，PostgreSQL，ElasticSearch及国产数据库等
03-06 1346
导读本文介绍在windows server 2012 r2 环境下搭建Oracle11g Dataguard。
在Oracle Data Guard环境中的RMAN备份和还原
jetliu05的博客
04-26 2836
Oracle Data Guard环境中的RMAN备份和还原
Oracle 11gR2 DG部署（RMAN方式）
热门推荐
onlyshenmin的博客
07-16 1万+
Oracle DG部署（RMAN方式） Oracle DG部署（RMAN方式） 1.环境介绍 2.DG部署 2.1.建立主库orcl 2.2.主库开启归档 2.3.主库添加Standby Redo Log 2.4.从主库创建pfile文件 2.5.设置主库初始化参数 2.6.设置备库初始化参数 2.7.复制主库的密码文件到备库 2.8.创建备库相应的目录结构 2.9.配置主库和备库的监听 ...
Oracle11g DataGuard不停机部署
DoubleJing的博客
12-05 743
Oracle DG部署（RMAN方式） 1.环境介绍 2.DG部署 2.1.建立主库orcl 2.2.主库开启归档 主库开启归档并设置强制日志 force logging --关闭数据库 SQL> shutdown immediate --以mount模式启动 SQL> startup mount --切换到归档模式 SQL> alter database archivelog; --开启强制日志 SQL> alter databas
Oracle 11gR2 dataguard搭建说明 --- rman方式.txt
04-09
Oracle 11gR2 dataguard搭建说明
Oracle 11gR2 dataguard搭建说明 --- duplicate方式.txt
04-09
Oracle 11gR2 dataguard搭建说明
rhel7.5下配置Oracle11gR2 DataGuard物理备库-完整版
03-15
64位RHEL7.5环境下配置Oracle11gR2(11.2.0.4)物理备库 安装环境简介 DataGuard 原理概述 1. 备库类型 2. 物理和逻辑的区别 3. 创建过程的不同 4. 主备切换 5. 物理备库原理图 6. 逻辑备库原理图 7. 同步查询原理...
Oracle 11gR2 使用RMAN 复制搭建物理Data Guard
10-09
大牛出手，全是干货，Oracle 11gR2 使用RMAN 复制搭建物理Data Guard。 注：文档打开密码见压缩包注释
(完整版)Oracle-11G-DataGuard配置.doc
11-19
(完整版)Oracle-11G-DataGuard配置.doc
oracle 手动搭建dg --rman 备份恢复脚本
Lixora's DB Home
12-26 579
#### rman 手动备份脚本 rman msglog /home/oracle/adg_setup.log << EOF connect target RUN { allocate channel c1 device type disk; allocate channel c2 device type disk; allocate channel c3 device type ...
DG的搭建过程
weixin_44196863的博客
07-04 502
创建物理备库: 强制启用日志 配备备用重做日志及归档位置 主库启用归档模式 做主库的完全备份 创建物理备库的网络服务名、静态监听 复制主库口令到备库 创建备库的初始化参数和目录 使用rman连接到主库（目标数据库），以及辅助数据库 使用预先创建的脚本复制数据库 在主库执行强制日志切换 在备库的/etc/oratab文件中添加备库的oraxle_home路径
dg搭建错误
weixin_43475880的博客
07-21 697
duplicate时归档出错 RMAN> duplicate target database for standby from active database doreco ver nofilenamecheck; Starting Duplicate Db at 21-JUL-21 using target database control file instead of recovery catalog allocated channel: ORA_AUX
Oracle11g ADG部署 duplicate方式（超级详细）
weixin_52444902的博客
09-14 3171
oracle11g版本ADG详细部署
Oracle DG--Rman备份集搭建备库
袁子建
06-16 1393
常用的在线备库搭建有Rman auxiliary 和Rman备份集恢复两种方式。（一）在环境配置OK的问题下，使用一条Rman命令就可以完成备库初始化同步，比较简单。#登陆rmantargetsys/Oracle123@orcl_priauxiliarysys/Oracle123@orcl_dg #开始搭建辅助数据库RMAN>duplicatetarget...
基于rman 全备+归档在线搭建DG
weixin_34314962的博客
12-25 283
主从两台主机hosts配置192.168.1.197 oradb1（从）192.168.1.198 oradb2(主）二:搭建数据库主库的操作： 1.确认主库参数SQL> select name,open_mode,database_role,log_mode,force_logging from v$database; NAME OPEN_MODE ...
不停机备份oracle,不停机进行Oracle数据库克隆的实验
weixin_39838302的博客
04-03 385
2.1.4) 启动辅助实例startup nomount2.1.5) 配置监听和网络服务名cd $Oracle_HOME/network/adminvi listener.oravi tnsnames.ora2.2) 启动目标数据库到MOUNT或OPEN模式startup2.3) 验证备份rman target /connected to target database: PROD (DBID=2...
DG故障导致的主库归档无法自动删除导致主库磁盘空间耗尽数据库无法连接
zongzizz的博客
08-24 725
DG故障导致的主库归档无法自动删除导致主库磁盘空间耗尽数据库无法连接
oracle 19c rac dataguard搭建
06-25
Oracle 19c RAC DataGuard搭建是一种高可用性和容灾解决方案。RAC集群可以提供跨数据中心的集群解决方案。DataGuard技术可以帮助数据库管理员在灾难发生时迅速切换到备份数据库。 Oracle 19c RAC DataGuard搭建可以...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值