cancel
Showing results for 
Search instead for 
Did you mean: 

oracle & other open files

SOLVED
Go to solution
Rick Garland
Honored Contributor

oracle & other open files

Hi all:

This question is a cross between Oracle database files and the backup application(s) - in this case, Data Protector 5.00

I do not have the OFM module installed into DP and I have seen where open files are not sent to tape for backups.

For Oracle, I do not use RMAN. I interact with the database directly to put the tables in backup mode and to take out of backup mode when the backup is complete.

What is it that Oracle is doing to the files in backup mode to allow DP to get them on tape? As opposed to other open files DP will not bother with (no OFM module).
3 REPLIES
Duncan Edmonstone
Honored Contributor
Solution

Re: oracle & other open files

 

HTH

Duncan
Rick Garland
Honored Contributor

Re: oracle & other open files

Hi Duncan:

Get info. The key point I was looking for is the SCN piece.

Many thanks!
A. Clay Stephenson
Acclaimed Contributor

Re: oracle & other open files

Hi Rick:

Your other option is to actually use OFM. Shutdown the database; allow OFM to "synchronize" - their term, not mine; and then restart the database. This is an easy pre-exec script. This process takes less than two minutes (one minute is common) and you then have all the benefits of a nice, cold backup with almost all the uptime of a hot backup.

Food for thought, Clay.
If it ain't broke, I can fix that.