Case #07213151 — Running RMAN duplicate target database

[lion_dba]

All,

I am attempting to use the Oracle RMAN function "duplicate target database to <TARGET_DB>"
This is used for cloning PROD to non-PROD instances.
Has anyone used this function with the VEEAM RMAN plugin for oracle: libOracleRMANPlugin.so

thanks
JCP

[PetrM]

Hi James and Welcome to Veeam R&D Forums!

I don't see any reason why it would not work. Did you try it already and what was the result?

Thanks!

[Andreas Neufert]

You can maybe check this one to get an idea of the overall processing steps.
https://oracle-base.com/articles/11g/du ... rman-11gr2

Then as well check this one
https://github.com/VeeamHub/application ... restore.sh
and this one
https://helpcenter.veeam.com/docs/backu ... ml?ver=120
that describe restore of databases to other system/databases.

[lion_dba]

I am familiar with rman.
Here is my current script:

rman nocatalog << END
connect target sys/xxxxxxx@CDEV1
connect auxiliary /
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 6;
CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE;
CONFIGURE CHANNEL DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F_RMAN_AUTOBACKUP.vab';
run {
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F_RMAN_AUTOBACKUP.vab';
ALLOCATE auxiliary CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
ALLOCATE auxiliary CHANNEL VeeamAgentChannel2 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
ALLOCATE auxiliary CHANNEL VeeamAgentChannel3 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
ALLOCATE auxiliary CHANNEL VeeamAgentChannel4 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
ALLOCATE auxiliary CHANNEL VeeamAgentChannel5 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
ALLOCATE auxiliary CHANNEL VeeamAgentChannel6 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
SEND 'srcBackup=5c96e606-c22a-461f-8ce1-2bacb05a57d8';
set until logseq 614 thread 1;
duplicate target database to CUPG;
}
END


---------------------------------------
Here are the errors I get: (note: source is: dayod03.lionapparel.local target is:dayupg03.lionapparel.local

Starting restore at 09-APR-24

channel VeeamAgentChannel1: starting datafile backup set restore
channel VeeamAgentChannel1: restoring control file
channel VeeamAgentChannel1: reading from backup piece c-3981166106-20240405-00_RMAN_AUTOBACKUP.vab
channel VeeamAgentChannel1: ORA-19870: error while restoring backup piece c-3981166106-20240405-00_RMAN_AUTOBACKUP.vab
ORA-19507: failed to retrieve sequential file, handle="c-3981166106-20240405-00_RMAN_AUTOBACKUP.vab", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
Job [dayupg03.lionapparel.local Oracle backup (VMDAYLHR01 - Dayton non-Immutable Repository)] does not exist and will not be created
--t
failover to previous backup

released channel: VeeamAgentChannel1
released channel: VeeamAgentChannel2
released channel: VeeamAgentChannel3
released channel: VeeamAgentChannel4
released channel: VeeamAgentChannel5
released channel: VeeamAgentChannel6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/09/2024 16:38:05
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

[PetrM]

Hi James,

Looks like it tries to find a job, does not find it, and fails to create the job in Veeam B&R. I cannot explain it based on the error above only, we need to research this behavior.

Are you using version 12.1 ? The job is no longer required for restore in the latest version.

Also, please do the following:
1. Try to go over the workflow shared above by Andreas and inform us about the result (it will help to isolate the issue)
2. Please open a support case and provide a case ID so that we can keep an eye on it

Thanks!

[Andreas Neufert]

Maybe the second system does not have access to the backup yet.
In general systems do not have access to others systems backups for security reasons.
So you need to set as well the user or recovery token in a way that it will find the backup of the other server.

https://helpcenter.veeam.com/docs/backu ... ml?ver=120

[amedward4]

Hi,

Don't know if you are still facing the same issue or not. We had the same issue with duplicate and were able to resolve it.
It looks like the duplicate allocates channels again in a different run block and those channels did not have the recovery key that we had passed when we allocated the channels in the first part of the script.
So, instead of using a send after the allocate of the channels, we passed the SEND information in the initial allocate channel command.

Instead of this where we got the same errors you had....
ALLOCATE AUXILIARY CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
ALLOCATE AUXILIARY CHANNEL VeeamAgentChannel2 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so';
SEND 'srcBackup=5a4abe09-2207-4e9f-968e-bbc99a6a8ad0';
duplicate target database to DBADBC nofilenamecheck;

We used this and it worked....
ALLOCATE AUXILIARY CHANNEL VeeamAgentChannel1 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' SEND 'srcBackup=5a4abe09-2207-4e9f-968e-bbc99a6a8ad0';
ALLOCATE AUXILIARY CHANNEL VeeamAgentChannel2 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/opt/veeam/VeeamPluginforOracleRMAN/libOracleRMANPlugin.so' SEND 'srcBackup=5a4abe09-2207-4e9f-968e-bbc99a6a8ad0';
duplicate target database to DBADBC nofilenamecheck;

Thanks.