PowerProtect | How to do Oracle backups using Operating system authentication with PowerProtect Data Manager

Summary: This article explains how to setup Oracle Operating system Authentication with PowerProtect Data Manager.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.

Instructions

Instructions:

1) Log in to the Oracle Host.
2) Verify that your Database supports OS authentication as below
sqlplus /nolog

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Feb 17 07:44:56 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.

SQL> connect / as sysbackup
Connected.

3) (Optional) Set ORACLE_OS_USER  for each required SID in the rman_agent.cfg configuration file
  ( "/home/oracle/opt/dpsapps/rmanagent/config" is the default location)

For example, The rman_agent.cfg  file includes the following settings to enable OS authentication for the database SID orcl:
[SID_orcl]
ORACLE_OS_USER = oracle
For any supported Oracle version in a stand-alone or RAC system, SID_name must match the SID that runs on the local host.

Then, Save the file.

4) Restart the agent on the Oracle Host as root
systemctl restart agentsvc

5) Create a Credential in PowerProtect Data Manager for the OS user by clicking on Administration>Credentials>Add

11.png


6) Create a Protection Policy in PowerProtect Data Manager by clicking on Protection>Protection Policies>Add.
7) Click on "Set Credentials"

2.png

8) Select "OS User" and Select the Credential created previously.
9) Run a test backup to check the configuration is OK

Additional Information

Please refer to this video:
Article Properties
Article Number: 000196402
Article Type: How To
Last Modified: 14 Dec 2022
Version:  6
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.