首页 > 代码库 > Oracle 11g 中恢复管理器RMAN介绍

Oracle 11g 中恢复管理器RMAN介绍

这是我平时摘录的笔记,从管理艺术那本书上摘录出来的,放到这里

 

RMAN 可在数据库服务器的帮助下从数据库内备份数据文件,可构造数据文件映像副本、控制文件和控制文件映像、对当日志 SPFILE 和RMAN备份片的备份,建议使用RMAN界面备份数据库

 

 RMAN好处:

 

1 增量备份
2 可联机修补数据文件的部分讹误数据块,不需要从备份文件复原文件 称为介质恢复
3 人为错误最小化
4 一条简单命令 BACKUP DATABASE即可
5 RMAN新的快比较特性允许在备份中跳过数据文件中从未使用的数据块备份,节省存储空间和备份时间
6 通过RMAN容易进行自动化备份和恢复
7 在备份和恢复中可 进行错误检查
8 RMAN在联机备份中不生成重做信息,降低联机备份开销
9 二进制压缩特性降低保存磁盘上备份的大小
10 使用恢复目录catelog可直接在其中的存储备份和恢复脚本
11 RMAN 可执行模拟备份和恢复
12 允许进行映像复制,类似操作系统的文件备份
13 RMAN与第三方介质管理产品集成,使磁带备份极为容易
14 RMAN与OEM集成的很好
15 可利用RMAN功能方便克隆数据库和维护备用数据库

 

RMAN执行其备份和恢复功能的条目列表

 

目标数据库:RMAN需要备份的数据库
RMAN信息库:RMAN关于备份。归档重做日志及其拥有的活动的元数据,每个数据库控制文件为RMAN信息    库主存储
恢复目录模式:拥有RMAN备份和恢复元数据的数据库中数据库模式
RMAN客户机:用户通过RMAN客户机管理RMAN操作
RMAN可执行程序:管理所有备份和恢复操作的实际程序
服务器进程:RMAN可执行程序与目标数据库通信的后台进程,在备份和恢复中完成读写磁盘和磁带设备的实际工作

注:在使用RMAN中,有三个实体是可选的:闪回恢复区 恢复目录数据库和介质管理软件

 

RMAN信息库和恢复目录

RMAN信息库包含的条目信息:

数据文件备份集合副本
归档重做日志副本和备份集
表空间和数据文件信息
存储脚本和RMAN配置设置

RMAN的信息首先写入到控制文件,然后在写到恢复目录(如果存在)

在创建新备份集时,可在V$BACKUP_SET视图看到响应的信息,也可以在恢复目录视图RC_BACUP_SET中看到相同的信息

SQL> select * from V$BACKUP_SET;

     RECID	STAMP  SET_STAMP  SET_COUNT B CON INCREMENTAL_LEVEL	PIECES START_TIM COMPLETIO ELAPSED_SECONDS BLOCK_SIZE INP KEE KEEP_UNTI KEEP_OPTION MUL
---------- ---------- ---------- ---------- - --- ----------------- ---------- --------- --------- --------------- ---------- --- --- --------- ----------- ---
	 1  929985613  929985608	  1 L NO			     1 07-DEC-16 07-DEC-16		 5	  512 NO  NO			    NO
	 2  929985708  929985624	  2 D NO			     1 07-DEC-16 07-DEC-16		84	 8192 NO  NO			    NO
	 3  929985711  929985709	  3 D YES			     1 07-DEC-16 07-DEC-16		 2	16384 NO  NO			    NO
	 4  929985721  929985720	  4 L NO			     1 07-DEC-16 07-DEC-16		 1	  512 NO  NO			    NO

有一些RMAN命令可在仅使用恢复目录时使用。还可以在仅使用恢复目录时使用RMAN存储脚本。如果使用控制文件,要冒某些历史数据被覆盖的风险,但恢复目录将保障这些数据的安全,这是因为控制文件与备份有关的活动分配的空间有限,从而恢复目录有更多的空间存储备份历史。系统中的一个恢复目录可对多个Oracle数据库执行备份、复原和恢复活动.Oracle建议使用专门的数据库来运行恢复目录

连接到RMAN

[oracle@gzxbi01 ~]{content}nbsp;rman

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Dec 8 16:04:15 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target /

connected to target database: YOON (DBID=781817860)

-- 或者
[oracle@gzxbi01 ~]{content}nbsp;rman target system/alog20160428

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Dec 8 16:07:34 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: YOON (DBID=781817860)

RMAN> 
-- 或者通过操作系统认证
[oracle@gzxbi01 ~]{content}nbsp;rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Dec 8 16:09:25 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: YOON (DBID=781817860)

 

在ORACLE 10g 版本2中,引用了自己的专有介质管理方案 Oracle Secure Backup

 

RMAN脚本,提供了两种脚本:

1 存储脚本:保存在RMAN恢复目录中

2 文本脚本:保存在普通的文本文件中

 

 RMAN术语:

1 备份片

一个操作系统文件 包含一个数据文件、一个控制文件或数个归档重做日志文件的备份,备份信息以RMAN专门格式存储

2 备份集

逻辑结构,由一个或多个RMAN备份片组成。可在磁盘或磁带上创建备份集,备份集时仅RMAN能识别的适当格式的一个文件或一组文件,只有RMAN才能使用备份集恢复数据库

3 映像文件

类似UNIX中用cp命令或DOC中用COPY命令所做的操作系统文件备份,可制作数据文件、控制文件和归档重做日志文件的映像副本。RMAN映像副本只能做到磁盘,不能做到磁带中

