I am planning to backup my 12R2 container database, because a huge application change is coming up,
\nand I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I want to do it with a cold backup in combination with RMAN tags. Unfortunately I don’t have any backups at the moment, so I start with a full backup with the TAG ‘DBI_BACKUP’ to be 100% that I restore the correct one.<\/p>\n
RMAN> list backup summary;\n\nspecification does not match any backup in the repository\n\nRMAN> shutdown immediate\n\ndatabase closed\ndatabase dismounted\nOracle instance shut down\n\nRMAN> startup mount\n\nconnected to target database (not started)\nOracle instance started\ndatabase mounted\n\nTotal System Global Area 1795162112 bytes\n\nFixed Size 8793832 bytes\nVariable Size 553648408 bytes\nDatabase Buffers 1224736768 bytes\nRedo Buffers 7983104 bytes\n\nRMAN> run\n {\n allocate channel c1 device type disk format '\/u99\/backup\/CDB\/database_%U';\n allocate channel c2 device type disk format '\/u99\/backup\/CDB\/database_%U';\n allocate channel c3 device type disk format '\/u99\/backup\/CDB\/database_%U';\n allocate channel c4 device type disk format '\/u99\/backup\/CDB\/database_%U';\n BACKUP INCREMENTAL LEVEL 0 FORCE AS COMPRESSED BACKUPSET DATABASE plus archivelog tag 'DBI_BACKUP';\n backup current controlfile tag 'DBI_BACKUP' format '\/u99\/backup\/CDB\/control_%U';\n backup spfile tag 'DBI_BACKUP' format '\/u99\/backup\/CDB\/spfile_%U';\n release channel c1;\n release channel c2;\n release channel c3;\n release channel c4;\n }2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>\n\nallocated channel: c1\nchannel c1: SID=16 device type=DISK\n\nallocated channel: c2\nchannel c2: SID=271 device type=DISK\n\nallocated channel: c3\nchannel c3: SID=31 device type=DISK\n\nallocated channel: c4\nchannel c4: SID=272 device type=DISK\n\n\nStarting backup at 26-JAN-2017 13:18:53\ncurrent log archived\nchannel c1: starting compressed archived log backup set\nchannel c1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=4 RECID=3 STAMP=934074668\ninput archived log thread=1 sequence=5 RECID=4 STAMP=934154679\nchannel c1: starting piece 1 at 26-JAN-2017 13:18:53\nchannel c2: starting compressed archived log backup set\nchannel c2: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=2 RECID=1 STAMP=934038010\ninput archived log thread=1 sequence=3 RECID=2 STAMP=934066843\nchannel c2: starting piece 1 at 26-JAN-2017 13:18:53\nchannel c3: starting compressed archived log backup set\nchannel c3: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=6 RECID=5 STAMP=934203623\ninput archived log thread=1 sequence=7 RECID=6 STAMP=934275778\ninput archived log thread=1 sequence=8 RECID=7 STAMP=934284094\nchannel c3: starting piece 1 at 26-JAN-2017 13:18:53\nchannel c4: starting compressed archived log backup set\nchannel c4: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=9 RECID=8 STAMP=934284153\ninput archived log thread=1 sequence=10 RECID=9 STAMP=934284199\ninput archived log thread=1 sequence=11 RECID=10 STAMP=934291133\nchannel c4: starting piece 1 at 26-JAN-2017 13:18:53\nchannel c4: finished piece 1 at 26-JAN-2017 13:18:54\npiece handle=\/u99\/backup\/CDB\/database_2arr09lt_1_1 tag=DBI_BACKUP comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:01\nchannel c1: finished piece 1 at 26-JAN-2017 13:19:08\npiece handle=\/u99\/backup\/CDB\/database_27rr09lt_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:15\nchannel c2: finished piece 1 at 26-JAN-2017 13:19:08\npiece handle=\/u99\/backup\/CDB\/database_28rr09lt_1_1 tag=DBI_BACKUP comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:15\nchannel c3: finished piece 1 at 26-JAN-2017 13:19:08\npiece handle=\/u99\/backup\/CDB\/database_29rr09lt_1_1 tag=DBI_BACKUP comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:15\nFinished backup at 26-JAN-2017 13:19:08\n\nStarting backup at 26-JAN-2017 13:19:08\nchannel c1: starting compressed incremental level 0 datafile backup set\nchannel c1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_system_d81c2wsf_.dbf\nchannel c1: starting piece 1 at 26-JAN-2017 13:19:09\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00003 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_sysaux_d81c49wd_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:19:09\nchannel c3: starting compressed incremental level 0 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00010 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_sysaux_d81cgjc2_.dbf\nchannel c3: starting piece 1 at 26-JAN-2017 13:19:09\nchannel c4: starting compressed incremental level 0 datafile backup set\nchannel c4: specifying datafile(s) in backup set\ninput datafile file number=00009 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_system_d81cgjbv_.dbf\ninput datafile file number=00011 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_undotbs1_d81cgjc2_.dbf\nchannel c4: starting piece 1 at 26-JAN-2017 13:19:09\nchannel c4: finished piece 1 at 26-JAN-2017 13:19:24\npiece handle=\/u99\/backup\/CDB\/database_2err09md_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:15\nchannel c4: starting compressed incremental level 0 datafile backup set\nchannel c4: specifying datafile(s) in backup set\ninput datafile file number=00006 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_sysaux_d81c6fqn_.dbf\nchannel c4: starting piece 1 at 26-JAN-2017 13:19:24\nchannel c3: finished piece 1 at 26-JAN-2017 13:19:39\npiece handle=\/u99\/backup\/CDB\/database_2drr09md_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:30\nchannel c3: starting compressed incremental level 0 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00013 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_rman_d8ccofgs_.dbf\ninput datafile file number=00012 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_users_d81cgq9f_.dbf\nchannel c3: starting piece 1 at 26-JAN-2017 13:19:39\nchannel c3: finished piece 1 at 26-JAN-2017 13:19:40\npiece handle=\/u99\/backup\/CDB\/database_2grr09nb_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:01\nchannel c3: starting compressed incremental level 0 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00005 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_system_d81c6fqo_.dbf\nchannel c3: starting piece 1 at 26-JAN-2017 13:19:41\nchannel c2: finished piece 1 at 26-JAN-2017 13:19:41\npiece handle=\/u99\/backup\/CDB\/database_2crr09md_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:32\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00008 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_undotbs1_d81c6fqp_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:19:41\nchannel c2: finished piece 1 at 26-JAN-2017 13:19:44\npiece handle=\/u99\/backup\/CDB\/database_2irr09nd_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:03\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00004 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_undotbs1_d81c530h_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:19:44\nchannel c2: finished piece 1 at 26-JAN-2017 13:19:45\npiece handle=\/u99\/backup\/CDB\/database_2jrr09ng_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:01\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00007 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_users_d81c542r_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:19:45\nchannel c2: finished piece 1 at 26-JAN-2017 13:19:46\npiece handle=\/u99\/backup\/CDB\/database_2krr09nh_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:01\nchannel c1: finished piece 1 at 26-JAN-2017 13:19:52\npiece handle=\/u99\/backup\/CDB\/database_2brr09md_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:43\nchannel c3: finished piece 1 at 26-JAN-2017 13:19:52\npiece handle=\/u99\/backup\/CDB\/database_2hrr09nd_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:11\nchannel c4: finished piece 1 at 26-JAN-2017 13:19:52\npiece handle=\/u99\/backup\/CDB\/database_2frr09ms_1_1 tag=TAG20170126T131908 comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:28\nFinished backup at 26-JAN-2017 13:19:52\n\nStarting backup at 26-JAN-2017 13:19:52\ncurrent log archived\nchannel c1: starting compressed archived log backup set\nchannel c1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=12 RECID=11 STAMP=934291192\nchannel c1: starting piece 1 at 26-JAN-2017 13:19:53\nchannel c1: finished piece 1 at 26-JAN-2017 13:19:54\npiece handle=\/u99\/backup\/CDB\/database_2lrr09np_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:01\nFinished backup at 26-JAN-2017 13:19:54\n\nStarting backup at 26-JAN-2017 13:19:54\nchannel c1: starting full datafile backup set\nchannel c1: specifying datafile(s) in backup set\nincluding current control file in backup set\nchannel c1: starting piece 1 at 26-JAN-2017 13:19:55\nchannel c1: finished piece 1 at 26-JAN-2017 13:19:56\npiece handle=\/u99\/backup\/CDB\/control_2mrr09nq_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:01\nFinished backup at 26-JAN-2017 13:19:56\n\nStarting backup at 26-JAN-2017 13:19:56\nchannel c1: starting full datafile backup set\nchannel c1: specifying datafile(s) in backup set\nincluding current SPFILE in backup set\nchannel c1: starting piece 1 at 26-JAN-2017 13:19:56\nchannel c1: finished piece 1 at 26-JAN-2017 13:19:57\npiece handle=\/u99\/backup\/CDB\/spfile_2nrr09ns_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:01\nFinished backup at 26-JAN-2017 13:19:57\n\nStarting Control File and SPFILE Autobackup at 26-JAN-2017 13:19:57\npiece handle=\/u03\/fast_recovery_area\/CDB\/autobackup\/2017_01_26\/o1_mf_s_934291197_d8mtcfjz_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 26-JAN-2017 13:19:58\n\nreleased channel: c1\n\nreleased channel: c2\n\nreleased channel: c3\n\nreleased channel: c4\n\nRMAN><\/pre>\nAfter the backup was done, I do a quick “list backup summary” to see if everything is there, and also check the destination directory.<\/p>\n
RMAN> list backup summary tag 'DBI_BACKUP';\n\nList of Backups\n===============\nKey TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag\n------- -- -- - ----------- -------------------- ------- ------- ---------- ---\n67 B A A DISK 26-JAN-2017 13:18:54 1 1 YES DBI_BACKUP\n68 B A A DISK 26-JAN-2017 13:19:02 1 1 YES DBI_BACKUP\n69 B A A DISK 26-JAN-2017 13:19:07 1 1 YES DBI_BACKUP\n70 B A A DISK 26-JAN-2017 13:19:07 1 1 YES DBI_BACKUP\n81 B A A DISK 26-JAN-2017 13:19:53 1 1 YES DBI_BACKUP\n82 B F A DISK 26-JAN-2017 13:19:55 1 1 NO DBI_BACKUP\n83 B F A DISK 26-JAN-2017 13:19:56 1 1 NO DBI_BACKUP\n\nRMAN>\n\noracle@dbidg03:\/u99\/backup\/CDB\/ [CDB] ls -l\ntotal 975304\n-rw-r----- 1 oracle oinstall 18792448 Jan 26 13:19 control_2mrr09nq_1_1\n-rw-r----- 1 oracle oinstall 112111616 Jan 26 13:19 database_27rr09lt_1_1\n-rw-r----- 1 oracle oinstall 112711168 Jan 26 13:19 database_28rr09lt_1_1\n-rw-r----- 1 oracle oinstall 58626048 Jan 26 13:19 database_29rr09lt_1_1\n-rw-r----- 1 oracle oinstall 3691520 Jan 26 13:18 database_2arr09lt_1_1\n-rw-r----- 1 oracle oinstall 215056384 Jan 26 13:19 database_2brr09md_1_1\n-rw-r----- 1 oracle oinstall 132710400 Jan 26 13:19 database_2crr09md_1_1\n-rw-r----- 1 oracle oinstall 112173056 Jan 26 13:19 database_2drr09md_1_1\n-rw-r----- 1 oracle oinstall 56778752 Jan 26 13:19 database_2err09md_1_1\n-rw-r----- 1 oracle oinstall 110149632 Jan 26 13:19 database_2frr09ms_1_1\n-rw-r----- 1 oracle oinstall 1507328 Jan 26 13:19 database_2grr09nb_1_1\n-rw-r----- 1 oracle oinstall 54157312 Jan 26 13:19 database_2hrr09nd_1_1\n-rw-r----- 1 oracle oinstall 7716864 Jan 26 13:19 database_2irr09nd_1_1\n-rw-r----- 1 oracle oinstall 1327104 Jan 26 13:19 database_2jrr09ng_1_1\n-rw-r----- 1 oracle oinstall 1073152 Jan 26 13:19 database_2krr09nh_1_1\n-rw-r----- 1 oracle oinstall 7680 Jan 26 13:19 database_2lrr09np_1_1\n-rw-r----- 1 oracle oinstall 114688 Jan 26 13:19 spfile_2nrr09ns_1_1<\/pre>\nBut to be really 100% sure that I can restore the backup from TAG, I do a restore preview. The restore preview exists for quite a while now, but it is not so widly used for whatever reasons, I don’t know. I find it quite useful.<\/p>\n
RMAN> restore database preview from tag 'DBI_BACKUP';\n\nStarting restore at 26-JAN-2017 13:22:49\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=16 device type=DISK\n\nRMAN-00571: ===========================================================\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\nRMAN-00571: ===========================================================\nRMAN-03002: failure of restore command at 01\/26\/2017 13:22:49\nRMAN-06026: some targets not found - aborting restore\nRMAN-06023: no backup or copy of datafile 13 found to restore\nRMAN-06023: no backup or copy of datafile 12 found to restore\nRMAN-06023: no backup or copy of datafile 11 found to restore\nRMAN-06023: no backup or copy of datafile 10 found to restore\nRMAN-06023: no backup or copy of datafile 9 found to restore\nRMAN-06023: no backup or copy of datafile 8 found to restore\nRMAN-06023: no backup or copy of datafile 7 found to restore\nRMAN-06023: no backup or copy of datafile 6 found to restore\nRMAN-06023: no backup or copy of datafile 5 found to restore\nRMAN-06023: no backup or copy of datafile 4 found to restore\nRMAN-06023: no backup or copy of datafile 3 found to restore\nRMAN-06023: no backup or copy of datafile 1 found to restore\n\nRMAN><\/pre>\nOh no … that doesn’t look good. RMAN complaints that no backup or copy exists for all datafiles. What is going here? Is my backup useless? Yes and no. If I rely only on the TAG, then yes. However, the RMAN backup have been created successfully but with two different TAG’s. For the datafiles it used tag=TAG20170126T131908 and for the archivelogs, the controlfile and the spfile it used tag=DBI_BACKUP.<\/p>\n
So what is wrong here? The TAG was simply specified at the wrong location. If you put tag after archivelog, then only the archivelogs get that tag.<\/p>\n
BACKUP INCREMENTAL LEVEL 0 FORCE AS COMPRESSED BACKUPSET DATABASE plus archivelog tag 'DBI_BACKUP';<\/pre>\nIf you want to have the datafiles and the archivelogs tagged correctly, you have to put it after level 0 in my case. That’s usually enough.<\/p>\n
BACKUP INCREMENTAL LEVEL 0 tag 'DBI_BACKUP' FORCE AS COMPRESSED BACKUPSET DATABASE plus archivelog;<\/pre>\nOr if you want to be double sure and you are sort of paranoid, you can specify it twice, one after level 0, and one after archivelog.<\/p>\n
BACKUP INCREMENTAL LEVEL 0 tag 'DBI_BACKUP' FORCE AS COMPRESSED BACKUPSET DATABASE plus archivelog tag 'DBI_BACKUP';<\/pre>\nok. So lets try it again from scratch. But this time I put the Tag after LEVEL 0.<\/p>\n
RMAN> list backup summary;\n\nspecification does not match any backup in the repository\n\nRMAN> shutdown immediate\n\ndatabase closed\ndatabase dismounted\nOracle instance shut down\n\nRMAN> startup mount\n\nconnected to target database (not started)\nOracle instance started\ndatabase mounted\n\nTotal System Global Area 1795162112 bytes\n\nFixed Size 8793832 bytes\nVariable Size 553648408 bytes\nDatabase Buffers 1224736768 bytes\nRedo Buffers 7983104 bytes\n\n\nRMAN> run\n {\n allocate channel c1 device type disk format '\/u99\/backup\/CDB\/database_%U';\n allocate channel c2 device type disk format '\/u99\/backup\/CDB\/database_%U';\n allocate channel c3 device type disk format '\/u99\/backup\/CDB\/database_%U';\n allocate channel c4 device type disk format '\/u99\/backup\/CDB\/database_%U';\n BACKUP INCREMENTAL LEVEL 0 tag 'DBI_BACKUP' FORCE AS COMPRESSED BACKUPSET DATABASE plus archivelog;\n backup current controlfile tag 'DBI_BACKUP' format '\/u99\/backup\/CDB\/control_%U';\n backup spfile tag 'DBI_BACKUP' format '\/u99\/backup\/CDB\/spfile_%U';\n release channel c1;\n release channel c2;\n release channel c3;\n release channel c4;\n }2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>\n\nallocated channel: c1\nchannel c1: SID=237 device type=DISK\n\nallocated channel: c2\nchannel c2: SID=20 device type=DISK\n\nallocated channel: c3\nchannel c3: SID=254 device type=DISK\n\nallocated channel: c4\nchannel c4: SID=22 device type=DISK\n\n\nStarting backup at 26-JAN-2017 13:43:45\nchannel c1: starting compressed archived log backup set\nchannel c1: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=4 RECID=3 STAMP=934074668\ninput archived log thread=1 sequence=5 RECID=4 STAMP=934154679\nchannel c1: starting piece 1 at 26-JAN-2017 13:43:46\nchannel c2: starting compressed archived log backup set\nchannel c2: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=2 RECID=1 STAMP=934038010\ninput archived log thread=1 sequence=3 RECID=2 STAMP=934066843\nchannel c2: starting piece 1 at 26-JAN-2017 13:43:46\nchannel c3: starting compressed archived log backup set\nchannel c3: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=6 RECID=5 STAMP=934203623\ninput archived log thread=1 sequence=7 RECID=6 STAMP=934275778\ninput archived log thread=1 sequence=8 RECID=7 STAMP=934284094\ninput archived log thread=1 sequence=9 RECID=8 STAMP=934284153\nchannel c3: starting piece 1 at 26-JAN-2017 13:43:46\nchannel c4: starting compressed archived log backup set\nchannel c4: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=10 RECID=9 STAMP=934284199\ninput archived log thread=1 sequence=11 RECID=10 STAMP=934291133\ninput archived log thread=1 sequence=12 RECID=11 STAMP=934291192\ninput archived log thread=1 sequence=13 RECID=12 STAMP=934291966\nchannel c4: starting piece 1 at 26-JAN-2017 13:43:46\nchannel c4: finished piece 1 at 26-JAN-2017 13:43:47\npiece handle=\/u99\/backup\/CDB\/database_3frr0b4i_1_1 tag=DBI_BACKUP comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:01\nchannel c4: starting compressed archived log backup set\nchannel c4: specifying archived log(s) in backup set\ninput archived log thread=1 sequence=14 RECID=13 STAMP=934292026\ninput archived log thread=1 sequence=15 RECID=14 STAMP=934292464\nchannel c4: starting piece 1 at 26-JAN-2017 13:43:47\nchannel c4: finished piece 1 at 26-JAN-2017 13:43:48\npiece handle=\/u99\/backup\/CDB\/database_3grr0b4j_1_1 tag=DBI_BACKUP comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:01\nchannel c1: finished piece 1 at 26-JAN-2017 13:44:02\npiece handle=\/u99\/backup\/CDB\/database_3crr0b4i_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:16\nchannel c2: finished piece 1 at 26-JAN-2017 13:44:02\npiece handle=\/u99\/backup\/CDB\/database_3drr0b4i_1_1 tag=DBI_BACKUP comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:16\nchannel c3: finished piece 1 at 26-JAN-2017 13:44:02\npiece handle=\/u99\/backup\/CDB\/database_3err0b4i_1_1 tag=DBI_BACKUP comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:16\nFinished backup at 26-JAN-2017 13:44:02\n\nStarting backup at 26-JAN-2017 13:44:02\nchannel c1: starting compressed incremental level 0 datafile backup set\nchannel c1: specifying datafile(s) in backup set\ninput datafile file number=00001 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_system_d81c2wsf_.dbf\nchannel c1: starting piece 1 at 26-JAN-2017 13:44:02\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00003 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_sysaux_d81c49wd_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:44:02\nchannel c3: starting compressed incremental level 0 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00010 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_sysaux_d81cgjc2_.dbf\nchannel c3: starting piece 1 at 26-JAN-2017 13:44:02\nchannel c4: starting compressed incremental level 0 datafile backup set\nchannel c4: specifying datafile(s) in backup set\ninput datafile file number=00009 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_system_d81cgjbv_.dbf\ninput datafile file number=00011 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_undotbs1_d81cgjc2_.dbf\nchannel c4: starting piece 1 at 26-JAN-2017 13:44:03\nchannel c4: finished piece 1 at 26-JAN-2017 13:44:18\npiece handle=\/u99\/backup\/CDB\/database_3krr0b52_1_1 tag=DBI_BACKUP comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:15\nchannel c4: starting compressed incremental level 0 datafile backup set\nchannel c4: specifying datafile(s) in backup set\ninput datafile file number=00006 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_sysaux_d81c6fqn_.dbf\nchannel c4: starting piece 1 at 26-JAN-2017 13:44:18\nchannel c3: finished piece 1 at 26-JAN-2017 13:44:33\npiece handle=\/u99\/backup\/CDB\/database_3jrr0b52_1_1 tag=DBI_BACKUP comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:31\nchannel c3: starting compressed incremental level 0 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00013 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_rman_d8ccofgs_.dbf\ninput datafile file number=00012 name=\/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_users_d81cgq9f_.dbf\nchannel c3: starting piece 1 at 26-JAN-2017 13:44:33\nchannel c3: finished piece 1 at 26-JAN-2017 13:44:34\npiece handle=\/u99\/backup\/CDB\/database_3mrr0b61_1_1 tag=DBI_BACKUP comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:01\nchannel c3: starting compressed incremental level 0 datafile backup set\nchannel c3: specifying datafile(s) in backup set\ninput datafile file number=00005 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_system_d81c6fqo_.dbf\nchannel c3: starting piece 1 at 26-JAN-2017 13:44:35\nchannel c2: finished piece 1 at 26-JAN-2017 13:44:38\npiece handle=\/u99\/backup\/CDB\/database_3irr0b52_1_1 tag=DBI_BACKUP comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:36\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00008 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_undotbs1_d81c6fqp_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:44:38\nchannel c2: finished piece 1 at 26-JAN-2017 13:44:41\npiece handle=\/u99\/backup\/CDB\/database_3orr0b66_1_1 tag=DBI_BACKUP comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:03\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00004 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_undotbs1_d81c530h_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:44:41\nchannel c2: finished piece 1 at 26-JAN-2017 13:44:42\npiece handle=\/u99\/backup\/CDB\/database_3prr0b69_1_1 tag=DBI_BACKUP comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:01\nchannel c2: starting compressed incremental level 0 datafile backup set\nchannel c2: specifying datafile(s) in backup set\ninput datafile file number=00007 name=\/u02\/oradata\/CDB\/datafile\/o1_mf_users_d81c542r_.dbf\nchannel c2: starting piece 1 at 26-JAN-2017 13:44:43\nchannel c1: finished piece 1 at 26-JAN-2017 13:44:44\npiece handle=\/u99\/backup\/CDB\/database_3hrr0b52_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:42\nchannel c2: finished piece 1 at 26-JAN-2017 13:44:44\npiece handle=\/u99\/backup\/CDB\/database_3qrr0b6b_1_1 tag=DBI_BACKUP comment=NONE\nchannel c2: backup set complete, elapsed time: 00:00:01\nchannel c3: finished piece 1 at 26-JAN-2017 13:44:46\npiece handle=\/u99\/backup\/CDB\/database_3nrr0b62_1_1 tag=DBI_BACKUP comment=NONE\nchannel c3: backup set complete, elapsed time: 00:00:11\nchannel c4: finished piece 1 at 26-JAN-2017 13:44:46\npiece handle=\/u99\/backup\/CDB\/database_3lrr0b5i_1_1 tag=DBI_BACKUP comment=NONE\nchannel c4: backup set complete, elapsed time: 00:00:28\nFinished backup at 26-JAN-2017 13:44:46\n\nStarting backup at 26-JAN-2017 13:44:46\nspecification does not match any archived log in the repository\nbackup cancelled because there are no files to backup\nFinished backup at 26-JAN-2017 13:44:46\n\nStarting backup at 26-JAN-2017 13:44:46\nchannel c1: starting full datafile backup set\nchannel c1: specifying datafile(s) in backup set\nincluding current control file in backup set\nchannel c1: starting piece 1 at 26-JAN-2017 13:44:47\nchannel c1: finished piece 1 at 26-JAN-2017 13:44:48\npiece handle=\/u99\/backup\/CDB\/control_3rrr0b6e_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:01\nFinished backup at 26-JAN-2017 13:44:48\n\nStarting backup at 26-JAN-2017 13:44:48\nchannel c1: starting full datafile backup set\nchannel c1: specifying datafile(s) in backup set\nincluding current SPFILE in backup set\nchannel c1: starting piece 1 at 26-JAN-2017 13:44:48\nchannel c1: finished piece 1 at 26-JAN-2017 13:44:49\npiece handle=\/u99\/backup\/CDB\/spfile_3srr0b6g_1_1 tag=DBI_BACKUP comment=NONE\nchannel c1: backup set complete, elapsed time: 00:00:01\nFinished backup at 26-JAN-2017 13:44:49\n\nStarting Control File and SPFILE Autobackup at 26-JAN-2017 13:44:49\npiece handle=\/u03\/fast_recovery_area\/CDB\/autobackup\/2017_01_26\/o1_mf_s_934292553_d8mvt1l0_.bkp comment=NONE\nFinished Control File and SPFILE Autobackup at 26-JAN-2017 13:44:50\n\nreleased channel: c1\n\nreleased channel: c2\n\nreleased channel: c3\n\nreleased channel: c4\n\nRMAN><\/pre>\nAs you can see in the log, all backup pieces have been done with tag=DBI_BACKUP. But let’s double check it again.<\/p>\n
RMAN> list backup summary tag 'DBI_BACKUP';\n\nList of Backups\n===============\nKey TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag\n------- -- -- - ----------- -------------------- ------- ------- ---------- ---\n104 B A A DISK 26-JAN-2017 13:43:46 1 1 YES DBI_BACKUP\n105 B A A DISK 26-JAN-2017 13:43:47 1 1 YES DBI_BACKUP\n106 B A A DISK 26-JAN-2017 13:43:54 1 1 YES DBI_BACKUP\n107 B A A DISK 26-JAN-2017 13:43:59 1 1 YES DBI_BACKUP\n108 B A A DISK 26-JAN-2017 13:43:59 1 1 YES DBI_BACKUP\n109 B 0 A DISK 26-JAN-2017 13:44:14 1 1 YES DBI_BACKUP\n110 B 0 A DISK 26-JAN-2017 13:44:30 1 1 YES DBI_BACKUP\n111 B 0 A DISK 26-JAN-2017 13:44:34 1 1 YES DBI_BACKUP\n112 B 0 A DISK 26-JAN-2017 13:44:36 1 1 YES DBI_BACKUP\n113 B 0 A DISK 26-JAN-2017 13:44:39 1 1 YES DBI_BACKUP\n114 B 0 A DISK 26-JAN-2017 13:44:41 1 1 YES DBI_BACKUP\n115 B 0 A DISK 26-JAN-2017 13:44:43 1 1 YES DBI_BACKUP\n116 B 0 A DISK 26-JAN-2017 13:44:43 1 1 YES DBI_BACKUP\n117 B 0 A DISK 26-JAN-2017 13:44:44 1 1 YES DBI_BACKUP\n118 B 0 A DISK 26-JAN-2017 13:44:44 1 1 YES DBI_BACKUP\n119 B F A DISK 26-JAN-2017 13:44:47 1 1 NO DBI_BACKUP\n120 B F A DISK 26-JAN-2017 13:44:48 1 1 NO DBI_BACKUP\n\nRMAN> restore database preview summary from tag 'DBI_BACKUP';\n\nStarting restore at 26-JAN-2017 13:45:26\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=237 device type=DISK\n\nList of Backups\n===============\nKey TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag\n------- -- -- - ----------- -------------------- ------- ------- ---------- ---\n116 B 0 A DISK 26-JAN-2017 13:44:43 1 1 YES DBI_BACKUP\n112 B 0 A DISK 26-JAN-2017 13:44:36 1 1 YES DBI_BACKUP\n114 B 0 A DISK 26-JAN-2017 13:44:41 1 1 YES DBI_BACKUP\n117 B 0 A DISK 26-JAN-2017 13:44:44 1 1 YES DBI_BACKUP\n118 B 0 A DISK 26-JAN-2017 13:44:44 1 1 YES DBI_BACKUP\n115 B 0 A DISK 26-JAN-2017 13:44:43 1 1 YES DBI_BACKUP\n113 B 0 A DISK 26-JAN-2017 13:44:39 1 1 YES DBI_BACKUP\n109 B 0 A DISK 26-JAN-2017 13:44:14 1 1 YES DBI_BACKUP\n110 B 0 A DISK 26-JAN-2017 13:44:30 1 1 YES DBI_BACKUP\n111 B 0 A DISK 26-JAN-2017 13:44:34 1 1 YES DBI_BACKUP\nusing channel ORA_DISK_1\n\narchived logs generated after SCN 1904449 not found in repository\nrecovery will be done up to SCN 1904449\nMedia recovery start SCN is 1904449\nRecovery must be done beyond SCN 1904725 to clear datafile fuzziness\nFinished restore at 26-JAN-2017 13:45:26\n\nRMAN><\/pre>\nOk. Very good. That looks promising now. \ud83d\ude42 Let’s do the application changes now …<\/p>\n
RMAN> alter database open;\n\nStatement processed\n\n-- Do some application changes ...\n\nSQL> create table x ...<\/pre>\nSQL> create table y ...<\/pre>\nSQL> create table z ...<\/pre>\n<\/pre>\nAnd the final test is of course, to do the real restore\/recovery to the point where the cold backup was done.<\/p>\n
RMAN> shutdown abort\n\nOracle instance shut down\n\nRMAN> startup nomount\n\nconnected to target database (not started)\nOracle instance started\n\nTotal System Global Area 1795162112 bytes\n\nFixed Size 8793832 bytes\nVariable Size 553648408 bytes\nDatabase Buffers 1224736768 bytes\nRedo Buffers 7983104 bytes\n\nRMAN> restore controlfile from '\/u99\/backup\/CDB\/control_3rrr0b6e_1_1';\n\nStarting restore at 26-JAN-2017 13:48:50\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=237 device type=DISK\n\nchannel ORA_DISK_1: restoring control file\nchannel ORA_DISK_1: restore complete, elapsed time: 00:00:01\noutput file name=\/u02\/oradata\/CDB\/controlfile\/o1_mf_d81c6189_.ctl\noutput file name=\/u03\/fast_recovery_area\/CDB\/controlfile\/o1_mf_d81c61b4_.ctl\nFinished restore at 26-JAN-2017 13:48:51\n\nRMAN> alter database mount;\n\nStatement processed\nreleased channel: ORA_DISK_1\n\n\t\nRMAN> run\n {\n allocate channel c1 device type disk;\n allocate channel c2 device type disk;\n allocate channel c3 device type disk;\n allocate channel c4 device type disk;\n restore database from tag 'DBI_BACKUP';\n release channel c1;\n release channel c2;\n release channel c3;\n release channel c4;\n }2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12>\n\nallocated channel: c1\nchannel c1: SID=256 device type=DISK\n\nallocated channel: c2\nchannel c2: SID=24 device type=DISK\n\nallocated channel: c3\nchannel c3: SID=257 device type=DISK\n\nallocated channel: c4\nchannel c4: SID=25 device type=DISK\n\nStarting restore at 26-JAN-2017 13:49:39\nStarting implicit crosscheck backup at 26-JAN-2017 13:49:39\nCrosschecked 15 objects\nFinished implicit crosscheck backup at 26-JAN-2017 13:49:40\n\nStarting implicit crosscheck copy at 26-JAN-2017 13:49:40\nFinished implicit crosscheck copy at 26-JAN-2017 13:49:40\n\nsearching for all files in the recovery area\ncataloging files...\ncataloging done\n\nList of Cataloged Files\n=======================\nFile Name: \/u03\/fast_recovery_area\/CDB\/autobackup\/2017_01_26\/o1_mf_s_934292553_d8mvt1l0_.bkp\n\n\nskipping datafile 5; already restored to file \/u02\/oradata\/CDB\/datafile\/o1_mf_system_d81c6fqo_.dbf\nskipping datafile 6; already restored to file \/u02\/oradata\/CDB\/datafile\/o1_mf_sysaux_d81c6fqn_.dbf\nskipping datafile 8; already restored to file \/u02\/oradata\/CDB\/datafile\/o1_mf_undotbs1_d81c6fqp_.dbf\nchannel c1: starting datafile backup set restore\nchannel c1: specifying datafile(s) to restore from backup set\nchannel c1: restoring datafile 00009 to \/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_system_d81cgjbv_.dbf\nchannel c1: restoring datafile 00011 to \/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_undotbs1_d81cgjc2_.dbf\nchannel c1: reading from backup piece \/u99\/backup\/CDB\/database_3krr0b52_1_1\nchannel c2: starting datafile backup set restore\nchannel c2: specifying datafile(s) to restore from backup set\nchannel c2: restoring datafile 00010 to \/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_sysaux_d81cgjc2_.dbf\nchannel c2: reading from backup piece \/u99\/backup\/CDB\/database_3jrr0b52_1_1\nchannel c3: starting datafile backup set restore\nchannel c3: specifying datafile(s) to restore from backup set\nchannel c3: restoring datafile 00012 to \/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_users_d81cgq9f_.dbf\nchannel c3: restoring datafile 00013 to \/u02\/oradata\/CDB\/46727C2ED8612B70E053CB38A8C078C9\/datafile\/o1_mf_rman_d8ccofgs_.dbf\nchannel c3: reading from backup piece \/u99\/backup\/CDB\/database_3mrr0b61_1_1\nchannel c4: starting datafile backup set restore\nchannel c4: specifying datafile(s) to restore from backup set\nchannel c4: restoring datafile 00003 to \/u02\/oradata\/CDB\/datafile\/o1_mf_sysaux_d81c49wd_.dbf\nchannel c4: reading from backup piece \/u99\/backup\/CDB\/database_3irr0b52_1_1\nchannel c3: piece handle=\/u99\/backup\/CDB\/database_3mrr0b61_1_1 tag=DBI_BACKUP\nchannel c3: restored backup piece 1\nchannel c3: restore complete, elapsed time: 00:00:03\nchannel c3: starting datafile backup set restore\nchannel c3: specifying datafile(s) to restore from backup set\nchannel c3: restoring datafile 00004 to \/u02\/oradata\/CDB\/datafile\/o1_mf_undotbs1_d81c530h_.dbf\nchannel c3: reading from backup piece \/u99\/backup\/CDB\/database_3prr0b69_1_1\nchannel c3: piece handle=\/u99\/backup\/CDB\/database_3prr0b69_1_1 tag=DBI_BACKUP\nchannel c3: restored backup piece 1\nchannel c3: restore complete, elapsed time: 00:00:01\nchannel c3: starting datafile backup set restore\nchannel c3: specifying datafile(s) to restore from backup set\nchannel c3: restoring datafile 00001 to \/u02\/oradata\/CDB\/datafile\/o1_mf_system_d81c2wsf_.dbf\nchannel c3: reading from backup piece \/u99\/backup\/CDB\/database_3hrr0b52_1_1\nchannel c1: piece handle=\/u99\/backup\/CDB\/database_3krr0b52_1_1 tag=DBI_BACKUP\nchannel c1: restored backup piece 1\nchannel c1: restore complete, elapsed time: 00:00:20\nchannel c1: starting datafile backup set restore\nchannel c1: specifying datafile(s) to restore from backup set\nchannel c1: restoring datafile 00007 to \/u02\/oradata\/CDB\/datafile\/o1_mf_users_d81c542r_.dbf\nchannel c1: reading from backup piece \/u99\/backup\/CDB\/database_3qrr0b6b_1_1\nchannel c1: piece handle=\/u99\/backup\/CDB\/database_3qrr0b6b_1_1 tag=DBI_BACKUP\nchannel c1: restored backup piece 1\nchannel c1: restore complete, elapsed time: 00:00:01\nchannel c2: piece handle=\/u99\/backup\/CDB\/database_3jrr0b52_1_1 tag=DBI_BACKUP\nchannel c2: restored backup piece 1\nchannel c2: restore complete, elapsed time: 00:00:27\nchannel c4: piece handle=\/u99\/backup\/CDB\/database_3irr0b52_1_1 tag=DBI_BACKUP\nchannel c4: restored backup piece 1\nchannel c4: restore complete, elapsed time: 00:00:35\nchannel c3: piece handle=\/u99\/backup\/CDB\/database_3hrr0b52_1_1 tag=DBI_BACKUP\nchannel c3: restored backup piece 1\nchannel c3: restore complete, elapsed time: 00:00:40\nFinished restore at 26-JAN-2017 13:50:25\n\nreleased channel: c1\n\nreleased channel: c2\n\nreleased channel: c3\n\nreleased channel: c4\n\nRMAN><\/pre>\nNo recovery is needed here, because it was an cold RMAN backup. You can just open the database with open resetslogs.<\/p>\n
RMAN> alter database open RESETLOGS;\n\nStatement processed<\/pre>\nConclusion<\/h3>\n
Take care that you put your RMAN Tags at the correct location.<\/p>\n","protected":false},"excerpt":{"rendered":"
By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I want to do it with a cold backup in combination with RMAN tags. Unfortunately I don’t […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198],"tags":[1025,270],"type_dbi":[],"class_list":["post-9715","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","tag-oracle-12cr2","tag-rman"],"acf":[],"yoast_head":"\n
Oracle 12cR2 - RMAN cold backup with TAG's - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 12cR2 - RMAN cold backup with TAG's\" \/>\n<meta property=\"og:description\" content=\"By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I want to do it with a cold backup in combination with RMAN tags. Unfortunately I don’t […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-26T12:35:25+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 12cR2 – RMAN cold backup with TAG’s\",\"datePublished\":\"2017-01-26T12:35:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\"},\"wordCount\":426,\"commentCount\":0,\"keywords\":[\"Oracle 12cR2\",\"RMAN\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\",\"name\":\"Oracle 12cR2 - RMAN cold backup with TAG's - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-01-26T12:35:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 12cR2 – RMAN cold backup with TAG’s\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 12cR2 - RMAN cold backup with TAG's - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 12cR2 - RMAN cold backup with TAG's","og_description":"By William Sescu I am planning to backup my 12R2 container database, because a huge application change is coming up, and I want to be sure that I have a good RMAN backup beforehand. For that particular DB, I want to do it with a cold backup in combination with RMAN tags. Unfortunately I don’t […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/","og_site_name":"dbi Blog","article_published_time":"2017-01-26T12:35:25+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 12cR2 – RMAN cold backup with TAG’s","datePublished":"2017-01-26T12:35:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/"},"wordCount":426,"commentCount":0,"keywords":["Oracle 12cR2","RMAN"],"articleSection":["Database Administration & Monitoring","Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/","name":"Oracle 12cR2 - RMAN cold backup with TAG's - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-01-26T12:35:25+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-rman-cold-backup-with-tags\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 12cR2 – RMAN cold backup with TAG’s"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9715","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9715"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9715\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9715"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}