Configuring Oracle 12c backups on Veritas Backup Exec 16.

-

This is a short guide to configuring backups of Oracle 12c using Veritas Backup Exec 16.

1.       Establish trust with Oracle Database server within Backup Exec console and ensure agent is installed.

2.       Create a login to the database for backup purposes in Oracle;
Open up a command prompt and run the following command –
Sqlplus /nolog
Log in with your database admin account as sysdba
Connect myusername/mypassword@databasename as sysdba
CREATE USER BACKUP IDENTIFIED BY MYPASSWORD;
GRANT UNLIMITED TABLESPACE TO BACKUP;
GRANT AQ_ADMINISTRATOR_ROLE TO BACKUP;
GRANT DBA TO BACKUP;
GRANT CONNECT TO BACKUP;
ALTER USER BACKUP DEFAULT ROLE ALL;
ALTER USER BACKUP DEFAULT TABLESPACE SYSTEM;

3.       Within the Local Users and Groups section of Computer Management on the Oracle database server, add the backup servers windows domain administrator account to the following groups –
a.       ORA_OraDB12Home1_SYSBACKUP
b.      ORA_DBA  Not sure if this is strictly necessary

4.       Open the Veritas Backup Exec Agent Utility
a.       Under the Oracle tab, ensure you add the following;
                                                               i.      Instance name
                                                             ii.      Local oracle user created in step 2
                                                            iii.      Hostname of Backup Server

b.      Under the Database Access Tab, type in the windows domain administrator account which was added in step 3 to the local security groups.


5.       Adding the Oracle Server Name
a.       Within Backup Exec, go into the setting section labelled ‘Backup Exec Settings’.

b.      Within the Oracle Section, add in the server name and use the windows domain administrator credentials supplied in step 4b.



6.       Add the Credentials of the Oracle Backup User (which was added in step 2) to the credentials section within Backup Exec


7.       Create a new backup job.
a.       In the credentials selection, expand the Oracle icon to show a list of the actual databases. Ensure that the logon account used is the account created in Step 6.

b.      Proceed to configuring the remainder of the backup.


I’m not so sure why Veritas decided to make this procedure so disjointed. It took  a fair few hours to get this far due to the local of documentation I could find. 

Provided without any warranty.

Hope it works for you.

References;
https://www.veritas.com/support/en_US/article.000038273


Comments

  1. affu jani17 September 2021 at 10:31

    Veritas Backup Exec
    I am very impressed with your post because this post is very beneficial for me.

    ReplyDelete

Post a Comment

Popular posts from this blog

Create bootable CUC CUCM CUP Image / ISO

-
The following script allows you to automatically create a bootable CUCM/CUC/CUP image without the need for any paid for software when you only have access to the update outside of put or the datastore for the new server. I have spent several hours on this, but I just wanted to make it simple. Only really for lab purposes, the checksum will fail due to the ISO being manipulated but essentially once you fill in the variables, you will just be left with a single ISO file in the staging directory. To use; 1. Download the mkisofs.exe file as described in the script 2. Paste script below into Powershell ISE Script Editer 3. Modify the variables 4. Execute the script. Simple. Tested creating an ISO on a Windows 10 machine and running the ISO on a ESXI server. Thanks for this guy Aaron Harrison as per the URL, was helpful in the finding out the mkisofs.exe command syntax. http://www.ipcommute.co.uk/technical-articles/17--creating-isolinux-boot-dvds-with-free-software-cucm-uccx-c...
Read more

Configuring Cisco CME Voice Gateway (VG) for incoming and outgoing calls using Sipgate trunk

-
Image
Hi All For my reference and your's, here is a working sample configuration for configuring sipgate (sipgate.co.uk) for incoming and external VOIP calls on a 2800 series Cisco router. Using GNS3; My wireless adapter has internet connection sharing enabled, and I have created a loopback adapter which is the 'internet' adapter as you can see below. I have tested making calls using Cisco's CIPC version 8 and receiving calls. This doesn't have to be done in GNS3, just pick up yourself a real voice gateway. version 12.4 service timestamps debug datetime msec service timestamps log datetime msec no service password-encryption ! hostname VG-EP ! boot-start-marker boot-end-marker ! ! aaa new-model ! ! aaa authentication login http local aaa authentication login ssh local aaa authorization exec http local ! aaa session-id common ! resource policy ! memo...
Read more