4 代理副本

还可以执行一种叫代理副本的特殊备份,其中介质管理器得到复制进程的控制权,对磁盘不能使用代理副本。

5 通道

RMAN必须使用对服务器的某种连接,以执行备份和恢复任务,通道就代表这种连接。通道指定用于备份或恢复的设备、磁盘或磁带。可预先配置通道。也可手动指定 

RMAN还可以使用利用非RMAN操作系统应用程序做的副本,这些类型的副本称为用户管理的副本或操作系统副本

 

 RMAN允许对每个备份使用一个标记tag,以便容易地识别出相应的备份

 标记全数据库备份

SQL>BACKUP TAG ‘weekly_full_db_bkup‘ DATABASE;

 备份命令还可以使员工FORMAT来指定备份片和副本的位置和名字们使用替换变量来生成唯一的文件名

SQL>BACKUP FORMAT=‘AL_%d/%t/%s/%p‘ ARCHIVELOG LIKE ‘%arc_dest%‘;

 

RMAN命令

备份命令
作业命令
复制命令
报告命令
列表命令
验证命令

 

备份命令

RMAN> BACKUP DATABASE;

Starting backup at 09-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=200 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T104834_d4n6w3lm_.bkp tag=TAG20161209T104834 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:16
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_TAG20161209T104834_d4n70cdv_.bkp tag=TAG20161209T104834 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16

RMAN> BACKUP TABLESPACE users;
Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T105136_d4n71s00_.bkp tag=TAG20161209T105136 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16
RMAN> BACKUP DATAFILE ‘/u01/app/oracle/oradata/yoon/users01.dbf‘;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T105248_d4n7412s_.bkp tag=TAG20161209T105248 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16

使用简单的BACKUP DATABASE命令与使用BACKUP AS BACKUPSET DATABASE命令相同。如果使用上述命令,RMAN将生成一个或多个备份集。他们是RMAN专门的逻辑备份单元

映像复制备份

RMAN> BACKUP AS COPY DATABASE;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_system_d4n7orl8_.dbf tag=TAG20161209T110216 RECID=3 STAMP=930135794
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_sysaux_d4n7qwjt_.dbf tag=TAG20161209T110216 RECID=4 STAMP=930135854
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_undotbs1_d4n7sk41_.dbf tag=TAG20161209T110216 RECID=5 STAMP=930135865
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_example_d4n7t08c_.dbf tag=TAG20161209T110216 RECID=6 STAMP=930135881
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/recovery_area/YOON/controlfile/o1_mf_TAG20161209T110216_d4n7thbt_.ctl tag=TAG20161209T110216 RECID=7 STAMP=930135888
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7tllf_.dbf tag=TAG20161209T110216 RECID=8 STAMP=930135890
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnsnf_TAG20161209T110216_d4n7tmsz_.bkp tag=TAG20161209T110216 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16
RMAN> BACKUP AS COPY TABLESPACE USERS;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7xwgq_.dbf tag=TAG20161209T110636 RECID=9 STAMP=930135997
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16

RMAN> BACKUP AS COPY DATAFILE ‘/u01/app/oracle/oradata/yoon/users01.dbf‘;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7ym0w_.dbf tag=TAG20161209T110658 RECID=10 STAMP=930136019
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:02
Finished backup at 09-DEC-16

 

可以在备份时候,使用tag

RMAN> BACKUP DATABASE TAG=‘weekly_backup‘;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_WEEKLY_BACKUP_d4n89gvn_.bkp tag=WEEKLY_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_WEEKLY_BACKUP_d4n8drs0_.bkp tag=WEEKLY_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 09-DEC-16

 

RMAN备份逻辑检查

在备份过程中使用关键字LOGICAL让RMAN对备份文件进行逻辑检查。

 

增量备份

增量备份的级别为0或者1,

0:像完整备份一样复制所有的数据库,并且作为后续增量备份的基础

1:首先有一个基本的级别为0的备份

提供了两种类型

差异备份:备份最近级别为1或级别为0的增量备份后更改的所有块

累计备份:备份最近级别为0的增量备份后更改的所有块

开始一个级别为0的备份,

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnnd0_TAG20161209T113141_d4n9dyty_.bkp tag=TAG20161209T113141 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsn0_TAG20161209T113141_d4n9j87n_.bkp tag=TAG20161209T113141 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16

一旦有了级别为0的备份,可执行级别为1的差异增量备份

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnnd1_TAG20161209T113421_d4n9kxs2_.bkp tag=TAG20161209T113421 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsn1_TAG20161209T113421_d4n9lqj6_.bkp tag=TAG20161209T113421 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16

增量备份文件大小取决于更改过的块的数据和增量级别.累积备份比差异备份大,因为他们复制相同级别备份所复制的数据。具有减少恢复时间的有几点,如果空间不是个问题,建议累积备份

 

结合增量备份提出的备份策略

星期天 执行一个级别为0的增量备份
星期一到星期六,执行级别为1的差异增量备份
下一周重复这个循环

在这个策略中,如果需要星期四晚上恢复数据,应该讲星期一到星期三的增量备份应用到星期天的级别为0的备份

考虑一个累积备份替代策略

星期天,执行级别为0的增量备份
星期一到星期六,执行级别为1的累积增量备份
下一周重复这个循环

在此情况下,每天的级别为1的累积备份将备份自星期天备份以来更改的所有块。因此,如果星期四需要恢复,只需要将头天晚上的为一个累积备份应用到星期天的级别为0的增量备份即可

 

作业命令

不能单独使用ALLOCATE CHANNEL和SWITCH命令,必须与RUN命令一起使用

SQL>RUN{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK
PARMS=‘ENV=(NSR_GROUP=default)‘;
BACKUP DATAFILE 1;
}

allocated channel: c1
channel c1: SID=200 device type=DISK

Starting backup at 09-DEC-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
channel c1: starting piece 1 at 09-DEC-16
channel c1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T135641_d4nkwsns_.bkp tag=TAG20161209T135641 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:25
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 09-DEC-16
channel c1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_TAG20161209T135641_d4nkxmok_.bkp tag=TAG20161209T135641 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16
released channel: c1



ALLOCATE CHANNEL c1 DEVICE TYPE DISK 这个类型可以从

RMAN> list backup;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    3.27M      DISK        00:00:01     09-DEC-16      

这里可以查出来

SWITCH 命令类似于ALTER DATABASE RENAME  DATAFILE命令,允许用RMAN所做的文件副本替换一个数据文件

 

数据文件副本

RMAN的BACKUP AS COPY命令构造数据文件的一个无格式副本,但Oracle不加以在10g使用COPY命令。这些映像副本等同于使用操作系统使用程序所做的副本

RMAN> BACKUP AS COPY DATAFILE 1;

Starting backup at 09-DEC-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=200 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
output file name=/u01/app/oracle/recovery_area/YOON/datafile/o1_mf_system_d4nln51m_.dbf tag=TAG20161209T140908 RECID=11 STAMP=930146971
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/recovery_area/YOON/controlfile/o1_mf_TAG20161209T140908_d4nlnxq6_.ctl tag=TAG20161209T140908 RECID=12 STAMP=930146974
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 09-DEC-16
channel ORA_DISK_1: finished piece 1 at 09-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnsnf_TAG20161209T140908_d4nlo0x7_.bkp tag=TAG20161209T140908 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 09-DEC-16

-- 使用旧的COPY命令
RMAN> COPY DATAFILE 1 TO ‘/tmp/test.copy‘;

Starting backup at 09-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
output file name=/tmp/test.copy tag=TAG20161209T141120 RECID=13 STAMP=930147105
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
Finished backup at 09-DEC-16

 

备份删除

使用DELETE命令来删除RMAN所做的物理备份,DELETE命令删除物理备份,更新控制文件记录及支出备份已删除,而且此命令还从恢复目录中删除备份的记录,可删除备份集。归档重做日志和数据文件副本

通常应该使用RMAN的DELETE命令而不是操作系统的删除命令来删除RMAN备份,否则,RMAN的信息库将会包含不在可用的备份记录

删除RMAN已经至少两次备份到磁盘的所有归档重做日志

RMAN> DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE DISK;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=200 device type=DISK
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_67_929897742.dbf thread=1 sequence=67
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_68_929897742.dbf thread=1 sequence=68
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_69_929897742.dbf thread=1 sequence=69
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_70_929897742.dbf thread=1 sequence=70
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_71_929897742.dbf thread=1 sequence=71
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_72_929897742.dbf thread=1 sequence=72
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_73_929897742.dbf thread=1 sequence=73
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_74_929897742.dbf thread=1 sequence=74
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_75_929897742.dbf thread=1 sequence=75
RMAN-08138: WARNING: archived log not deleted - must create more backups
archived log file name=/u01/oradata/archive_bak/1_76_929897742.dbf thread=1 sequence=76

DELETE OBSOLETE命令将删除所有不在需要的备份,可以定期执行DELETE OBSOLETE删除所有废弃的备份。

DELETE EXPIRED命令删除国企的备份的恢复目录记录,并将它们标记成DELETED。可以先执行CROSSCHECK命令,RMAN标记它不能找到的备份为国企。一个备份过期代表RMAN不能找到该备份文件,可是使用DELETE EXPIRED命令从控制文件和恢复目录删除这些文件的记录

 

报告命令

RMAN提供了几个非常有用的报告命令,他们允许检查备份和恢复过程。可查询RMAN,有哪些文件需要备份,哪些文件废弃,从而可以删除

REPORT SCHEMA命令列出目标数据库的所有数据文件

REPORT OBSOLETE命令显示被锁选择的保留策略认定为废弃的所有备份

RMAN> REPORT OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     2      07-DEC-16          /u01/app/oracle/oradata/yoon/standby_control01.ctl
Archive Log          141    07-DEC-16          /u01/oradata/archive_bak/1_67_929897742.dbf
Archive Log          143    07-DEC-16          /u01/oradata/archive_bak/1_68_929897742.dbf
Archive Log          145    08-DEC-16          /u01/oradata/archive_bak/1_69_929897742.dbf
Archive Log          147    08-DEC-16          /u01/oradata/archive_bak/1_70_929897742.dbf
Archive Log          149    08-DEC-16          /u01/oradata/archive_bak/1_71_929897742.dbf
Archive Log          151    08-DEC-16          /u01/oradata/archive_bak/1_72_929897742.dbf
Archive Log          153    08-DEC-16          /u01/oradata/archive_bak/1_73_929897742.dbf
Archive Log          155    09-DEC-16          /u01/oradata/archive_bak/1_74_929897742.dbf
Archive Log          157    09-DEC-16          /u01/oradata/archive_bak/1_75_929897742.dbf
Datafile Copy        6      09-DEC-16          /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_example_d4n7t08c_.dbf
Control File Copy     7      09-DEC-16          /u01/app/oracle/recovery_area/YOON/controlfile/o1_mf_TAG20161209T110216_d4n7thbt_.ctl
Datafile Copy        8      09-DEC-16          /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7tllf_.dbf
Datafile Copy        9      09-DEC-16          /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7xwgq_.dbf
Backup Set           9      09-DEC-16         
  Backup Piece       9      09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnsnf_TAG20161209T110216_d4n7tmsz_.bkp
