RAC基本备份恢复（二）

最新推荐文章于 2024-06-01 15:56:03 发布
最新推荐文章于 2024-06-01 15:56:03 发布
阅读量775 收藏
点赞数
分类专栏： rac
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/dbadoudou/article/details/9627321
版权

RAC基本备份恢复（二）

一、RAC中RMAN备份脚本

 

1、  归档日志在本地的scripts

run{

ALLOCATECHANNEL d1 TYPE disk connect 'sys/oracle@racdb1';

ALLOCATECHANNEL d2 TYPE disk connect 'sys/oracle@racdb2';

backupas compressed backupset incremental level 0 database filesperset 4 format

'/rman/backup/data/level0_%d_%s_%p_%u_%T.bak'include current controlfile;

sql'alter system archive log current';

backuparchivelog all filesperset 10 format'/rman/backup/arch/arc_%d_%s_%p_%u_%T.bak';

releasechannel d1;

releasechannel d2;}

2、  归档日志在ASM的scripts

run{

backupas compressed backupset incremental level 0 database filesperset 4 format

'/rman/backup/data/level0_%d_%s_%p_%u_%T.bak'include current controlfile;

sql'alter system archive log current';

backuparchivelog all filesperset 10 format'/rman/backup/arch/arc_%d_%s_%p_%u_%T.bak';

releasechannel d1;}

 

二、恢复时，单实例进行恢复

1、归档日志在本地的：把备份集和归档日志copy到单实例机器进行统一恢复

2、归档日志在ASM的：直接恢复即可

 

 

RAC中RMAN备份脚本（指定双节点）

run{

ALLOCATE CHANNEL d1 TYPE disk connect 'sys/oracle@racdb1';

ALLOCATE CHANNEL d2 TYPE disk connect 'sys/oracle@racdb2';

backup as compressed backupset incremental level 0 database filesperset 4 format

'/rman/backup/data/level0_%d_%s_%p_%u_%T.bak' include current controlfile;

sql 'alter system archive log current';

backup archivelog all filesperset 10 format '/rman/backup/arch/arc_%d_%s_%p_%u_%T.bak';

release channel d1;

release channel d2;}

 

附表

11gr2RAC tnsnames.ora配置如下

节点1

[oracle@dou_rac1 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

RACDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dou_rac-scan)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = racdb)

    )

  )

节点2

[oracle@dou_rac2 admin]$ cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

RACDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dou_rac-scan)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = racdb)

    )

  )

 

一、 添加tnsnames.ora（为了方便RMAN配置，需要在tnsnames.ora中添加racdb1,racdb2）

双节点均需添加

RACDB1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.217)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = racdb)

    )

  )

RACDB2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.220)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = racdb)

    )

  )

 

 

归档日志均放在节点本地目录

节点1

sys@RACDB> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /rman/arch

Oldest online log sequence     12

Next log sequence to archive   13

Current log sequence           13

节点2

sys@RACDB> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /rman/arch

Oldest online log sequence     11

Next log sequence to archive   12

Current log sequence           12

 

 

Rman备份详细过程

RMAN> run{

2> ALLOCATE CHANNEL d1 TYPE disk connect 'sys/oracle@racdb1';

3> ALLOCATE CHANNEL d2 TYPE disk connect 'sys/oracle@racdb2';

4> backup as compressed backupset incremental level 0 database filesperset 4 format

5> '/rman/backup/data/level0_%d_%s_%p_%u_%T.bak' include current controlfile;

6> sql 'alter system archive log current';

7> backup archivelog all filesperset 10 format '/rman/backup/arch/arc_%d_%s_%p_%u_%T.bak';

8> release channel d1;

9> release channel d2;}

 

allocated channel: d1

channel d1: SID=33 instance=racdb1 device type=DISK          --分配双通道（d1通道）

 

allocated channel: d2

channel d2: SID=32 instance=racdb2 device type=DISK          --分配双通道（d2通道）

 

Starting backup at 2013-07-23 09:12:23                       --备份开始时间

channel d1: starting compressed incremental level 0 datafile backup set  --0级压缩备份

channel d1: specifying datafile(s) in backup set

input datafile file number=00001 name=+DATA/racdb/datafile/system.256.821458313

input datafile file number=00005 name=+DATA/racdb/datafile/undotbs2.264.821458799

input datafile file number=00004 name=+DATA/racdb/datafile/users.259.821458317

channel d1: starting piece 1 at 2013-07-23 09:12:24

channel d2: starting compressed incremental level 0 datafile backup set

channel d2: specifying datafile(s) in backup set

