There are several ways to avoid having an Oracle database crash. And, believe it or not, 99% of them can be avoided, by following a few simple steps.
The two leading causes of an Oracle database crash are:
1) Virus Detection Software - We see this one the most! When your virus detection is installed, its on-access scanner must exclude the Oracle live database files. If Oracle detects that there is a lock on one of its files while the virus detection software is scanning the file, the database will close to protect the integrity of the data. Each virus detection software package has a method to exclude certain directories. Just add your Oracle database directory to be excluded and you should be able to avoid this problem.
2) Backup software - We see this one often! A site might be using their backup software to do a file system backup of the open database files. When Oracle attempts to write to the file that is being backed up, Oracle detects a lock on the file and closes the database down to protect the integrity of the data. How to avoid this? Use backup scripts to backup the database while it is closed, and then have your backup software to backup the backup directory rather than the live database directory. That's the easiest way. If you want to use an Oracle agent with your backup software, then you can backup the live database while it is open, but the agent must be used.
We do have copies of backup scripts available for your server. Just contact us at 800-434-1501 or via email at support@t2systems.com
-Mark
The two leading causes of an Oracle database crash are:
1) Virus Detection Software - We see this one the most! When your virus detection is installed, its on-access scanner must exclude the Oracle live database files. If Oracle detects that there is a lock on one of its files while the virus detection software is scanning the file, the database will close to protect the integrity of the data. Each virus detection software package has a method to exclude certain directories. Just add your Oracle database directory to be excluded and you should be able to avoid this problem.
2) Backup software - We see this one often! A site might be using their backup software to do a file system backup of the open database files. When Oracle attempts to write to the file that is being backed up, Oracle detects a lock on the file and closes the database down to protect the integrity of the data. How to avoid this? Use backup scripts to backup the database while it is closed, and then have your backup software to backup the backup directory rather than the live database directory. That's the easiest way. If you want to use an Oracle agent with your backup software, then you can backup the live database while it is open, but the agent must be used.
We do have copies of backup scripts available for your server. Just contact us at 800-434-1501 or via email at support@t2systems.com
-Mark
Powered by Compendium
Comments for Avoid an Oracle database crash: two leading causes of a crash...