Problem description

This article provides the troubleshooting steps to the common issues that occur while configuring backup for Oracle with Phoenix on Windows.

Prerequisites for Windows Server to configure Oracle backup

On the Windows Server:

Install the Network File System.
Enable Direct NFS Client for Oracle.
Enable write permissions for the anonymous user on the Windows Server.
Set up the curl utility on the Windows Server.

Reference: Backup Oracle databases using RMAN hosted on a Windows Server

Scenarios

Different scenarios are discussed in the sections below.

Script execution fails if cURL utility on the Windows Server is not set correctly

Example:

E:\Oracle_Scripts>oracle_rman_backup.bat E:\RMAN_Logs 172.16.53.171 DB5

E:\Oracle_Scripts>echo off
'curl' is not recognized as an internal or external command,
operable program or batch file.
Request to validate backup failed, exiting
Response from Phoenix Backup Store ~1,-1

Resolution

Set the cURL utility correctly on the Windows Server. See How do I set up cURL on Windows section for configuration steps.

RMAN backup fails with "O/S-Error: (OS 5) Access is denied"

RMAN back fails with the OS error - (OS 5) Access is denied. If write permissions for anonymous user is not seton Windows Server.

Example:

Error in the RMAN logs :
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/28/2019 02:12:
34
ORA-19504: failed to create file "\\172.16.53.171\PHOENIX\NISHESHDB5\ORACLE_DATA
\FULL\FULL_BK_DATAFILE_23TTHHKH_1_1.RBK"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

Recovery Manager complete.
The system cannot find the file specified.
RMAN backup failed. Check RMAN log E:\RMAN_Logs\rman_full_backupThu_03_28_2019_0
2_12_AM.log for the details

Resolution

Enable write permissions for the anonymous user on the Windows Server. With the write permissions, the anonymous user can write data on the backup mount of the Phoenix Backup Store. To enable write permissions for the anonymous user:

Run regedit to start the Registry Editor.
On the Registry Editor, navigate to the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ClientForNFS\CurrentVersion\Default folder in the left pane.
Create two DWORD 32-bit values in the folder. The two values create a user and group ID for the anonymous user who can write to the backup mount on the Phoenix Backup Store. To create the values:
1. In the right-pane, right-click and then select New > DWORD 32-bit value.
2. Specify the name as AnonymousGID and ensure that its value is either 0 or it matches the GID of the root user on the Phoenix Backup Store and its base is decimal.
3. In the right pane, right-click and then select New > DWORD 32-bit value again.
4. Specify the name as AnonymousUID and ensure that the value is either 0 or it matches the UID of the root user on the Phoenix Backup Store and its base is decimal.
Close the Registry Editor and restart the Windows Server.

RMAN backup fails with Permission denied error

RMAN backup fails with Permission denied error if the NFS client service is either not installed or is not running.

Resolution

Install the Network File System, using the steps described in Install Network File System section.

Restart NFS service using the steps below:

PS C:> nfsadmin.exe client stop

The service was stopped successfully.

PS C:> nfsadmin.exe client start

The service was started successfully.

E:\Oracle_Scripts>net start nfsclnt

The Client for NFS service is starting.

The Client for NFS service was started successfully.

RMAN backup fails with O/S-Error:(OS 58)

RMAN Backup fails with the following OS error.

O/S-Error: (OS 58) The specified server cannot perform the requested operation.

Traceback:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/18/2019 13:24:26
ORA-19504: failed to create file "\\ip.xx.5.xx\PHOENIX\DGFSERVER001\ORACLE_DATA\FULL\FULL_BK_DATAFILE_48TSOD88_1_1.RBK"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 58) The specified server cannot perform the requested operation.

Resolution

Verify if the user running RMAN has permission to create and edit the File/Folder on the Target path at Phoenix backup store .
Try to create a file/folder and edit it at the target path.
Verify if there is enough space at target path.
Try running just the script (rman_backup_windows.rman ) from the Oracle command line and verify if it works. If it fails the issue lies at the Oracle RMAN end.
```
rman cmdfile rman_backup_windows.rman
```
Restart the Windows server after making the Registry changes in STEP 2.

If the Issue persists contact Druva Support.

References

Troubleshooting Phoenix Backup Store issues

Oracle errors

Troubleshooting common Phoenix Backup Store issues

Oracle PBS backup failing with error ORACLE31

Playbook - How to Collect logs and troubleshoot Oracle PBS and Oracle DTC issues