Operating System - HP-UX
1745909 Members
4182 Online
108723 Solutions
New Discussion юеВ

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 3
Solution

Re: oracle & other open files

 

I am an HPE Employee
Accept or Kudo
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.