[20171031]rman merge例子2.txt

[20171031]rman merge例子2.txt

--//以前做的測試 [20170626]rman merge例子.txt

--//不斷應用日志,常用的方式如下:

1.環境:

SCOTT@book> @ &r/ver1

PORT_STRING                    VERSION        BANNER

------------------------------ -------------- --------------------------------------------------------------------------------

x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

RUN

{

backup incremental level 1 for recover of copy with tag 'incr_update' database ;

recover copy of database with tag 'incr_update' ;

}

--//但這樣資料檔案建立在閃回區,采用OMF格式.而如果采用如下方式執行:

backup incremental level 1 for recover of copy with tag 'incr_update' database format '/home/oracle/backup/%b';

--//可以發現這樣不行.指定format無效.雖然以上腳本一直可以應用,主要是檔案名采用OMF格式.資料檔案放在閃回區.

--//實際上主要問題這樣的方式不支援%b的格式,因為這樣實際上level 0不存在,第一次實際實際上做level 0 as copy備份.

--//如果寫成 backup incremental level 0 for recover of copy with tag 'incr_update' database format '/home/oracle/backup/%b';

--//會出現如下提示:

RMAN> backup incremental level 0 for recover of copy with tag 'incr_update' database format '/home/oracle/backup/%b';

Starting backup at 2017-10-31 09:42:14

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-03002: failure of backup command at 10/31/2017 09:42:14

RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF

--//我前面采用如下方式,先備份成datafilecopy檔案.然後注冊為增量備份.就ok了,看下面的測試.

RMAN> backup as copy  database format '/home/oracle/backup/%b' tag 'incr_update';

RMAN> catalog datafilecopy '/home/oracle/backup/system01.dbf' level 0 ;

cataloged datafile copy

datafile copy file name=/home/oracle/backup/system01.dbf RECID=43 STAMP=947675261

catalog datafilecopy '/home/oracle/backup/sysaux01.dbf' level 0 ;

catalog datafilecopy '/home/oracle/backup/example01.dbf' level 0 ;

catalog datafilecopy '/home/oracle/backup/undotbs01.dbf' level 0 ;

catalog datafilecopy '/home/oracle/backup/users01.dbf' level 0 ;

catalog datafilecopy '/home/oracle/backup/tea01.dbf' level 0 ;

--//實際上建立datacopyfile可以一步搞定.執行如下:(注:12c 使用PDB可能存在問題!!)

RMAN> backup as copy  incremental level 0 database format '/home/oracle/backup/%b' tag 'incr_update';

Starting backup at 2017-10-31 09:45:58

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=224 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=237 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=248 device type=DISK

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf

channel ORA_DISK_2: starting datafile copy

input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf

channel ORA_DISK_3: starting datafile copy

input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf

output file name=/home/oracle/backup/sysaux01.dbf tag=INCR_UPDATE RECID=15 STAMP=958815971

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15

input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf

output file name=/home/oracle/backup/undotbs01.dbf tag=INCR_UPDATE RECID=14 STAMP=958815971

channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:15

input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf

output file name=/home/oracle/backup/system01.dbf tag=INCR_UPDATE RECID=13 STAMP=958815971

channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:15

input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf

output file name=/home/oracle/backup/example01.dbf tag=INCR_UPDATE RECID=18 STAMP=958815976

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01

output file name=/home/oracle/backup/users01.dbf tag=INCR_UPDATE RECID=17 STAMP=958815975

channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:01

output file name=/home/oracle/backup/tea01.dbf tag=INCR_UPDATE RECID=16 STAMP=958815975

channel ORA_DISK_3: datafile copy complete, elapsed time: 00:00:01

Finished backup at 2017-10-31 09:46:16

Starting Control File and SPFILE Autobackup at 2017-10-31 09:46:16

piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_10_31/o1_mf_s_958815976_dzhoh8nx_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2017-10-31 09:46:17

$ ls -l /home/oracle/backup/*.dbf */

-rw-r----- 1 oracle oinstall 363077632 2017-10-31 09:46:16 /home/oracle/backup/example01.dbf

-rw-r----- 1 oracle oinstall 985669632 2017-10-31 09:46:03 /home/oracle/backup/sysaux01.dbf

