Backup of enterprise applications (Microsoft stack, IBM Db2, Oracle, PostgreSQL, SAP)
Post Reply
samorb
Novice
Posts: 3
Liked: 1 time
Joined: May 22, 2024 6:00 pm
Contact:

Incremental level 1 for recover of copy always uses disk channel

Post by samorb »

Is there a way to have incremental backups create a copy and roll it forward without channel disk?
For example:
RECOVER COPY OF DATABASE WITH TAG 'INCR_BACKUP' UNTIL TIME 'SYSDATE-5';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'INCR_BACKUP' DATABASE PLUS ARCHIVELOG;

Thanks.
samorb
Novice
Posts: 3
Liked: 1 time
Joined: May 22, 2024 6:00 pm
Contact:

Re: Incremental level 1 for recover of copy always uses disk channel

Post by samorb »

Here is some more context

RMAN config is:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F_RMAN_AUTOBACKUP.vab';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' FORMAT 'c976f55c-f6cb-45ce-9e85-25a6c96e730b/RMAN_%I_%d_%T_%U.vab';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

RMAN script is:

run {
ALLOCATE CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE
PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so'
FORMAT 'c976f55c-f6cb-45ce-9e85-25a6c96e730b/RMAN_%I_%d_%T_%U.vab';
RECOVER COPY OF DATABASE UNTIL TIME 'SYSDATE-5';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY DATABASE PLUS ARCHIVELOG;
BACKUP AS COPY CURRENT CONTROLFILE;
BACKUP SPFILE;
}

The copies of the datafiles are being written to disk, specifically the FRA location.
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/190000/dbs/snapcf_CDBROOT.f'; # default
PetrM
Veeam Software
Posts: 3329
Liked: 539 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Incremental level 1 for recover of copy always uses disk channel

Post by PetrM »

Hello,

Are you talking about Oracle Incremental Merge? If yes, it's currently not possible with our plug-in because image copy creation is not supported for SBT_TAPE channels by Oracle itself. However, we research different options to support this scenario and probably would be able to do that in one of our future releases, but I cannot comment on ETA.

Thanks!
samorb
Novice
Posts: 3
Liked: 1 time
Joined: May 22, 2024 6:00 pm
Contact:

Re: Incremental level 1 for recover of copy always uses disk channel

Post by samorb » 1 person likes this post

Thanks Petr,

I figured as much from my trial and error approaches. Just needed to verify this.

Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest