Welcome to Dell Technologies PowerProtect Data Manager 19.x How to Series.
How to perform an Oracle backup using Database authentication. Reference Dell Knowledge Article number 196330. This video illustrates how to perform Oracle backups using Database authentication.
This video presents the general steps that will be accomplished. Log in to the Oracle box. Connect to Oracle and create a user with the privileges needed to do backups.
Add the user to PowerProtect Data Manager Lockbox. Add the user to PowerProtect Data Manager User Interface. Create a Protection Policy, and run a test backup.
This process should be followed when there is a need to do Oracle backups using Database authentication. Before you begin, have admin credentials for PowerProtect Data Manager User Interface.
Have root credentials for the Oracle box. Have IP and Fully Qualified Domain Name for the Oracle box and PowerProtect Data Manager, and have Oracle sys user credentials.
Log in to the Oracle box. Switch to Oracle. Set the variables needed to connect to Oracle using SQL*Plus. Run "sqlplus". Connect to Oracle using user sys.
Create user "ppdmbackup" and assign to it "SYSDBA" and connect privileges. Also assign "SYSBACKUP" if Oracle is Version 12 or later.
Connect to Oracle with user "ppdmbackup" to make sure the user was created properly. Change to the RMAN plugin bin directory, and run "ddutil" to set the Oracle user in the Lockbox.
Change to the RMAN plugin config directory and "vi" file "rman_agent.cfg". Create an entry for the database specifying the Oracle user "ppdmbackup" and the Oracle service name.
Exit Oracle and, as root, restart PowerProtect Data Manager Agent. Go to PowerProtect Data Manager UI and create a credential type "DBUSER" for "ppdmbackup" Oracle user.
Go to "Protection" and create a new Protection Policy. Click on "Set Credentials" and select the credentials previously created using "ddutil".
Also set "Oracle Service Name" and, optionally, "TNS File Location", if it is not default. Select the Oracle database being set up.
Add the "Primary Backup" details needed for this Protection Policy and complete the creation of the Protection Policy. Select the newly created Protection Policy and run a test backup.
Click on "View Details" and monitor the backup until it completes successfully. It should be possible to set up Oracle backups using Database authentication after completing this video. Reference the following for more information: KB 196330.
Thank you for watching.