-rw-r----- 1 oracle oinstall 796925952 2017-10-31 09:46:03 /home/oracle/backup/system01.dbf

-rw-r----- 1 oracle oinstall  41951232 2017-10-31 09:46:15 /home/oracle/backup/tea01.dbf

-rw-r----- 1 oracle oinstall 907026432 2017-10-31 09:46:03 /home/oracle/backup/undotbs01.dbf

-rw-r----- 1 oracle oinstall 134225920 2017-10-31 09:46:15 /home/oracle/backup/users01.dbf

--//這樣就建立datacopy的level=0備份.再執行如下就沒有任何問題.

Starting backup at 2017-10-31 09:55:50

channel ORA_DISK_1: starting incremental level 1 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

channel ORA_DISK_1: starting piece 1 at 2017-10-31 09:55:50

channel ORA_DISK_2: starting incremental level 1 datafile backup set

channel ORA_DISK_2: specifying datafile(s) in backup set

channel ORA_DISK_2: starting piece 1 at 2017-10-31 09:55:50

channel ORA_DISK_3: starting incremental level 1 datafile backup set

channel ORA_DISK_3: specifying datafile(s) in backup set

channel ORA_DISK_3: starting piece 1 at 2017-10-31 09:55:50

channel ORA_DISK_1: finished piece 1 at 2017-10-31 09:55:51

piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hk_.bkp tag=INCR_UPDATE comment=NONE

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

channel ORA_DISK_2: finished piece 1 at 2017-10-31 09:55:51

piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hp_.bkp tag=INCR_UPDATE comment=NONE

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

channel ORA_DISK_3: finished piece 1 at 2017-10-31 09:55:51

piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hw_.bkp tag=INCR_UPDATE comment=NONE

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

Finished backup at 2017-10-31 09:55:51

Starting recover at 2017-10-31 09:55:51

channel ORA_DISK_1: starting incremental datafile backup set restore

channel ORA_DISK_1: specifying datafile copies to recover

recovering datafile copy file number=00001 name=/home/oracle/backup/system01.dbf

recovering datafile copy file number=00004 name=/home/oracle/backup/users01.dbf

channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hw_.bkp

channel ORA_DISK_2: starting incremental datafile backup set restore

channel ORA_DISK_2: specifying datafile copies to recover

recovering datafile copy file number=00003 name=/home/oracle/backup/undotbs01.dbf

recovering datafile copy file number=00006 name=/home/oracle/backup/tea01.dbf

channel ORA_DISK_2: reading from backup piece /u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hp_.bkp

channel ORA_DISK_3: starting incremental datafile backup set restore

channel ORA_DISK_3: specifying datafile copies to recover

recovering datafile copy file number=00002 name=/home/oracle/backup/sysaux01.dbf

recovering datafile copy file number=00005 name=/home/oracle/backup/example01.dbf

channel ORA_DISK_3: reading from backup piece /u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hk_.bkp

channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hw_.bkp tag=INCR_UPDATE

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:00

channel ORA_DISK_2: piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hp_.bkp tag=INCR_UPDATE

channel ORA_DISK_2: restored backup piece 1

channel ORA_DISK_2: restore complete, elapsed time: 00:00:01

channel ORA_DISK_3: piece handle=/u01/app/oracle/fast_recovery_area/BOOK/backupset/2017_10_31/o1_mf_nnnd1_INCR_UPDATE_dzhp16hk_.bkp tag=INCR_UPDATE

channel ORA_DISK_3: restored backup piece 1

channel ORA_DISK_3: restore complete, elapsed time: 00:00:01

Finished recover at 2017-10-31 09:55:52

Starting Control File and SPFILE Autobackup at 2017-10-31 09:55:52

piece handle=/u01/app/oracle/fast_recovery_area/BOOK/autobackup/2017_10_31/o1_mf_s_958816552_dzhp1827_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2017-10-31 09:55:53

--//這樣也是可以,使用format參數.

RMAN> backup incremental level 1 for recover of copy with tag 'incr_update' database format '/home/oracle/backup/inc_%U';

RMAN> recover copy of database with tag 'incr_update' ;

--//總結:

--//寫這麼多實際上就是說明.建立datacopy的level=0備份,可以執行如下:

backup as copy  incremental level 0 database format '/home/oracle/backup/%b' tag 'incr_update';