Datafile Copy        10     09-DEC-16          /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7ym0w_.dbf
Backup Set           10     09-DEC-16         
  Backup Piece       10     09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_WEEKLY_BACKUP_d4n89gvn_.bkp
Backup Set           11     09-DEC-16         
  Backup Piece       11     09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_WEEKLY_BACKUP_d4n8drs0_.bkp
Backup Set           13     09-DEC-16         
  Backup Piece       13     09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsn0_TAG20161209T113141_d4n9j87n_.bkp
Backup Set           15     09-DEC-16         
  Backup Piece       15     09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsn1_TAG20161209T113421_d4n9lqj6_.bkp
Backup Set           16     09-DEC-16         
  Backup Piece       16     09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T135641_d4nkwsns_.bkp
Datafile Copy        11     09-DEC-16          /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_system_d4nln51m_.dbf
Backup Set           17     09-DEC-16         
  Backup Piece       17     09-DEC-16          /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_TAG20161209T135641_d4nkxmok_.bkp

RMAN> REPORT NEED BACKUP;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN> 

 

目录报告

CATALOG命令帮助表示和编目文件,这儿写文件未在RMAN中记录,因此RMAN并不知道他们。下面的任意事件都可能导致这种情况出现

复原一个备份控制文件
复原一个备用控制文件
重建控制文件
启用DB_RECOVERY_FILE_DEST参数,然后又禁用它

 

列表命令

LIST BACKUP 列出RMAN 注册的所有已经完成的备份。列出所有的备份集和映像集以及备份文件中的单独数据文件、控制文件、归档重做日志文件和SPFILE。也可以通过查询V$BACKUP_FILES和RC_BACKUP_FILES恢复目录视图列出所有备份

RMAN> LIST BACKUP;


List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Full    80.00K     DISK        00:00:01     09-DEC-16      
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T110216
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnsnf_TAG20161209T110216_d4n7tmsz_.bkp
  SPFILE Included: Modification time: 08-DEC-16
  SPFILE db_unique_name: YOON

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Full    1.09G      DISK        00:01:43     09-DEC-16      
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: WEEKLY_BACKUP
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_WEEKLY_BACKUP_d4n89gvn_.bkp
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1441493    09-DEC-16 /u01/app/oracle/oradata/yoon/system01.dbf
  2       Full 1441493    09-DEC-16 /u01/app/oracle/oradata/yoon/sysaux01.dbf
  3       Full 1441493    09-DEC-16 /u01/app/oracle/oradata/yoon/undotbs01.dbf
  4       Full 1441493    09-DEC-16 /u01/app/oracle/oradata/yoon/users01.dbf
  5       Full 1441493    09-DEC-16 /u01/app/oracle/oradata/yoon/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    9.64M      DISK        00:00:02     09-DEC-16      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: WEEKLY_BACKUP
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_WEEKLY_BACKUP_d4n8drs0_.bkp
  SPFILE Included: Modification time: 08-DEC-16
  SPFILE db_unique_name: YOON
  Control File Included: Ckp SCN: 1441612      Ckp time: 09-DEC-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 0  1.09G      DISK        00:01:42     09-DEC-16      
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T113141
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnnd0_TAG20161209T113141_d4n9dyty_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 1443387    09-DEC-16 /u01/app/oracle/oradata/yoon/system01.dbf
  2    0  Incr 1443387    09-DEC-16 /u01/app/oracle/oradata/yoon/sysaux01.dbf
  3    0  Incr 1443387    09-DEC-16 /u01/app/oracle/oradata/yoon/undotbs01.dbf
  4    0  Incr 1443387    09-DEC-16 /u01/app/oracle/oradata/yoon/users01.dbf
  5    0  Incr 1443387    09-DEC-16 /u01/app/oracle/oradata/yoon/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Incr 0  9.64M      DISK        00:00:01     09-DEC-16      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T113141
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsn0_TAG20161209T113141_d4n9j87n_.bkp
  SPFILE Included: Modification time: 08-DEC-16
  SPFILE db_unique_name: YOON
  Control File Included: Ckp SCN: 1443472      Ckp time: 09-DEC-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Incr 1  352.00K    DISK        00:00:15     09-DEC-16      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T113421
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnnd1_TAG20161209T113421_d4n9kxs2_.bkp
  List of Datafiles in backup set 14
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 1443561    09-DEC-16 /u01/app/oracle/oradata/yoon/system01.dbf
  2    1  Incr 1443561    09-DEC-16 /u01/app/oracle/oradata/yoon/sysaux01.dbf
  3    1  Incr 1443561    09-DEC-16 /u01/app/oracle/oradata/yoon/undotbs01.dbf
  4    1  Incr 1443561    09-DEC-16 /u01/app/oracle/oradata/yoon/users01.dbf
  5    1  Incr 1443561    09-DEC-16 /u01/app/oracle/oradata/yoon/example01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Incr 1  9.64M      DISK        00:00:02     09-DEC-16      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T113421
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsn1_TAG20161209T113421_d4n9lqj6_.bkp
  SPFILE Included: Modification time: 08-DEC-16
  SPFILE db_unique_name: YOON
  Control File Included: Ckp SCN: 1443617      Ckp time: 09-DEC-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    596.60M    DISK        00:00:20     09-DEC-16      
        BP Key: 16   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T135641
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnndf_TAG20161209T135641_d4nkwsns_.bkp
  List of Datafiles in backup set 16
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1458913    09-DEC-16 /u01/app/oracle/oradata/yoon/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
17      Full    9.64M      DISK        00:00:02     09-DEC-16      
        BP Key: 17   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T135641
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_ncsnf_TAG20161209T135641_d4nkxmok_.bkp
  SPFILE Included: Modification time: 08-DEC-16
  SPFILE db_unique_name: YOON
  Control File Included: Ckp SCN: 1458987      Ckp time: 09-DEC-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18      Full    80.00K     DISK        00:00:01     09-DEC-16      
        BP Key: 18   Status: AVAILABLE  Compressed: NO  Tag: TAG20161209T140908
        Piece Name: /u01/app/oracle/recovery_area/YOON/backupset/2016_12_09/o1_mf_nnsnf_TAG20161209T140908_d4nlo0x7_.bkp
  SPFILE Included: Modification time: 08-DEC-16
  SPFILE db_unique_name: YOON

RMAN> LIST COPY;

List of Datafile Copies
=======================

Key     File S Completion Time Ckp SCN    Ckp Time       
------- ---- - --------------- ---------- ---------------
13      1    A 09-DEC-16       1460803    09-DEC-16      
        Name: /tmp/test.copy
        Tag: TAG20161209T141120

11      1    A 09-DEC-16       1460490    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_system_d4nln51m_.dbf
        Tag: TAG20161209T140908

10      4    A 09-DEC-16       1440772    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7ym0w_.dbf
        Tag: TAG20161209T110658

9       4    A 09-DEC-16       1440676    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7xwgq_.dbf
        Tag: TAG20161209T110636

8       4    A 09-DEC-16       1440398    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_users_d4n7tllf_.dbf
        Tag: TAG20161209T110216

6       5    A 09-DEC-16       1440358    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/datafile/o1_mf_example_d4n7t08c_.dbf
        Tag: TAG20161209T110216

List of Control File Copies
===========================

Key     S Completion Time Ckp SCN    Ckp Time       
------- - --------------- ---------- ---------------
12      A 09-DEC-16       1460531    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/controlfile/o1_mf_TAG20161209T140908_d4nlnxq6_.ctl
        Tag: TAG20161209T140908

7       A 09-DEC-16       1440394    09-DEC-16      
        Name: /u01/app/oracle/recovery_area/YOON/controlfile/o1_mf_TAG20161209T110216_d4n7thbt_.ctl
        Tag: TAG20161209T110216

2       A 07-DEC-16       1106297    07-DEC-16      
        Name: /u01/app/oracle/oradata/yoon/standby_control01.ctl
        Tag: TAG20161207T101949

List of Archived Log Copies for database with db_unique_name YOON
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
141     1    67      A 07-DEC-16
        Name: /u01/oradata/archive_bak/1_67_929897742.dbf

143     1    68      A 07-DEC-16
        Name: /u01/oradata/archive_bak/1_68_929897742.dbf

145     1    69      A 07-DEC-16
        Name: /u01/oradata/archive_bak/1_69_929897742.dbf

147     1    70      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_70_929897742.dbf

149     1    71      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_71_929897742.dbf

151     1    72      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_72_929897742.dbf

153     1    73      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_73_929897742.dbf

155     1    74      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_74_929897742.dbf

157     1    75      A 09-DEC-16
        Name: /u01/oradata/archive_bak/1_75_929897742.dbf

159     1    76      A 09-DEC-16
        Name: /u01/oradata/archive_bak/1_76_929897742.dbf

RMAN> LIST ARCHIVELOG ALL;

List of Archived Log Copies for database with db_unique_name YOON
=====================================================================

Key     Thrd Seq     S Low Time 
------- ---- ------- - ---------
141     1    67      A 07-DEC-16
        Name: /u01/oradata/archive_bak/1_67_929897742.dbf

143     1    68      A 07-DEC-16
        Name: /u01/oradata/archive_bak/1_68_929897742.dbf

145     1    69      A 07-DEC-16
        Name: /u01/oradata/archive_bak/1_69_929897742.dbf

147     1    70      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_70_929897742.dbf

149     1    71      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_71_929897742.dbf

151     1    72      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_72_929897742.dbf

153     1    73      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_73_929897742.dbf

155     1    74      A 08-DEC-16
        Name: /u01/oradata/archive_bak/1_74_929897742.dbf

157     1    75      A 09-DEC-16
        Name: /u01/oradata/archive_bak/1_75_929897742.dbf

159     1    76      A 09-DEC-16
        Name: /u01/oradata/archive_bak/1_76_929897742.dbf

 

LIST COPY:相当于LIST BACKUP,显示利用RMAN做的所有副本的列表

LIST ARCHIVELOG ALL:命令列出所有可得到的归档日志副本

 

验证命令:

RMAN> VALIDATE BACKUPSET 1;

 

RMAN配置参数

RMAN> SHOW ALL;

RMAN configuration parameters for database with db_unique_name YOON are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F‘; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128‘; # default
CONFIGURE COMPRESSION ALGORITHM ‘BASIC‘ AS OF RELEASE ‘DEFAULT‘ OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_yoon.f‘; # default

 

1 备份保留的策略