input datafile file number=00002 name=+DATA/racdb/datafile/sysaux.257.821458317

input datafile file number=00003 name=+DATA/racdb/datafile/undotbs1.258.821458317

input datafile file number=00006 name=+DATA/racdb/datafile/doudou.268.821465747

channel d2: starting piece 1 at 2013-07-23 09:12:17

channel d2: finished piece 1 at 2013-07-23 09:12:54

piece handle=/rman/backup/data/level0_RACDB_26_1_0qofetrh_20130723.bak tag=TAG20130723T091223 comment=NONE                --生成备份集的名称和标记

channel d2: backup set complete, elapsed time: 00:00:37      --备份集完成时间

channel d2: starting compressed incremental level 0 datafile backup set

channel d2: specifying datafile(s) in backup set

including current control file in backup set                     --备份当前控制文件

channel d2: starting piece 1 at 2013-07-23 09:12:58

channel d2: finished piece 1 at 2013-07-23 09:12:59

piece handle=/rman/backup/data/level0_RACDB_27_1_0rofetsn_20130723.bak tag=TAG20130723T091223 comment=NONE           --当前控制文件备份集名称和标记

channel d2: backup set complete, elapsed time: 00:00:01      --控制文件备份完成时间

channel d2: starting compressed incremental level 0 datafile backup set

channel d2: specifying datafile(s) in backup set

including current SPFILE in backup set                           --备份当前参数文件

channel d2: starting piece 1 at 2013-07-23 09:13:00

channel d2: finished piece 1 at 2013-07-23 09:13:01

piece handle=/rman/backup/data/level0_RACDB_28_1_0sofetss_20130723.bak tag=TAG20130723T091223 comment=NONE

channel d2: backup set complete, elapsed time: 00:00:01

channel d1: finished piece 1 at 2013-07-23 09:13:22

piece handle=/rman/backup/data/level0_RACDB_25_1_0pofetro_20130723.bak tag=TAG20130723T091223 comment=NONE

channel d1: backup set complete, elapsed time: 00:00:58

Finished backup at 2013-07-23 09:13:22

 

sql statement: alter system archive log current

 

Starting backup at 2013-07-23 09:13:27

current log archived

channel d1: starting archived log backup set                     --通道d1开始备份归档日志

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=8 RECID=9 STAMP=821515041   --节点1

input archived log thread=1 sequence=9 RECID=10 STAMP=821515044

input archived log thread=1 sequence=10 RECID=14 STAMP=821521768

channel d1: starting piece 1 at 2013-07-23 09:13:33

channel d2: starting archived log backup set                     --通道d2开始备份归档日志

channel d2: specifying archived log(s) in backup set

input archived log thread=2 sequence=8 RECID=12 STAMP=821521724  --节点2

input archived log thread=2 sequence=9 RECID=13 STAMP=821521761

input archived log thread=2 sequence=10 RECID=16 STAMP=821521859

channel d2: starting piece 1 at 2013-07-23 09:13:27

channel d1: finished piece 1 at 2013-07-23 09:13:35

piece handle=/rman/backup/arch/arc_RACDB_29_1_0tofettt_20130723.bak tag=TAG20130723T091333 comment=NONE                --归档日志备份集和标识

channel d1: backup set complete, elapsed time: 00:00:02

channel d1: starting archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=11 RECID=15 STAMP=821521865

input archived log thread=1 sequence=12 RECID=18 STAMP=821521871

channel d1: starting piece 1 at 2013-07-23 09:13:35

channel d2: finished piece 1 at 2013-07-23 09:13:29

piece handle=/rman/backup/arch/arc_RACDB_30_1_0uofettm_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d2: backup set complete, elapsed time: 00:00:02

channel d2: starting archived log backup set

channel d2: specifying archived log(s) in backup set

input archived log thread=2 sequence=11 RECID=17 STAMP=821521862

input archived log thread=2 sequence=12 RECID=20 STAMP=821524398

channel d2: starting piece 1 at 2013-07-23 09:13:29

channel d1: finished piece 1 at 2013-07-23 09:13:35

piece handle=/rman/backup/arch/arc_RACDB_31_1_0vofettv_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d1: backup set complete, elapsed time: 00:00:00

channel d1: starting archived log backup set

channel d1: specifying archived log(s) in backup set

input archived log thread=1 sequence=13 RECID=19 STAMP=821524403

input archived log thread=1 sequence=14 RECID=22 STAMP=821524410

channel d1: starting piece 1 at 2013-07-23 09:13:36

channel d2: finished piece 1 at 2013-07-23 09:13:29

