在ORACLE 12C中对rman的功能有了不少增强,在以前的文章中写过RMAN RECOVER TABLE功能,这里另外补充rman增强的两个小功能(sql语句和数据文件分割)
数据库版本
SQL>
select
*
from
v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle
Database
12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production 0
PL/SQL Release 12.1.0.1.0 - Production 0
CORE 12.1.0.1.0 Production 0
TNS
for
Linux: Version 12.1.0.1.0 - Production 0
NLSRTL Version 12.1.0.1.0 - Production 0
|
rman对sql语句支持增强
[oracle@xifenfei tmp]$ rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Sat Jun 1 14:07:50 2013
Copyright (c) 1982, 2013, Oracle and
/or
its affiliates. All rights reserved.
connected to target database: CDB (DBID=1922813718)
RMAN>
select
sysdate from dual;
using target database control
file
instead of recovery catalog
SYSDATE
---------
01-JUN-13
RMAN> alter session
set
nls_date_format=
'yyyy-mm-dd hh24:mi:ss'
;
Statement processed
RMAN>
select
sysdate from dual;
SYSDATE
-------------------
2013-06-01 14:16:48
RMAN> desc
v
$log
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP
# NUMBER
THREAD
# NUMBER
SEQUENCE
# NUMBER
BYTES NUMBER
BLOCKSIZE NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE
# NUMBER
FIRST_TIME DATE
NEXT_CHANGE
# NUMBER
NEXT_TIME DATE
CON_ID NUMBER
|
这里看到rman只是sql语句中的select和desc用法
rman分割数据文件增强
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored
RMAN> backup incremental level 1 section size 30M datafile 1
format
'/tmp/system_%U.rman'
;
Starting backup at 01-JUN-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 device
type
=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=269 device
type
=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=24 device
type
=DISK
no parent backup or copy of datafile 1 found
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=+DATA
/cdb/system01
.dbf
backing up blocks 1 through 3840
channel ORA_DISK_1: starting piece 1 at 01-JUN-13
channel ORA_DISK_2: starting incremental level 1 datafile backup
set
channel ORA_DISK_2: specifying datafile(s)
in
backup
set
input datafile
file
number=00001 name=+DATA
/cdb/system01
.dbf
……………………
backing up blocks 96001 through 99840
channel ORA_DISK_3: starting piece 26 at 01-JUN-13
channel ORA_DISK_1: finished piece 24 at 01-JUN-13
piece handle=
/tmp/system_02ob3pg1_24_1
.rman tag=TAG20130601T144518 comment=NONE
channel ORA_DISK_1: backup
set
complete, elapsed
time
: 00:00:08
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=+DATA
/cdb/system01
.dbf
backing up blocks 99841 through 101120
channel ORA_DISK_1: starting piece 27 at 01-JUN-13
channel ORA_DISK_2: finished piece 25 at 01-JUN-13
piece handle=
/tmp/system_02ob3pg1_25_1
.rman tag=TAG20130601T144518 comment=NONE
channel ORA_DISK_2: backup
set
complete, elapsed
time
: 00:00:07
channel ORA_DISK_3: finished piece 26 at 01-JUN-13
piece handle=
/tmp/system_02ob3pg1_26_1
.rman tag=TAG20130601T144518 comment=NONE
channel ORA_DISK_3: backup
set
complete, elapsed
time
: 00:00:06
channel ORA_DISK_1: finished piece 27 at 01-JUN-13
piece handle=
/tmp/system_02ob3pg1_27_1
.rman tag=TAG20130601T144518 comment=NONE
channel ORA_DISK_1: backup
set
complete, elapsed
time
: 00:00:07
Finished backup at 01-JUN-13
|
备份文件情况
[oracle@xifenfei tmp]$ ll -ltr system*
-rw-r----- 1 oracle dba 14761984 Jun 1 14:45 system_02ob3pg1_1_1.rman
-rw-r----- 1 oracle dba 9535488 Jun 1 14:45 system_02ob3pg1_2_1.rman
-rw-r----- 1 oracle dba 16973824 Jun 1 14:45 system_02ob3pg1_4_1.rman
-rw-r----- 1 oracle dba 18284544 Jun 1 14:45 system_02ob3pg1_3_1.rman
-rw-r----- 1 oracle dba 12804096 Jun 1 14:45 system_02ob3pg1_5_1.rman
-rw-r----- 1 oracle dba 29163520 Jun 1 14:45 system_02ob3pg1_6_1.rman
-rw-r----- 1 oracle dba 31326208 Jun 1 14:46 system_02ob3pg1_7_1.rman
-rw-r----- 1 oracle dba 30851072 Jun 1 14:46 system_02ob3pg1_8_1.rman
-rw-r----- 1 oracle dba 30801920 Jun 1 14:46 system_02ob3pg1_9_1.rman
-rw-r----- 1 oracle dba 23977984 Jun 1 14:46 system_02ob3pg1_11_1.rman
-rw-r----- 1 oracle dba 28508160 Jun 1 14:46 system_02ob3pg1_10_1.rman
-rw-r----- 1 oracle dba 30277632 Jun 1 14:46 system_02ob3pg1_12_1.rman
-rw-r----- 1 oracle dba 31498240 Jun 1 14:46 system_02ob3pg1_13_1.rman
-rw-r----- 1 oracle dba 31498240 Jun 1 14:47 system_02ob3pg1_14_1.rman
-rw-r----- 1 oracle dba 31498240 Jun 1 14:47 system_02ob3pg1_15_1.rman
-rw-r----- 1 oracle dba 30507008 Jun 1 14:47 system_02ob3pg1_17_1.rman
-rw-r----- 1 oracle dba 30834688 Jun 1 14:47 system_02ob3pg1_16_1.rman
-rw-r----- 1 oracle dba 31498240 Jun 1 14:47 system_02ob3pg1_18_1.rman
-rw-r----- 1 oracle dba 30244864 Jun 1 14:47 system_02ob3pg1_19_1.rman
-rw-r----- 1 oracle dba 29016064 Jun 1 14:47 system_02ob3pg1_20_1.rman
-rw-r----- 1 oracle dba 29212672 Jun 1 14:47 system_02ob3pg1_21_1.rman
-rw-r----- 1 oracle dba 30728192 Jun 1 14:47 system_02ob3pg1_22_1.rman
-rw-r----- 1 oracle dba 29384704 Jun 1 14:47 system_02ob3pg1_23_1.rman
-rw-r----- 1 oracle dba 26566656 Jun 1 14:47 system_02ob3pg1_24_1.rman
-rw-r----- 1 oracle dba 24928256 Jun 1 14:48 system_02ob3pg1_25_1.rman
-rw-r----- 1 oracle dba 19324928 Jun 1 14:48 system_02ob3pg1_26_1.rman
-rw-r----- 1 oracle dba 6291456 Jun 1 14:48 system_02ob3pg1_27_1.rman
|
在12C之前的版本,ORACLE 11GR2只是对于全备的备份集备份(非增量,非copy备份方式)方式支持数据文件分割备份功能,对于11.2之前的版本均不支持该功能.在12C中rman可以支持对于全备,增量备份,copy备份全部支持分割数据文件备份(CONTROLFILE,SPFILE不支持)
转:http://www.xifenfei.com/2013/06/oracle-12c-rman-%e5%8a%9f%e8%83%bd%e5%a2%9e%e5%bc%ba.html
文章可以转载,必须以链接形式标明出处。
本文转自 张冲andy 博客园博客,原文链接:http://www.cnblogs.com/andy6/p/5898085.html
,如需转载请自行联系原作者