备份保留策略指示RMAN合适考虑废弃数据文件和日志文件的备份,请注意,当指定RMAN在一定的时间后考虑废弃某个备份文件时,RMAN只标记该文件为废弃,并不删除它

默认的REDUNDANCY选项和RETENTION WINDOW选项

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored

 如果每天备份数据文件,RMAN只保留每个数据库文件的两个备份,RMAN将保留恢复两天的数据文件备份需要的所有重做日志。任何早于两天的备份被认为是废弃的。

如果希望之星一个PITR到某个比最近备份更早的时间。归档的备份是有用的。如果当前备份不能使用,还有一个备选的备份集可用

RECOVERY WINDOW选项

如果数据库收到介质故障的影响,则从过去的某个时间开始恢复,RMAN保留数据文件和日志文件比恢复时间窗造一个备份的所欲备份,例如,如果恢复时间窗为7天,RMAN将保留7天以前最后做的备份开始的所有备份,如下设置恢复时间窗

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
new RMAN configuration parameters are successfully stored

 

 默认设备类型

备份的默认设备为磁盘,RMAN将自动备份到服务器上文件系统中,如果希望备份到磁盘中,需要配置默认设备类型为sbt(所有磁带目标都为sbt)

SQL>CONFIGURE DEFUALT DEVICE TYPE TO sbt;

 如果希望从默认设备切换到磁盘

SQL>CONFIGURE DEFAULT DEVICE TYPE TO DISK; 

 

备份优化

BACKUP OPTIMIZATION保证。如果RMAN已经备份了某个文件的相同版本,则不会进行该文件的备份。

SQL>CONFIGURE BACKUP OPTIMIZATION ON;

 控制文件参数

有几个设计控制文件备份的参数,

控制文件自动备份

如果将CONFIGURE AUTOBACKUP 设置成ON,则每次进行数据文件备份时,控制文件也与SPFILE一起自动备份。

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

 现在,如果使用任何备份命令,控制文件和SPFILE两者都会自动备份

 RMAN> BACKUP TABLESPACE sysaux;

Starting backup at 13-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_nnndf_TAG20161213T094438_d4ynn80x_.bkp tag=TAG20161213T094438 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/2016_12_13/o1_mf_s_930476744_d4ynp93n_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

 控制文件的备份位置和格式

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/oracle/recovery_area/YOON/autobackup/cf_%F‘;

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/oracle/recovery_area/YOON/autobackup/2016_12_13/cf_%F‘;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘/u01/app/oracle/recovery_area/YOON/autobackup/cf_%F‘;
new RMAN configuration parameters are successfully stored

RMAN> BACKUP TABLESPACE sysaux;

Starting backup at 13-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_nnndf_TAG20161213T102630_d4yq2pz4_.bkp tag=TAG20161213T102630 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-02 comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

 

 创建恢复目录模式

SQL> create temporary tablespace temp02 tempfile ‘/u01/app/oracle/oradata/yoon/temp02.dbf‘ size 10000M;
SQL> create tablespace rman_tbsp   
datafile ‘/u01/app/oracle/oradata/yoon/rman_tbsp.dbf‘   
size 5000M   
autoextend on next 500M maxsize 30000M;
SQL>CREATE USER RMAN IDENTIFIED BY rman 
TEMPORARY TABLESPACE temp02
DEFAULT TABLESPACE rman_tbsp
QUOTA UNLIMITED ON rman_tbsp;
SQL> GRANT RECOVERY_CATALOG_OWNER TO rman;

Grant succeeded.

 连接到RMAN

[oracle@gzxbi01 backupset]{content}nbsp;rman CATALOG rman/rman

Recovery Manager: Release 11.2.0.1.0 - Production on Tue Dec 13 11:13:59 2016

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> 
RMAN> connect target yoon

target database Password: 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01005: null password given; logon denied

RMAN> connect target yoon

target database Password: 
connected to target database: YOON (DBID=781817860)

 创建恢复目录

RMAN> CREATE CATALOG;

recovery catalog created

 删除恢复目录

RMAN> DROP CATALOG;

recovery catalog owner is RMAN
enter DROP CATALOG command again to confirm catalog removal

RMAN> DROP CATALOG;

recovery catalog dropped

 

 注册数据库

为使RMAN完成其工作,需要注册想要备份和恢复

 在恢复目录中注册数据库

RMAN> REGISTER DATABASE;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

 

 检查数据库化身

RMAN> LIST INCARNATION;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
2       23      YOON     781817860        PARENT  1          15-AUG-09
2       4       YOON     781817860        CURRENT 945184     06-DEC-16

 

在每次执行备份或恢复时,BACKUP和COPY命令将自动执行重新同步,但是有两种情况,可能需要手动同步,目标数据库刚尽心改了许多物理备份,以及目标数据库在备份之间进行了大量的日志交换

RMAN> RESYNC CATALOG;

starting full resync of recovery catalog
full resync complete

 

 RMAN备份的例子

RMAN> BACKUP DATABASE;

Starting backup at 13-DEC-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=139 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/yoon/rman_tbsp.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_nnndf_TAG20161213T113851_d4yvbdng_.bkp tag=TAG20161213T113851 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:55
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-04 comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

 

 备份归档日志,将所有数据文件及任意归档重做日志文件

 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Starting backup at 13-DEC-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=67 RECID=141 STAMP=930002431
