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.
-
- Novice
- Posts: 3
- Liked: 1 time
- Joined: May 22, 2024 6:00 pm
- Contact:
-
- 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
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
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
-
- Veeam Software
- Posts: 3815
- Liked: 643 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
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!
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!
-
- 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
Thanks Petr,
I figured as much from my trial and error approaches. Just needed to verify this.
Thanks!
I figured as much from my trial and error approaches. Just needed to verify this.
Thanks!
Who is online
Users browsing this forum: No registered users and 1 guest