Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

oracle & other open files

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).
Duncan Edmonstone
Honored Contributor

Re: oracle & other open files



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.