{"id":679,"date":"2020-02-21T16:40:09","date_gmt":"2020-02-21T19:40:09","guid":{"rendered":"http:\/\/www.fernandosimon.com\/blog\/?p=679"},"modified":"2020-07-19T19:12:03","modified_gmt":"2020-07-19T22:12:03","slug":"zdlra-manual-clone-to-tape","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/zdlra-manual-clone-to-tape\/","title":{"rendered":"ZDLRA, Manual Clone to Tape"},"content":{"rendered":"

In my previous post<\/a>, I showed how the clone to tape occurs for ZDLRA. But as explained, the clones occur through the scheduler and follow some rules. For full backup, as an example, it clones the last available.<\/p>\n

But sometimes,  it is needed to call the clone for some specific backup, maybe to do long-term storage to follow some regimentation\/law. And if we leverage this for the clone, jobs can maybe take to long, or clone more that you need.<\/p>\n

<\/p>\n

Manual Clone<\/h2>\n

It is possible to clone one backup piece directly using CLI at ZDLRA. But we need to specify backup piece per backup piece since the parameter is the bp_key. But before clone, I recommend identifying some important things.<\/p>\n

The first is the database key inside the rman catalog. A simple list db_unique_name<\/em> show this:<\/p>\n

RMAN> list db_unique_name of database ORCL18C;\r\n\r\n\r\nList of Databases\r\nDB Key  DB Name  DB ID            Database Role    Db_unique_name\r\n------- ------- ----------------- ---------------  ------------------\r\n15993   ORCL18C  558466555        PRIMARY          ORCL18C\r\n\r\nRMAN><\/pre>\n
The second is to identify the backupset and the backup piece that you need to clone. In this case, I picked up one from SYSTEM tablespace:<\/p>\n
RMAN> list backupset 16512;\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\n16512   Incr 0  330.35M    SBT_TAPE    00:03:03     02\/02\/2020 16:12:04\r\n        BP Key: 16513   Status: AVAILABLE  Compressed: YES  Tag: BKP-DB-INC0\r\n        Handle: VB$_1891149551_16507I   Media:\r\n  List of Datafiles in backup set 16512\r\n  File LV Type Ckp SCN    Ckp Time            Abs Fuz SCN Sparse Name\r\n  ---- -- ---- ---------- ------------------- ----------- ------ ----\r\n  1    0  Incr 1909028    02\/02\/2020 16:09:01              NO    \/u01\/app\/oracle\/oradata\/ORCL18C\/system01.dbf\r\n\r\nRMAN><\/pre>\n
Other are related inside ZDLRA database and are the protection policy linked with the database doing select over ra_database table:<\/p>\n
SQL> select policy_name, db_key, db_unique_name from ra_database where db_unique_name = 'ORCL18C';\r\n\r\nPOLICY_NAME                                            DB_KEY DB_UNIQUE_NAME\r\n-------------------------------------------------- ---------- --------------------------------\r\nZDLRA_ONLY_TAPE                                         15993 ORCL18C\r\n\r\nSQL><\/pre>\n
And to finish it needed to discover the template it is associated with the protection policy:<\/p>\n
SQL> set linesize 250\r\nSQL> col LIB_NAME format a30\r\nSQL> col TEMPLATE_NAME format a50\r\nSQL> col LAST_SCHEDULE_TIME format a35\r\nSQL> col POLICY_NAME format a50\r\nSQL> select TEMPLATE_NAME, BACKUP_TYPE, LAST_SCHEDULE_TIME, LIB_NAME, DB_UNIQUE_NAME, POLICY_NAME FROM RA_SBT_JOB WHERE LIB_NAME = 'OSBSBT' and POLICY_NAME = 'ZDLRA_ONLY_TAPE' ;\r\n\r\nTEMPLATE_NAME                                      BACKUP_TYPE      LAST_SCHEDULE_TIME                  LIB_NAME                       DB_UNIQUE_NAME                 POLICY_NAME\r\n-------------------------------------------------- ---------------- ----------------------------------- ------------------------------ ------------------------------ --------------------------------------------------\r\nONLYTAPE_FULL_ARCH                                 FULL, ARCH       02-FEB-20 04.40.37.077769 PM +01:00 OSBSBT                                                        ZDLRA_ONLY_TAPE\r\nONLYTAPE_ARCH                                      ARCH                                                 OSBSBT                                                        ZDLRA_ONLY_TAPE\r\n\r\nSQL><\/pre>\n
COPY_BACKUP_PIECE<\/h2>\n
The information collected before it is important because it is needed to use the DBMS_RA.COPY_BACKUP_PIECE<\/a> procedure.<\/p>\n
The parameter for the usage:<\/p>\n