Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Backup/Restore of Oracle Database Part 2 of 3- Creating Backup Policy and taking Full Backup

Created: 25 Jun 2013 • Updated: 08 Jul 2013
Language Translations
ashi's picture
+11 11 Votes
Login to vote

How to create backup policy for Oracle database and taking online Full backup

Environment:

  • Netbackup Server 7.1 on Windows Server 2003
  • Oracle  on Windows Server 2003

This document is second part of (Backup/Restore of Oracle Database).In this article I will explain how to create policy in Netbackup and taking backup of oracle databases.

1- Open NBU admin console and click on Policies to create New Policy ….

1.jpg

2- Add policy name, same policy will be used for Full and Incremental Backup. Let us name this “HCIS_FULL”

2.jpg

3- For a New Policy in NBU we have four tabs.(Attributes, Schedule, Client, Backup Selection)

In the Attribute tab set the following.

Policy Type: Oracle

Policy Vol Pool: Test oraDB1 (You can use any volume pool or DSU)

3.jpg

4- In the Schedule tab keep the Default Application Backup selected and add a new Schedule for Full and Incremental backups

4.jpg

5- For New Schedule set the following

Name: HCIS_Full

Type of Backup: Automatic Full Backup

Frequency: 1 Weeks - for full backups (you can change this setting according to your requirements)

5.jpg

6- In Start Window Tab we can schedule the Backup to run at particular date and time.

6.jpg

7- Now we have set the schedule for the Full Backup up.

Note: for our testing purposes we will run it manually.

7.jpg

8- In the Schedules add another Schedule for Incremental Backup.

8.jpg

9- Now we have scheduled for both full and Incremental backup.

9.jpg

10- Now select the oracle client whose backup is required

10.jpg

11- Now select the ‘Backup Selections’ Tab to select the ‘script’ which we have created from the client machine and saved it on the NBU7 Server.

Select the blue button on upper right hand corner and select the template.

‘hcis_template.tpl’

11.jpg

12- Now we have to run the backup policy. ‘HCIS_FULL’

We will do the Manual Backup…

13.jpg

17.jpg

13- Status showing that the Backup is completed successfully.

18.jpg

14- Sample output of backup template

14.jpg15.jpg16.jpg

In next article we will perform restoration activity of Oracle database.