piece handle=/rman/backup/arch/arc_RACDB_32_1_10ofettp_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d2: backup set complete, elapsed time: 00:00:00

channel d2: starting archived log backup set

channel d2: specifying archived log(s) in backup set

input archived log thread=2 sequence=13 RECID=21 STAMP=821524401

channel d2: starting piece 1 at 2013-07-23 09:13:29

channel d1: finished piece 1 at 2013-07-23 09:13:36

piece handle=/rman/backup/arch/arc_RACDB_33_1_11ofetu0_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d1: backup set complete, elapsed time: 00:00:00

channel d2: finished piece 1 at 2013-07-23 09:13:30

piece handle=/rman/backup/arch/arc_RACDB_34_1_12ofettp_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d2: backup set complete, elapsed time: 00:00:01

Finished backup at 2013-07-23 09:13:37

released channel: d1

released channel: d2

 

 

 

 

RMAN通道与备份集生成的位置

总结：

RMAN使用2个通道（d1,d2）进行备份：

使用d1时（channel d1:）备份集就会生成在节点1上。

使用d2时（channel d2:）备份集就会生成在节点2上。

实验说明：

piece handle=/rman/backup/arch/arc_RACDB_33_1_11ofetu0_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d1: backup set complete, elapsed time: 00:00:00

piece handle=/rman/backup/arch/arc_RACDB_34_1_12ofettp_20130723.bak tag=TAG20130723T091333 comment=NONE

channel d2: backup set complete, elapsed time: 00:00:01

节点1

channel d1

[oracle@dou_rac1 arch]$ ls -l arc_RACDB_33_1_11ofetu0_20130723.bak

-rw-r----- 1 oracle oinstall 1847808 07-23 09:13 arc_RACDB_33_1_11ofetu0_20130723.bak

节点2

channel d2

[oracle@dou_rac2 arch]$ ls -l arc_RACDB_34_1_12ofettp_20130723.bak

-rw-r----- 1 oracle asmadmin 2560 07-23 09:13 arc_RACDB_34_1_12ofettp_20130723.bak

 

 

 

