Oracle Full Backup

[estech25]

I have created an ORACLE type policy on my master server and it has schedules to allow full and incremental backups during the night and another schedule for manual backups during the day. I have also installed NBU Oracle Agent on the Oracle server and have tested the manual backup from Oracle (client-directed backup) and it works fine. But the problem is that the master server never starts any Full or incremental backups of the oracle server automatically.
Am I doing everything right? Should the master server start full backups automatically during the night? Is it enough to create a policy? Do I have to do anything else to make the master server start automatic full and incremental backups? All I want is having automatic backups from my Oracle server.

 

[comtec17]

Did you create the script file and add it to your directives?

 

[estech25]

no. I don't know about the script file. Is the script file only necessary for Oracle Full automatic backups? Because other forms of full backup work automatically on my master server. It's only Oracle full automatic backup that I am having problems with

 

[comtec17]

This script is required for both Cold and Hot backups. Read the Oracle Agent Users Guide as this will point you in the proper direction.

 

[Stumpr]

There are at least two ways to schedule the backups

1. create a user_directed backup and run from the client using cron or any other scheduler that is available run the script to place the database in backup mode and do the backup.

2. create an oracle backup and include the full pathname of the script that will be running the Oracle backup in the filelist.

whichever route you take you will still need the Oracle scripts. NetBackup simply provides the tape for the Oracle backup. NetBackup is simply a receiver. The actual database manipulation and creation of threads is done via the Oracle scripts.


Bob Stump
Incorrigible punster -- Do not incorrige