{"id":562,"date":"2019-08-15T12:15:35","date_gmt":"2019-08-15T15:15:35","guid":{"rendered":"http:\/\/www.fernandosimon.com\/blog\/?p=562"},"modified":"2020-07-19T19:17:37","modified_gmt":"2020-07-19T22:17:37","slug":"zdlra-virtual-full-backup-and-incremental-forever","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/","title":{"rendered":"ZDLRA, Virtual Full Backup and Incremental Forever"},"content":{"rendered":"

One of the most knows features of ZDLRA is the virtual full backup, basically incremental forever strategy. But what this means in real life? In this post, I will show some details about that and how interesting they are, check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA.<\/p>\n

This post is based on my previous one<\/a> where I showed all the steps to configure the VPC and enroll database at ZDLRA. <\/p>\n

Virtual Full Backup<\/h1>\n

A virtual full backup appears as an incremental level 0 backup in the recovery catalog. From the user’s perspective, a virtual full backup is indistinguishable from a non-virtual full backup. Using virtual backups, Recovery Appliance provides the protection of frequent level 0 backups with only the cost of frequent level 1 backups.<\/em><\/p>\n

\"\"<\/a><\/p>\n

This definition (and image) are in the Zero Data Loss Recovery Appliance Administrator’s Guide<\/a> and I think that represents the essence of the virtual full backup. ZDLRA receive the incremental level 1 backup, index it, and generate a level 0 to you that it is indistinguishable from a normal backup level 0.<\/p>\n

<\/p>\n

As you can see, virtual full are deeply linked with incremental forever strategy (that it is just executing incremental backups). And based in these incremental backups you receive a full backup available for usage.<\/p>\n

To start, I open RMAN and connect in the rman catalog (ZDLRA database, using the VPC configured) and execute a level 0 backup:<\/p>\n

RMAN> RUN {\r\n2> BACKUP INCREMENTAL LEVEL 0 DEVICE TYPE SBT FILESPERSET 1 DATABASE TAG 'BKP-DB-INC0';\r\n3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';\r\n4> BACKUP DEVICE TYPE SBT FILESPERSET 100 FORMAT '%U' ARCHIVELOG ALL NOT BACKED UP TAG 'BKP-ARCH';\r\n5> }\r\n\r\nStarting backup at 15-08-2019_00:44:36\r\nallocated channel: ORA_SBT_TAPE_1\r\nchannel ORA_SBT_TAPE_1: SID=100 device type=SBT_TAPE\r\nchannel ORA_SBT_TAPE_1: RA Library (ZDLRA) SID=901C8083732A1691E053010310AC46B7\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=\/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_00:44:38\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_00:47:23\r\npiece handle=ORCL18_0tu97pnm_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:45\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00003 name=\/u01\/app\/oracle\/oradata\/ORCL18\/sysaux01.dbf\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_00:47:24\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_00:48:59\r\npiece handle=ORCL18_0uu97pss_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:01:35\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00004 name=\/u01\/app\/oracle\/oradata\/ORCL18\/undotbs01.dbf\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_00:48:59\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_00:49:02\r\npiece handle=ORCL18_0vu97pvr_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00007 name=\/u01\/app\/oracle\/oradata\/ORCL18\/users01.dbf\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_00:49:02\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_00:49:05\r\npiece handle=ORCL18_10u97pvu_1_1 tag=BKP-DB-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03\r\nFinished backup at 15-08-2019_00:49:05\r\n\r\nStarting Control File and SPFILE Autobackup at 15-08-2019_00:49:05\r\npiece handle=c-3914023082-20190815-02 comment=API Version 2.0,MMS Version 12.2.0.2\r\nFinished Control File and SPFILE Autobackup at 15-08-2019_00:49:22\r\n\r\nsql statement: ALTER SYSTEM ARCHIVE LOG CURRENT\r\n\r\nStarting backup at 15-08-2019_00:49:28\r\ncurrent log archived\r\nusing channel ORA_SBT_TAPE_1\r\nskipping archived logs of thread 1 from sequence 4 to 9; already backed up\r\nchannel ORA_SBT_TAPE_1: starting archived log backup set\r\nchannel ORA_SBT_TAPE_1: specifying archived log(s) in backup set\r\ninput archived log thread=1 sequence=10 RECID=7 STAMP=1016326166\r\ninput archived log thread=1 sequence=11 RECID=8 STAMP=1016326170\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_00:49:32\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_00:49:35\r\npiece handle=12u97q0s_1_1 tag=BKP-ARCH comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03\r\nFinished backup at 15-08-2019_00:49:35\r\n\r\nStarting Control File and SPFILE Autobackup at 15-08-2019_00:49:35\r\npiece handle=c-3914023082-20190815-03 comment=API Version 2.0,MMS Version 12.2.0.2\r\nFinished Control File and SPFILE Autobackup at 15-08-2019_00:49:51\r\n\r\nRMAN> list backup of datafile 1;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2222    Incr 0  748.50M    SBT_TAPE    00:02:32     15-08-2019_00:47:10\r\n        BP Key: 2223   Status: AVAILABLE  Compressed: NO  Tag: BKP-DB-INC0\r\n        Handle: ORCL18_0tu97pnm_1_1   Media: Recovery Appliance (ZDLRA)\r\n  List of Datafiles in backup set 2222\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1614233    15-08-2019_00:44:39              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nRMAN><\/pre>\n
As you can see a simple incremental level 0 backup, archive log generation, and backup. ZDLRA after receive this backup start to index it to generate the base level 0. If you go to ZDLRA database you can see:<\/p>\n
SQL> select TASK_ID, TASK_TYPE, STATE, WAITING_ON, DB_KEY, DB_UNIQUE_NAME, CREATION_TIME, ERROR_COUNT, DF_KEY, BS_KEY, BP_KEY, VB_KEY from rasys.ra_task where archived = 'N';\r\n\r\n   TASK_ID TASK_TYPE            STATE           WAITING_ON     DB_KEY DB_UNIQUE_NAME                 CREATION_TIME                       ERROR_COUNT     DF_KEY     BS_KEY     BP_KEY     VB_KEY\r\n---------- -------------------- --------------- ---------- ---------- ------------------------------ ----------------------------------- ----------- ---------- ---------- ---------- ----------\r\n      9626 INDEX_BACKUP         RUNNING                          1527 ORCL18                         15-AUG-19 12.47.12.479004 AM +02:00           0                             2223\r\n      9627 INDEX_BACKUP         EXECUTABLE                       1527 ORCL18                         15-AUG-19 12.48.56.229219 AM +02:00           0                             2228\r\n      9628 INDEX_BACKUP         EXECUTABLE                       1527 ORCL18                         15-AUG-19 12.49.02.200951 AM +02:00           0                             2232\r\n      9629 INDEX_BACKUP         EXECUTABLE                       1527 ORCL18                         15-AUG-19 12.49.04.895727 AM +02:00           0                             2236\r\n\r\n4 rows selected.\r\n\r\nSQL><\/pre>\n
Above look the task INDEX_BACKUP running BS_KEY 2223, and check that it is the same backupset for datafile 1 that I showed before (I executed the list backup for datafile 1 just after the backup finish). And while the INDEX_BACKUP task still running you can see check again the list backupset for datafile 1 at rman:<\/p>\n
RMAN>  list backup of datafile 1;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2222    Incr 0  748.50M    SBT_TAPE    00:02:32     15-08-2019_00:47:10\r\n        BP Key: 2223   Status: AVAILABLE  Compressed: NO  Tag: BKP-DB-INC0\r\n        Handle: ORCL18_0tu97pnm_1_1   Media: Recovery Appliance (ZDLRA)\r\n  List of Datafiles in backup set 2222\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1614233    15-08-2019_00:44:39              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2336    Incr 0  329.21M    SBT_TAPE    00:02:34     15-08-2019_00:47:12\r\n        BP Key: 2337   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC0\r\n        Handle: VB$_4142545763_2226I   Media:\r\n  List of Datafiles in backup set 2336\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1614233    15-08-2019_00:44:39              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nRMAN><\/pre>\n
Look how interesting it is. Now you have a new backupset (BS key 2336) that it is a clone for the original. Have same SCN, same TAG, same completion time, and size. The only difference is the handle that has the ZDLRA pattern VB$_*. And after some tasks inside ZDLRA finish (like RM_INC_FILES and RUN_PURGE_DF) you have just one backup of datafile 1:<\/p>\n
RMAN> list backup of datafile 1;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2336    Incr 0  329.21M    SBT_TAPE    00:02:34     15-08-2019_00:47:12\r\n        BP Key: 2337   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC0\r\n        Handle: VB$_4142545763_2226I   Media:\r\n  List of Datafiles in backup set 2336\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1614233    15-08-2019_00:44:39              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nRMAN><\/pre>\n
As I told in my previous post<\/a>, ZDLRA has the ability to open your backupset and index every block for your datafile, and more important: validated every block for each datafile.<\/p>\n
Incremental Forever<\/h1>\n
Above was just for the initial level 0 backup, and it is not \u201cincremental forever\u201d. But if you do an incremental level 1 backup (I cropped the output to reduce the post size but it was just: BACKUP INCREMENTAL LEVEL 1 DEVICE TYPE SBT FILESPERSET 1 DATABASE TAG ‘BKP-DB-INC1’;. Check the list backup after that:<\/p>\n
RMAN> list backup of datafile 1;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2336    Incr 0  329.21M    SBT_TAPE    00:02:34     15-08-2019_00:47:12\r\n        BP Key: 2337   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC0\r\n        Handle: VB$_4142545763_2226I   Media:\r\n  List of Datafiles in backup set 2336\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1614233    15-08-2019_00:44:39              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2589    Incr 1  48.00K     SBT_TAPE    00:00:02     15-08-2019_00:58:00\r\n        BP Key: 2590   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2588I   Media:\r\n  List of Datafiles in backup set 2589\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    1  Incr 1614888    15-08-2019_00:57:59              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2644    Incr 0  328.08M    SBT_TAPE    00:00:02     15-08-2019_00:58:00\r\n        BP Key: 2645   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2588_1   Media:\r\n  List of Datafiles in backup set 2644\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1614888    15-08-2019_00:57:59              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nRMAN><\/pre>\n
Look the details above. Inside of rman catalog at ZDLRA was made available to you a new level 0 backup that it is the virtual full backup. This level 0 have the same SCN than the incremental level 1.<\/p>\n
So, basically, ZDLRA opened the backup incremental level 1 that you sent, read all the blocks, index it and based in the previous backup level 0 that was available (virtual or not \u2013 this is important) merged the block and present to you a new level 0. And if you do this every day, after an incremental level 1 you receive a complete virtual full backup.<\/p>\n
In real life, it is simple like that.<\/strong> Again, check how interesting it is, you have now one backup level 0 available after the incremental that have a new backupset (BS key 2644) that it is a merge from the incremental level 1 (backupset 2589) with the previous level 0 (backupset 2636). And have the same SCN, same TAG, same completion time that the incremental level 1.<\/p>\n
Some details that you need to take care of this. If you use rman encryption virtual full backups will not work. For TDE, you can use it, not a problem. But you can\u2019t use TDE with rman compression enabled. Check  here<\/a>. The recommendation too is using FILESPERSET 1 while doing the backup. This is good because reduce some overhead inside of ZDLRA (to open every backup and split it), and reduce pollution inside rman catalog list backup (if you sent a backup without fileperset, ZDLRA does not remove it from the list).<\/p>\n
If I do a backup without filersperset the ZDLRA will open the bakupset and generate a virtual full for each datafile that it is inside of the original backupset. Check below that SCN is the same than incremental level 1:<\/p>\n
RMAN> list backup of database completed after \"sysdate - 5\/1440\";\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2905    Incr 1  1.26M      SBT_TAPE    00:00:08     15-08-2019_01:04:28\r\n        BP Key: 2906   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2827I   Media:\r\n  List of Datafiles in backup set 2905\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    1  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n  3    1  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/sysaux01.dbf\r\n  4    1  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/undotbs01.dbf\r\n  7    1  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/users01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2992    Incr 0  328.09M    SBT_TAPE    00:00:08     15-08-2019_01:04:28\r\n        BP Key: 2993   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2827_1   Media:\r\n  List of Datafiles in backup set 2992\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n2996    Incr 0  40.00K     SBT_TAPE    00:00:08     15-08-2019_01:04:28\r\n        BP Key: 2997   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2827_7   Media:\r\n  List of Datafiles in backup set 2996\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  7    0  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/users01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3000    Incr 0  480.00K    SBT_TAPE    00:00:08     15-08-2019_01:04:28\r\n        BP Key: 3001   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2827_4   Media:\r\n  List of Datafiles in backup set 3000\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  4    0  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/undotbs01.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3004    Incr 0  135.47M    SBT_TAPE    00:00:08     15-08-2019_01:04:28\r\n        BP Key: 3005   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC1\r\n        Handle: VB$_4142545763_2827_3   Media:\r\n  List of Datafiles in backup set 3004\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  3    0  Incr 1615589    15-08-2019_01:04:20              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/sysaux01.dbf\r\n\r\nRMAN><\/pre>\n
The virtual backup continue to work if you use the SECTION SIZE (it is recommended by the way<\/a>, especially for huge databases). Look the example:<\/p>\n
[oracle@orcloel7 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Aug 15 01:11:58 2019\r\nVersion 18.6.0.0.0\r\n\r\nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.6.0.0.0\r\n\r\nSQL> create tablespace simon datafile '\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf' size 1G;\r\n\r\nTablespace created.\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\r\nVersion 18.6.0.0.0\r\n[oracle@orcloel7 ~]$ rman target=\/ catalog=cat_zdlra\/s3nhazdlra@zdlra\r\n\r\nRecovery Manager: Release 18.0.0.0.0 - Production on Thu Aug 15 01:15:24 2019\r\nVersion 18.6.0.0.0\r\n\r\nCopyright (c) 1982, 2018, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database: ORCL18 (DBID=3914023082)\r\nconnected to recovery catalog database\r\nPL\/SQL package CAT_ZDLRA.DBMS_RCVCAT version 18.03.00.00. in RCVCAT database is not current\r\nPL\/SQL package CAT_ZDLRA.DBMS_RCVMAN version 18.03.00.00 in RCVCAT database is not current\r\n\r\nRMAN> report schema;\r\n\r\nstarting full resync of recovery catalog\r\nfull resync complete\r\nReport of database schema for database with db_unique_name ORCL18\r\n\r\nList of Permanent Datafiles\r\n===========================\r\nFile Size(MB) Tablespace           RB segs Datafile Name\r\n---- -------- -------------------- ------- ------------------------\r\n1    870      SYSTEM               YES     \/u01\/app\/oracle\/oradata\/ORCL18\/system01.dbf\r\n3    510      SYSAUX               NO      \/u01\/app\/oracle\/oradata\/ORCL18\/sysaux01.dbf\r\n4    320      UNDOTBS1             YES     \/u01\/app\/oracle\/oradata\/ORCL18\/undotbs01.dbf\r\n5    1024     SIMON                NO      \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n7    5        USERS                NO      \/u01\/app\/oracle\/oradata\/ORCL18\/users01.dbf\r\n\r\nList of Temporary Files\r\n=======================\r\nFile Size(MB) Tablespace           Maxsize(MB) Tempfile Name\r\n---- -------- -------------------- ----------- --------------------\r\n1    49       TEMP                 32767       \/u01\/app\/oracle\/oradata\/ORCL18\/temp01.dbf\r\n\r\nRMAN> BACKUP INCREMENTAL LEVEL 0 SECTION SIZE 250M DEVICE TYPE SBT DATAFILE 5 TAG 'BKP-DBF5-INC0';\r\n\r\nStarting backup at 15-08-2019_01:16:35\r\nallocated channel: ORA_SBT_TAPE_1\r\nchannel ORA_SBT_TAPE_1: SID=68 device type=SBT_TAPE\r\nchannel ORA_SBT_TAPE_1: RA Library (ZDLRA) SID=901CF26E504F1E35E053010310AC27EC\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 1 through 32000\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_01:16:37\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_01:16:38\r\npiece handle=ORCL18_1fu97rjl_1_1 tag=BKP-DBF5-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 32001 through 64000\r\nchannel ORA_SBT_TAPE_1: starting piece 2 at 15-08-2019_01:16:38\r\nchannel ORA_SBT_TAPE_1: finished piece 2 at 15-08-2019_01:16:39\r\npiece handle=ORCL18_1fu97rjl_2_1 tag=BKP-DBF5-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 64001 through 96000\r\nchannel ORA_SBT_TAPE_1: starting piece 3 at 15-08-2019_01:16:39\r\nchannel ORA_SBT_TAPE_1: finished piece 3 at 15-08-2019_01:16:42\r\npiece handle=ORCL18_1fu97rjl_3_1 tag=BKP-DBF5-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:03\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 96001 through 128000\r\nchannel ORA_SBT_TAPE_1: starting piece 4 at 15-08-2019_01:16:42\r\nchannel ORA_SBT_TAPE_1: finished piece 4 at 15-08-2019_01:16:43\r\npiece handle=ORCL18_1fu97rjl_4_1 tag=BKP-DBF5-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nchannel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 128001 through 131072\r\nchannel ORA_SBT_TAPE_1: starting piece 5 at 15-08-2019_01:16:43\r\nchannel ORA_SBT_TAPE_1: finished piece 5 at 15-08-2019_01:16:44\r\npiece handle=ORCL18_1fu97rjl_5_1 tag=BKP-DBF5-INC0 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 15-08-2019_01:16:44\r\n\r\nStarting Control File and SPFILE Autobackup at 15-08-2019_01:16:44\r\npiece handle=c-3914023082-20190815-08 comment=API Version 2.0,MMS Version 12.2.0.2\r\nFinished Control File and SPFILE Autobackup at 15-08-2019_01:16:52\r\n\r\nRMAN> list backup of datafile 5;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3244    Incr 0  208.00K    SBT_TAPE    00:00:08     15-08-2019_01:16:45\r\n  List of Datafiles in backup set 3244\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  5    0  Incr 1616756    15-08-2019_01:16:37              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n\r\n  Backup Set Copy #1 of backup set 3244\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:00:08     15-08-2019_01:16:45 YES        BKP-DBF5-INC0\r\n\r\n    List of Backup Pieces for backup set 3244 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    3245    1   AVAILABLE                           VB$_4142545763_3227I\r\n    3250    2   AVAILABLE                           VB$_4142545763_3248I\r\n    3255    3   AVAILABLE                           VB$_4142545763_3253I\r\n    3260    4   AVAILABLE                           VB$_4142545763_3258I\r\n    3272    5   AVAILABLE                           VB$_4142545763_3270I\r\n\r\nRMAN> BACKUP INCREMENTAL LEVEL 1 SECTION SIZE 250M DEVICE TYPE SBT DATAFILE 5 TAG 'BKP-DBF5-INC1';\r\n\r\nStarting backup at 15-08-2019_01:20:01\r\nusing channel ORA_SBT_TAPE_1\r\nchannel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 1 through 32000\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_01:20:02\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_01:20:03\r\npiece handle=ORCL18_1lu97rq2_1_1 tag=BKP-DBF5-INC1 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nchannel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 32001 through 64000\r\nchannel ORA_SBT_TAPE_1: starting piece 2 at 15-08-2019_01:20:03\r\nchannel ORA_SBT_TAPE_1: finished piece 2 at 15-08-2019_01:20:10\r\npiece handle=ORCL18_1lu97rq2_2_1 tag=BKP-DBF5-INC1 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:07\r\nchannel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 64001 through 96000\r\nchannel ORA_SBT_TAPE_1: starting piece 3 at 15-08-2019_01:20:10\r\nchannel ORA_SBT_TAPE_1: finished piece 3 at 15-08-2019_01:20:11\r\npiece handle=ORCL18_1lu97rq2_3_1 tag=BKP-DBF5-INC1 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nchannel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 96001 through 128000\r\nchannel ORA_SBT_TAPE_1: starting piece 4 at 15-08-2019_01:20:11\r\nchannel ORA_SBT_TAPE_1: finished piece 4 at 15-08-2019_01:20:12\r\npiece handle=ORCL18_1lu97rq2_4_1 tag=BKP-DBF5-INC1 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nchannel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nbacking up blocks 128001 through 131072\r\nchannel ORA_SBT_TAPE_1: starting piece 5 at 15-08-2019_01:20:12\r\nchannel ORA_SBT_TAPE_1: finished piece 5 at 15-08-2019_01:20:13\r\npiece handle=ORCL18_1lu97rq2_5_1 tag=BKP-DBF5-INC1 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 15-08-2019_01:20:13\r\n\r\nStarting Control File and SPFILE Autobackup at 15-08-2019_01:20:13\r\npiece handle=c-3914023082-20190815-09 comment=API Version 2.0,MMS Version 12.2.0.2\r\nFinished Control File and SPFILE Autobackup at 15-08-2019_01:20:21\r\n\r\nRMAN> list backup of datafile 5;\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3244    Incr 0  208.00K    SBT_TAPE    00:00:08     15-08-2019_01:16:45\r\n  List of Datafiles in backup set 3244\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  5    0  Incr 1616756    15-08-2019_01:16:37              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n\r\n  Backup Set Copy #1 of backup set 3244\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:00:08     15-08-2019_01:16:45 YES        BKP-DBF5-INC0\r\n\r\n    List of Backup Pieces for backup set 3244 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    3245    1   AVAILABLE                           VB$_4142545763_3227I\r\n    3250    2   AVAILABLE                           VB$_4142545763_3248I\r\n    3255    3   AVAILABLE                           VB$_4142545763_3253I\r\n    3260    4   AVAILABLE                           VB$_4142545763_3258I\r\n    3272    5   AVAILABLE                           VB$_4142545763_3270I\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3355    Incr 1  200.00K    SBT_TAPE    00:00:12     15-08-2019_01:20:14\r\n  List of Datafiles in backup set 3355\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  5    1  Incr 1616986    15-08-2019_01:20:02              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n\r\n  Backup Set Copy #1 of backup set 3355\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:00:12     15-08-2019_01:20:14 YES        BKP-DBF5-INC1\r\n\r\n    List of Backup Pieces for backup set 3355 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    3356    1   AVAILABLE                           VB$_4142545763_3354I\r\n    3406    2   AVAILABLE                           VB$_4142545763_3404I\r\n    3415    3   AVAILABLE                           VB$_4142545763_3413I\r\n    3424    4   AVAILABLE                           VB$_4142545763_3422I\r\n    3433    5   AVAILABLE                           VB$_4142545763_3431I\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3359    Incr 0  132.50K    SBT_TAPE    00:00:12     15-08-2019_01:20:14\r\n  List of Datafiles in backup set 3359\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  5    0  Incr 1616986    15-08-2019_01:20:02              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n\r\n  Backup Set Copy #1 of backup set 3359\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:00:12     15-08-2019_01:20:14 YES        BKP-DBF5-INC1\r\n\r\n    List of Backup Pieces for backup set 3359 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    3360    1   AVAILABLE                           VB$_4142545763_3354_5\r\n    3410    2   AVAILABLE                           VB$_4142545763_3404_5\r\n    3419    3   AVAILABLE                           VB$_4142545763_3413_5\r\n    3428    4   AVAILABLE                           VB$_4142545763_3422_5\r\n    3437    5   AVAILABLE                           VB$_4142545763_3431_5\r\n\r\nRMAN><\/pre>\n
As you can see, I created a tablespace and made backup level 0 (and 1) with section size. And after the index was created a virtual full backup, based on the incremental, for each size. This speed up the restore phase because you can parallelize it (instead if you use a single backupset). ZDLRA will \u201cfix\u201d if you made an incremental level 1 without section size:<\/p>\n
RMAN> BACKUP INCREMENTAL LEVEL 1 DEVICE TYPE SBT DATAFILE 5 TAG 'BKP-DBF5-INC1';\r\n\r\nStarting backup at 15-08-2019_01:23:17\r\nusing channel ORA_SBT_TAPE_1\r\nchannel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set\r\nchannel ORA_SBT_TAPE_1: specifying datafile(s) in backup set\r\ninput datafile file number=00005 name=\/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\nchannel ORA_SBT_TAPE_1: starting piece 1 at 15-08-2019_01:23:17\r\nchannel ORA_SBT_TAPE_1: finished piece 1 at 15-08-2019_01:23:18\r\npiece handle=ORCL18_1ru97s05_1_1 tag=BKP-DBF5-INC1 comment=API Version 2.0,MMS Version 12.2.0.2\r\nchannel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 15-08-2019_01:23:18\r\n\r\nStarting Control File and SPFILE Autobackup at 15-08-2019_01:23:19\r\npiece handle=c-3914023082-20190815-0a comment=API Version 2.0,MMS Version 12.2.0.2\r\nFinished Control File and SPFILE Autobackup at 15-08-2019_01:23:26\r\n\r\nRMAN> list backup of datafile 5 completed after \"sysdate - 3\/1440\";\r\n\r\n\r\nList of Backup Sets\r\n===================\r\n\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3572    Incr 1  40.00K     SBT_TAPE    00:00:02     15-08-2019_01:23:19\r\n        BP Key: 3573   Status: AVAILABLE  Compressed: YES  Tag: BKP-DBF5-INC1\r\n        Handle: VB$_4142545763_3571I   Media:\r\n  List of Datafiles in backup set 3572\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  5    1  Incr 1617208    15-08-2019_01:23:18              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n\r\nBS Key  Type LV Size       Device Type Elapsed Time Completion Time\r\n------- ---- -- ---------- ----------- ------------ -------------------\r\n3581    Incr 0  132.50K    SBT_TAPE    00:00:02     15-08-2019_01:23:19\r\n  List of Datafiles in backup set 3581\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  5    0  Incr 1617208    15-08-2019_01:23:18              NO    \/u01\/app\/oracle\/oradata\/ORCL18\/simon.dbf\r\n\r\n  Backup Set Copy #1 of backup set 3581\r\n  Device Type Elapsed Time Completion Time     Compressed Tag\r\n  ----------- ------------ ------------------- ---------- ---\r\n  SBT_TAPE    00:00:02     15-08-2019_01:23:19 YES        BKP-DBF5-INC1\r\n\r\n    List of Backup Pieces for backup set 3581 Copy #1\r\n    BP Key  Pc# Status      Media                   Piece Name\r\n    ------- --- ----------- ----------------------- ----------\r\n    3582    1   AVAILABLE                           VB$_4142545763_3576_5\r\n    3586    2   AVAILABLE                           VB$_4142545763_3577_5\r\n    3590    3   AVAILABLE                           VB$_4142545763_3578_5\r\n    3594    4   AVAILABLE                           VB$_4142545763_3579_5\r\n    3598    5   AVAILABLE                           VB$_4142545763_3580_5\r\n\r\nRMAN><\/pre>\n
Look that ZDLRA opened the incremental level that was sent (without section size) index it and after that generated a level 0 (that originally was done with section size) and created a virtual full backup correctly<\/p>\n
You can see here (Output-Full-Execution-Backup-Level-0-and-Backup-Level-1<\/a>) a full execution for backup level 0, subsequent levels 1, to verify the generation of virtual full backups and the incremental forever strategy. Check the SCN, creation times for backups 0 that appear in the list after I create a backup level 1.<\/p>\n
Virtual Full backup, Incremental forever, and Backup Strategy <\/h1>\n
Virtual full backups change completely the backup strategy for your database. The incremental forever strategy starts it the key point so save you for a lot of problems.<\/p>\n
If you start to check your backup strategy, there are a lot of details to verify. So, what it is your backup strategy? Full every weekend plus incremental every day? What it is the load for your backup appliance? And how many times do you pass doing the backup? If you have a huge database, maybe a full every weekend it is impossible, and you need to sparse in the month (1 time per month is feasible).<\/p>\n
But the most important, the time to recover and validate the backup? You need to restore the full (form last week as an example), and all the incremental + plus archives since that. This can be really time-consuming.<\/p>\n
But if you can do everything with a single incremental level 1 every day? You receive a full backup, that was validated by ZDLRA, and per datafile data you have. If ZDLRA detects corrupted blocks it advises you about that. The incremental forever strategy help in other places too. The overhead over the network decrease a lot (just pass incremental). The time consumption for CPU inside of database too.<\/p>\n
Now think the restore of the database. If you need to do one restore in the middle of the week you need to use the nearest level 0 that cover your request (probably done during the weekend) and apply some days incremental and archivelogs. For ZDLRA, you have one level 0 one day before available and just need to recover just a few archives.<\/p>\n
The base idea here is that ZDLRA it is the only appliance that delivers to you a backup full (virtual full backup, as they call) after every incremental backup that you do. This approach is called incremental forever. And even besides that, ZDLRA it is the only one that open correctly what rman sent to you (filesperset or no, section size, compressed or no) and verifies every block of datafile inside, index it, and deliver to you a validated backupset. And as you saw, in the examples before, everything related with catalog it is done automatically by ZDLRA (backup deletion and others).<\/p>\n
In the next post, I will show you more details about what\u2019s happens inside of ZDLRA when it receives the incremental backup. The internal tasks and where it\u2019s store the information about the virtual backups.<\/p>\n
 <\/p>\n
Disclaimer:<\/strong> \u201cThe postings on this site are my own and don\u2019t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications were removed to allow reach the generic audience and to be useful for the community. Post protected by copyright.\u201d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"
One of the most knows features of ZDLRA is the virtual full backup, basically incremental forever strategy. But what this means in real life? In this post, I will show some details about that and how interesting they are, check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. This post is […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[44,29,77,5,91,51],"tags":[100,105,65,92,104,74],"class_list":["post-562","post","type-post","status-publish","format-standard","hentry","category-backup","category-database","category-engineeredsystems","category-oracle","category-rman","category-zdlra","tag-engineered-systems","tag-incremental-forever","tag-oracle","tag-rman","tag-virtual-full-backup","tag-zdlra"],"yoast_head":"\nZDLRA, Virtual Full Backup and Incremental Forever - Fernando Simon<\/title>\n<meta name=\"description\" content=\"Check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. Check what's happens inside rman when you do that.\" \/>\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.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ZDLRA, Virtual Full Backup and Incremental Forever - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"Check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. Check what's happens inside rman when you do that.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2019-08-15T15:15:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-07-19T22:17:37+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\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.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"ZDLRA, Virtual Full Backup and Incremental Forever\",\"datePublished\":\"2019-08-15T15:15:35+00:00\",\"dateModified\":\"2020-07-19T22:17:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\"},\"wordCount\":1415,\"commentCount\":10,\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png\",\"keywords\":[\"Engineered Systems\",\"Incremental Forever\",\"Oracle\",\"rman\",\"Virtual Full Backup\",\"ZDLRA\"],\"articleSection\":[\"Backup\",\"Database\",\"Engineered Systems\",\"Oracle\",\"RMAN\",\"ZDLRA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\",\"name\":\"ZDLRA, Virtual Full Backup and Incremental Forever - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png\",\"datePublished\":\"2019-08-15T15:15:35+00:00\",\"dateModified\":\"2020-07-19T22:17:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"Check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. Check what's happens inside rman when you do that.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage\",\"url\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png\",\"contentUrl\":\"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fernandosimon.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ZDLRA, Virtual Full Backup and Incremental Forever\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\/\/www.fernandosimon.com\"],\"url\":\"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ZDLRA, Virtual Full Backup and Incremental Forever - Fernando Simon","description":"Check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. Check what's happens inside rman when you do that.","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.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/","og_locale":"en_US","og_type":"article","og_title":"ZDLRA, Virtual Full Backup and Incremental Forever - Fernando Simon","og_description":"Check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. Check what's happens inside rman when you do that.","og_url":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/","og_site_name":"Fernando Simon","article_published_time":"2019-08-15T15:15:35+00:00","article_modified_time":"2020-07-19T22:17:37+00:00","og_image":[{"url":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"25 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"ZDLRA, Virtual Full Backup and Incremental Forever","datePublished":"2019-08-15T15:15:35+00:00","dateModified":"2020-07-19T22:17:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/"},"wordCount":1415,"commentCount":10,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png","keywords":["Engineered Systems","Incremental Forever","Oracle","rman","Virtual Full Backup","ZDLRA"],"articleSection":["Backup","Database","Engineered Systems","Oracle","RMAN","ZDLRA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/","url":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/","name":"ZDLRA, Virtual Full Backup and Incremental Forever - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage"},"thumbnailUrl":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png","datePublished":"2019-08-15T15:15:35+00:00","dateModified":"2020-07-19T22:17:37+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"Check what it is Virtual Full Backup and Incremental Forever strategy for ZDLRA. Check what's happens inside rman when you do that.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#primaryimage","url":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png","contentUrl":"http:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2019\/08\/Virtual-Full.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/zdlra-virtual-full-backup-and-incremental-forever\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ZDLRA, Virtual Full Backup and Incremental Forever"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-94","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/562","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=562"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/562\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=562"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=562"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=562"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}