lovehewenyu
关注
专栏目录
oracle增量备份level0,ORACLE RMAN增量备份经典理解
weixin_42370320的博客
04-04 850
中，增量时分等级的，级别从0开始，一级一级递增，不过实际上用的最多的也就是0级和1级了，0级增量是后面级别的增量备份的 基础，0级备份实际上就是一个完全备份，与普通的完全备份唯一的不同点是0级备份可以作为其他级别增量备份的基础，而普通的完全备份是不能的。从级别1开始，Oracle的增量备份分为差异增量备份和积累增量备份两种，其中差异增量备份备份的是自上一次同级别的差异备份或者是上一次更高级 别的备...
一次逻辑坏块恢复过程
jarry_gao的专栏
07-24 2540
ORA-07445: exception encountered: core dump [kghstack_err+0068] [SIGSEGV] [Addre ss not mapped to object] [0x30018006C510113E] [] [] ORA-00600: internal error code, arguments: [kghstack_free2], [],
oracle rman迁移spfile,RMAN 异机迁移实战操作-附加常用命令
weixin_33048721的博客
04-03 261
操作操作场景源服务器 OEL 6.3 11G R2 11.2.0.3目标服务器 OEL 6.3 11G R2 11.2.0.3源服务器和目标服务器存放数据路径一样源服务器[Oracle@mxq ~]$ rman target /Recovery Manager: Release 11.2.0.2.0 - Production on Sat May 16 08:51:05 201...
oracle异机还原一个pdb,CDB中备份，以及异机恢复的测试
weixin_32081953的博客
04-12 999
cdb+pdb$seed全备 (由于cdb和pdb$seed种子库所占空间总容量不多，所以每次都可以执行全备，不完全恢复的时候，restore时注意选择cdb库的时间)RUN{ALLOCATE CHANNEL ch0 TYPE DISK;backup as compressed backupset INCREMENTAL LEVEL=0 FILESPERSET 5 database root ta...
rman备份恢复详细方案和介绍
热门推荐
Brent的专栏
06-28 1万+
文档下载地址:https://download.csdn.net/download/su377486/11262567 备份工具 rman简介 RMAN（Recovery Manager）是随Oracle服务器软件一同安装的工具软件，它可以用来备份和恢复数据库文件、归档日志和控制文件，用来执行完全或不完全的数据库恢复。与传统工具相比，RMAN具有独特的优势：跳过未使...
RAC的备份恢复
jnrjian的博客
04-15 1293
RAC和单实例数据库备份机制是一样的，有两点需要注意： （1）RMAN要连接到集群中的某个实例，而不是连接到整个集 （2）备份归档日志时，必须保证在备份实例上能够访问所有实例的归档日志，否则就会报错。 一．RAC归档的设置 1.1相关理论知识 RAC在运行的时候，每个实例都会产生归档日志，所有实例的归档日志集中在一起，才能完整地代表数据库的操作历史，此外，只有进行介质恢复（Media Recovery）时，才会用到归档日志。进...
11.2.0.3RAC 备份集恢复为单实例11.2.0.4_法一:rman备份恢复
qq961573863的博客
06-01 1028
关键步骤：1、移动硬盘格式化成Linux可以识别的文件系统，mount到备份目录，开始rman备份，备份完成后，插到目标服务器挂载，2、恢复参数文件nomount库，恢复控制文件mount库，restore renew数据文件路径，recover 库 ,关库，升级， 清理redo， 删除多余undo。
RAC备份恢复到单节点
Paladin的专栏
03-27 1725
1简单说明：   版本：11.2.0.3  平台：linux-x86-64 到 win7-64bit  实例： bdstar1，bdstar2  还原到   bdstar  上  参考：三思笔记数据库备份与恢复 2 windows平台系统恢复环境创建 创建实例：oradim -new -sid bdstar 编写一个简单的参数文件： *.audit_file_dest='E:
Oracle19c rac备份数据通过rman恢复到单实例
最新发布
07-02
在进行Oracle 19c RAC（Real Application Clusters）数据库的数据备份与恢复操作时，可能会遇到需要将RAC集群环境下的备份数据恢复到单实例环境中的场景。这种情况下，RMAN（Recovery Manager）作为Oracle提供的强大...
【RAC】rac数据库的备份和恢复rac数据库的备份和恢复.pdf
07-31
本文旨在详细介绍RAC环境下Oracle数据库的备份与恢复策略，包括备份的基本概念、常用方法以及恢复过程中的注意事项。 #### 二、RAC数据库备份概述 ##### 2.1 RAC数据库备份的重要性 在RAC环境中进行数据库备份是...
华为BackupExec Oracle RAC数据库备份恢复详述
本资源是一份名为《BackupExec ORACLE RAC数据库备份恢复指导书》的文档，由华为技术有限公司发布，文档日期为2011年8月9日，属于机密级别，未经许可不得随意传播。该文档详细介绍了在Oracle Real Application ...
ins-40937 following host names are not valid(下划线“_”导致)
09-24 3122
ins-40937 following host names are not valid(下划线“_”导致)   总结：/etc/hosts配置中 ias最好不使用下划线“_”，不符合RFC 952规则，会报错   192.168.1.1     rac1-priv 192.168.1.2     rac2-priv 192.168.8.3    rac1-vip 192.168.8
Rac中使用create pfile from spfile后的解决方法与启动参数文件的奥秘？
09-24 2496
Rac中使用create pfile from spfile后的解决方法 一、问题解决   1、  查看正常RAC中有关，parameter记录 节点spfile 位置 SQL> show parameter pfile   NAME                   TYPE        VALUE ------------------------------------ -
Oracle 12.1.0.2 expdp导出分区表数据bug慢的原因和解决方法
11-03 2136
Oracle 12.1.0.2 expdp导出分区表数据bug慢的原因和解决方法 简述：Oracle版本12.1.0.2在expdp时导出分区表数据慢，遇到Bug 20236523 : DATAPUMP EXPORT SLOW USING CONTENT=METADATA_ONLY。 解决方法：第1种：升级至12.2.0.1；第2种：exp代替expdp。本文我们主要讲第2种方法：exp代替expdp。 环境 os：redhat 7.3 db：12.1.0.2 1.原理通...
11Gr2 RAC udev ASM openfiler（安装文档）
08-22 1497
11Gr2RAC udev ASM openfiler（安装文档）   一、11Gr2 RAC安装前准备 ASM disk findiscsi target; iscsiadm -m discovery -t st -p 192.168.1.218 autoiscsi target; iscsiadm -m node -T iqn.2006-01.com.openfiler:data
Oracle 12.2 RAC修改public ip address或public ip（subnet (netmask) or interface)方法
11-09 824
Oracle 12.2 RAC修改public ipaddress或public ip（subnet (netmask) or interface)方法 场景：Oracle 12.2 RAC修改IP信息一般有2种场景 第一种场景：oracle rac 中修改public ip/vip/pirv ip/scan ip 但不修改(subnet (netmask) or interface)的方法 public ip => 仅os修改主机ip和/etc/hosts vip=> 仅修改/e...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值