input archived log thread=1 sequence=68 RECID=143 STAMP=930003123
input archived log thread=1 sequence=69 RECID=145 STAMP=930016837
input archived log thread=1 sequence=70 RECID=147 STAMP=930038442
input archived log thread=1 sequence=71 RECID=149 STAMP=930060057
input archived log thread=1 sequence=72 RECID=151 STAMP=930078067
input archived log thread=1 sequence=73 RECID=153 STAMP=930088842
input archived log thread=1 sequence=74 RECID=155 STAMP=930099902
input archived log thread=1 sequence=75 RECID=157 STAMP=930121228
input archived log thread=1 sequence=76 RECID=159 STAMP=930142615
input archived log thread=1 sequence=77 RECID=161 STAMP=930160254
input archived log thread=1 sequence=78 RECID=163 STAMP=930175228
input archived log thread=1 sequence=79 RECID=165 STAMP=930182421
input archived log thread=1 sequence=80 RECID=167 STAMP=930203266
input archived log thread=1 sequence=81 RECID=169 STAMP=930211579
input archived log thread=1 sequence=82 RECID=171 STAMP=930225529
input archived log thread=1 sequence=83 RECID=173 STAMP=930236428
input archived log thread=1 sequence=84 RECID=175 STAMP=930248459
input archived log thread=1 sequence=85 RECID=177 STAMP=930262535
input archived log thread=1 sequence=86 RECID=179 STAMP=930279663
input archived log thread=1 sequence=87 RECID=181 STAMP=930290431
input archived log thread=1 sequence=88 RECID=183 STAMP=930305189
input archived log thread=1 sequence=89 RECID=185 STAMP=930320950
input archived log thread=1 sequence=90 RECID=187 STAMP=930334014
input archived log thread=1 sequence=91 RECID=189 STAMP=930348429
input archived log thread=1 sequence=92 RECID=191 STAMP=930364903
input archived log thread=1 sequence=93 RECID=193 STAMP=930385632
input archived log thread=1 sequence=94 RECID=195 STAMP=930406626
input archived log thread=1 sequence=95 RECID=197 STAMP=930424789
input archived log thread=1 sequence=96 RECID=199 STAMP=930434440
input archived log thread=1 sequence=97 RECID=201 STAMP=930448841
input archived log thread=1 sequence=98 RECID=203 STAMP=930469306
input archived log thread=1 sequence=99 RECID=205 STAMP=930482166
input archived log thread=1 sequence=100 RECID=207 STAMP=930482728
input archived log thread=1 sequence=101 RECID=209 STAMP=930483779
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_annnn_TAG20161213T114259_d4yvl4gn_.bkp tag=TAG20161213T114259 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:05
Finished backup at 13-DEC-16

Starting backup at 13-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/yoon/rman_tbsp.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_nnndf_TAG20161213T114505_d4yvp467_.bkp tag=TAG20161213T114505 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:56
Finished backup at 13-DEC-16

Starting backup at 13-DEC-16
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=102 RECID=211 STAMP=930484028
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_annnn_TAG20161213T114709_d4yvsx85_.bkp tag=TAG20161213T114709 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-05 comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

 

 用脚本执行联机备份

SQL>RUN{
ALLOCATE CHANNEL d1 TYPE DISK;
ALLOCATE CHANNEL d2 TYPE DISK;
ALLOCATE CHANNEL d3 TYPE DISK;
BACKUP TAG whole_database_open FORMAT ‘/u01/app/oracle/recovery_area/backups/db_%t_%s_p%p‘ DATABASE;
SQL ‘alter system archive log current‘;
BACKUP ARCHIVELOG ALL FORMAT ‘/u01/app/oracle/recovery_area/backups/al_%t_%s_p%p‘;
BACKUP CURRENT CONTROLFILE TAG = cf1 FORMAT ‘/u01/app/oracle/recovery_area/backups/cf_%t_%s_p%p‘;
RELEASE channel d1;
RELEASE channel d2;
RELEASE channel d3;
}

allocated channel: d1
channel d1: SID=13 device type=DISK

allocated channel: d2
channel d2: SID=76 device type=DISK

allocated channel: d3
channel d3: SID=137 device type=DISK

Starting backup at 13-DEC-16
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/yoon/rman_tbsp.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel d1: starting piece 1 at 13-DEC-16
channel d2: starting full datafile backup set
channel d2: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/yoon/example01.dbf
channel d2: starting piece 1 at 13-DEC-16
channel d3: starting full datafile backup set
channel d3: specifying datafile(s) in backup set
input datafile file number=00002 name=/u01/app/oracle/oradata/yoon/sysaux01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/yoon/undotbs01.dbf
channel d3: starting piece 1 at 13-DEC-16
channel d1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/db_930494182_54_p1 tag=WHOLE_DATABASE_OPEN comment=NONE
channel d1: backup set complete, elapsed time: 00:00:04
channel d2: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/db_930494182_55_p1 tag=WHOLE_DATABASE_OPEN comment=NONE
channel d2: backup set complete, elapsed time: 00:01:46
channel d3: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/db_930494183_56_p1 tag=WHOLE_DATABASE_OPEN comment=NONE
channel d3: backup set complete, elapsed time: 00:01:45
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-08 comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

sql statement: alter system archive log current

