[20171031]rman merge例子2.txt
--//以前做的测试 [20170626]rman merge例子.txt
--//链接 http://blog.itpub.net/267265/viewspace-2141253/
--//不断应用日志,常用的方式如下:
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格式.而如果采用如下方式执行:
RUN
{
backup incremental level 1 for recover of copy with tag 'incr_update' database format '/home/oracle/backup/%b';
recover copy of database with tag 'incr_update' ;
}
--//可以发现这样不行.指定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-00571: ===========================================================
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
channel ORA_DISK_1: starting datafile copy
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
channel ORA_DISK_2: starting datafile copy
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
channel ORA_DISK_3: starting datafile copy
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备份.再执行如下就没有任何问题.
RUN
{
backup incremental level 1 for recover of copy with tag 'incr_update' database ;
recover copy of database with tag 'incr_update' ;
}
Starting backup at 2017-10-31 09:55:50
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
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=00002 name=/mnt/ramdisk/book/sysaux01.dbf
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
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
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
input datafile file number=00006 name=/mnt/ramdisk/book/tea01.dbf
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
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
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
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
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';
