HowTo perform brtools/Oracle RMAN Backup to disk on Azure?

Question

HowTo perform brtools/Oracle RMAN Backup to disk on Azure?

otaviopc 5

Hello!

Please, is there a best way to perform brtools/Oracle RMAN Backup to disk on Azure?

This is my actual scenario:

Azure Virtual Machine - V2

Windows Server 2016

Oracle Database 19.8.0.0.0

SAP DW

I am trying to perform RMAN backup to Azure FileStorage mapped as Unit Y:\ but i am facing the error:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on dsk channel at 03/27/2023 12:36:16

ORA-19504: failed to create file "Y:\SR3USR.DATA1.S"

ORA-27037: unable to obtain file status

OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

O/S-Error: (OS 2) The system cannot find the file specified.

Any suggestion?

Could be a Security issue?

Thanks in advance.

Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2023-03-30T17:33:38.2533333+00:00

@otaviopc Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2023-04-08T02:03:08.0266667+00:00

@otaviopc Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

2 answers

Your answer

Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2023-03-30T17:33:38.2533333+00:00

@otaviopc Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2023-04-08T02:03:08.0266667+00:00

@otaviopc Just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 1

Hello there,

This article demonstrates the use of Azure Files as a media to back up and restore an Oracle database running on an Azure VM. The steps in this article have been tested against Oracle 12.1 and higher. You will back up the database using Oracle RMAN to an Azure file share mounted to the VM using the SMB protocol. Using Azure Files for backup media is extremely cost effective and performant. However, for very large databases, Azure Backup provides a better solution.

https://learn.microsoft.com/en-us/azure/virtual-machines/workloads/oracle/oracle-database-backup-azure-storage?tabs=azure-portal

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer--

Answer 2

Rakesh Gopal 0

I followed the article to setup Azure fileshare & was able to successfully mount it to my Windows VM and i even tested manually creating a text file. However while i perform a Rman backup i run into the same issue as the user above.

ORA-27037: unable to obtain file status

OSD-04011: GetFileInformationByHandle() failure, unable to obtain file info

O/S-Error: (OS 2) The system cannot find the file specified.

Sumarigo-MSFT 47,466 Reputation points Microsoft Employee Moderator

2024-09-02T09:14:21.8966667+00:00

@Rakesh Gopal Please create a new thread so we can follow up there. Kindly share the complete details of the issue, including any error messages or codes you may be receiving. If possible, please also provide a screenshot.

https://learn.microsoft.com/en-us/answers/questions/ask/

Share via

HowTo perform brtools/Oracle RMAN Backup to disk on Azure?

2 answers

Your answer