Starting backup at 13-DEC-16
current log archived
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=67 RECID=141 STAMP=930002431
input archived log thread=1 sequence=68 RECID=143 STAMP=930003123
input archived log thread=1 sequence=69 RECID=145 STAMP=930016837
input archived log thread=1 sequence=70 RECID=147 STAMP=930038442
input archived log thread=1 sequence=71 RECID=149 STAMP=930060057
input archived log thread=1 sequence=72 RECID=151 STAMP=930078067
input archived log thread=1 sequence=73 RECID=153 STAMP=930088842
input archived log thread=1 sequence=74 RECID=155 STAMP=930099902
input archived log thread=1 sequence=75 RECID=157 STAMP=930121228
input archived log thread=1 sequence=76 RECID=159 STAMP=930142615
input archived log thread=1 sequence=77 RECID=161 STAMP=930160254
input archived log thread=1 sequence=78 RECID=163 STAMP=930175228
channel d1: starting piece 1 at 13-DEC-16
channel d2: starting archived log backup set
channel d2: specifying archived log(s) in backup set
input archived log thread=1 sequence=79 RECID=165 STAMP=930182421
input archived log thread=1 sequence=80 RECID=167 STAMP=930203266
input archived log thread=1 sequence=81 RECID=169 STAMP=930211579
input archived log thread=1 sequence=82 RECID=171 STAMP=930225529
input archived log thread=1 sequence=83 RECID=173 STAMP=930236428
input archived log thread=1 sequence=84 RECID=175 STAMP=930248459
input archived log thread=1 sequence=85 RECID=177 STAMP=930262535
input archived log thread=1 sequence=86 RECID=179 STAMP=930279663
input archived log thread=1 sequence=87 RECID=181 STAMP=930290431
input archived log thread=1 sequence=88 RECID=183 STAMP=930305189
input archived log thread=1 sequence=89 RECID=185 STAMP=930320950
input archived log thread=1 sequence=90 RECID=187 STAMP=930334014
channel d2: starting piece 1 at 13-DEC-16
channel d3: starting archived log backup set
channel d3: specifying archived log(s) in backup set
input archived log thread=1 sequence=91 RECID=189 STAMP=930348429
input archived log thread=1 sequence=92 RECID=191 STAMP=930364903
input archived log thread=1 sequence=93 RECID=193 STAMP=930385632
input archived log thread=1 sequence=94 RECID=195 STAMP=930406626
input archived log thread=1 sequence=95 RECID=197 STAMP=930424789
input archived log thread=1 sequence=96 RECID=199 STAMP=930434440
input archived log thread=1 sequence=97 RECID=201 STAMP=930448841
input archived log thread=1 sequence=98 RECID=203 STAMP=930469306
input archived log thread=1 sequence=99 RECID=205 STAMP=930482166
input archived log thread=1 sequence=100 RECID=207 STAMP=930482728
input archived log thread=1 sequence=101 RECID=209 STAMP=930483779
input archived log thread=1 sequence=102 RECID=211 STAMP=930484028
input archived log thread=1 sequence=103 RECID=213 STAMP=930493890
input archived log thread=1 sequence=104 RECID=215 STAMP=930493896
channel d3: starting piece 1 at 13-DEC-16
channel d1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/al_930494306_58_p1 tag=TAG20161213T143826 comment=NONE
channel d1: backup set complete, elapsed time: 00:02:16
channel d1: starting archived log backup set
channel d1: specifying archived log(s) in backup set
input archived log thread=1 sequence=105 RECID=217 STAMP=930494299
input archived log thread=1 sequence=106 RECID=219 STAMP=930494305
channel d1: starting piece 1 at 13-DEC-16
channel d2: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/al_930494306_59_p1 tag=TAG20161213T143826 comment=NONE
channel d2: backup set complete, elapsed time: 00:02:16
channel d3: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/al_930494307_60_p1 tag=TAG20161213T143826 comment=NONE
channel d3: backup set complete, elapsed time: 00:02:15
channel d1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/al_930494442_61_p1 tag=TAG20161213T143826 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-DEC-16

Starting backup at 13-DEC-16
channel d1: starting full datafile backup set
channel d1: specifying datafile(s) in backup set
including current control file in backup set
channel d1: starting piece 1 at 13-DEC-16
channel d1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/backups/cf_930494444_62_p1 tag=CF1 comment=NONE
channel d1: backup set complete, elapsed time: 00:00:03
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-09 comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

released channel: d1

released channel: d2

released channel: d3

 

 备份控制文件

RMAN> BACKUP CURRENT CONTROLFILE;

Starting backup at 13-DEC-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=13 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_ncnnf_TAG20161213T144453_d4z676f5_.bkp tag=TAG20161213T144453 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-0a comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

 

 备份表空间

RMAN> BACKUP TABLESPACE USERS;

Starting backup at 13-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/app/oracle/oradata/yoon/users01.dbf
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_nnndf_TAG20161213T144643_d4z6bmlx_.bkp tag=TAG20161213T144643 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-0b comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

 

备份数据文件

RMAN> BACKUP DATAFILE ‘/u01/app/oracle/oradata/yoon/system01.dbf‘;

Starting backup at 13-DEC-16
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/yoon/system01.dbf
channel ORA_DISK_1: starting piece 1 at 13-DEC-16
channel ORA_DISK_1: finished piece 1 at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/backupset/2016_12_13/o1_mf_nnndf_TAG20161213T144748_d4z6dnv2_.bkp tag=TAG20161213T144748 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
Finished backup at 13-DEC-16

Starting Control File and SPFILE Autobackup at 13-DEC-16
piece handle=/u01/app/oracle/recovery_area/YOON/autobackup/cf_c-781817860-20161213-0c comment=NONE
Finished Control File and SPFILE Autobackup at 13-DEC-16

Oracle 11g 中恢复管理器RMAN介绍