• EN
Question

Restore from Backup Copy to Another Server

J

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

 

5 comments

JMeixner
Userlevel 7
Badge +17

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.

Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2023 | Veeam Certified Architect (VMCA) 2022 | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
J

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
 

JMeixner
Userlevel 7
Badge +17

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/

Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2023 | Veeam Certified Architect (VMCA) 2022 | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
Andanet
Userlevel 7
Badge +10

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 

Antonio D'Andrea | VCP6-DCV | VMCE 2021 | VMCA 2022 | VMTSP2023 | Veeam Legend 2023 | VUG Italy Leader | I want it written on my tombstone "Please start a restore to the last valid backup"
JMeixner
Userlevel 7
Badge +17

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

I think this will be the cause of the problem.

Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2023 | Veeam Certified Architect (VMCA) 2022 | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social

Comment


Terms & Conditions