Skip to main content
  • EN

Hello,

I need support to restore an Oracle base via RMAN with the Oracle Plugin on another server.
Running the command below returns the following message:

[oracle@oracle01]<ORACLEBKP> #OracleRMANConfigTool --configure-restore-from-copy
You will be unable to run RMAN backups while "Restore from copy" mode is enabled. Proceed with enabling?  (y/N): y
No secondary destination jobs available
>oracle@oracle01]<ORACLEBKP> #

I followed the directions in the link:
https://helpcenter.veeam.com/docs/backup/plugins/restore_from_copy.html?ver=110

Can anyone help me please?

Regards,

Jackson

 

Hello @Jackson ,
did you see this forum thread?

https://forums.veeam.com/veeam-backup-replication-f2/rman-plugin-restore-to-another-server-from-backup-copy-t66949.html

You have to configure this option on the source server.

Hello JMeixner,

I did the configuaration on the source serve and return same message “No secondary destination jobs available”

And I copied the RMAN files that are on the Veeam backup server to the server I want to restore and when running RMAN the following situation occurred:

RMAN> RESTORE CONTROLFILE from '/u02/transfer/bkp_veeam/BKP_CTL_LROPRD05_c-641222631-20230207-11_RMAN_AUTOBACKUP.vab';

Starting restore at 10-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=578 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/10/2023 17:31:29
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
 

Hello,
I did not see this problem in my environments up to now.

There is another forum thread:

https://forums.veeam.com/veeam-backup-replication-f2/veeam-vab-rman-plugin-files-t77653.html

And here is explained how to confugure autobackup location.

https://ittutorial.org/rman-06172-no-autobackup-found-or-specified-handle-is-not-a-valid-copy-or-piece/amp/

Hello JMeixner,

I did the configuaration on the source serve and return same message “No secondary destination jobs available”

And I copied the RMAN files that are on the Veeam backup server to the server I want to restore and when running RMAN the following situation occurred:

RMAN> RESTORE CONTROLFILE from '/u02/transfer/bkp_veeam/BKP_CTL_LROPRD05_c-641222631-20230207-11_RMAN_AUTOBACKUP.vab';

Starting restore at 10-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=578 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/10/2023 17:31:29
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
 

Hi @Jackson  backup and restore with Oracle have a lot of issue due to different database configuration. This error is related with the CONTROLFILE AUTOBACKUP location, configure it where your Controlfile backups located.

I think you can check, with correct path, and change Controlfile. 

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rman/%F';

 

Let me know if this can help you.

Thanks 

😏 this is exactly what I have written in my last comment.

I think this will be the cause of the problem.

Comment


Terms & Conditions