Backup Exec 12-SP3 stopping Oracle instances

[P__Moss]

I have a Windows 2003 - SP2 server which is running Oracle 10.2. During the daily backup, Oracles instances are stopped, generating these messages  : 

• In the Windows Error Log : 
  Instance sig has been terminated.
  
• In the Oracle Alert Log : 
  CKPT: terminating instance due to error 221
  Sat Oct 17 00:16:28 2009
  Errors in file d:\oracle\product\10.2.0\admin\sigsat\bdump\sig_pmon_592.trc:
  ORA-00221: error on write to control file

The Agent for Oracle is not installed on this server since our DBA configured rman to backup the databases.

Thanks in advance for your suggestions,

P.M.

[Skyhigh]

P.M,

We had the same problem. Basically Backup Exec and Oracle are conflicting and Oracle stops the instance. Here's how we got around the problem (we use Windows but I guess you can do the same for Unix etc)

Create a .cmd file that does the following:

1. Stop the Oracle services
2. Make a copy (we use robocopy) of the Oracle folder  to another folder.
3. Start the Oracle services
4. (Optional) Unload your data to a flat file

Now create a scheduled task to run the above .cmd file at a convenient time prior to your backup job starting.

Now what you do is exclude the Oracle folder from your backup selection and only backup the folder you copied it to.

This has worked fine for us.

Skyhigh

[CraigV]

Hi,

Without an agent, you won't be able to backup the live database, and you'd have to go the flat-file route, hoping that AOFO is able to do that.
Otherwise go with what Skyhigh mentioned above.