建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
Oracle12cRMAN功能增強
數(shù)據(jù)庫版本
我們提供的服務(wù)有：成都網(wǎng)站建設(shè)、成都網(wǎng)站制作、微信公眾號開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、七星ssl等。為近千家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的七星網(wǎng)站制作公司
- 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分割數(shù)據(jù)文件增強
- 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備份方式)方式支持?jǐn)?shù)據(jù)文件分割備份功能,對于11.2之前的版本均不支持該功能.在12C中rman可以支持對于全備,增量備份,copy備份全部支持分割數(shù)據(jù)文件備份(CONTROLFILE,SPFILE不支持)。
當(dāng)前題目：Oracle12cRMAN功能增強
網(wǎng)站URL：http://www.dlmjj.cn/article/coejhco.html
