[Oracle] Backup Methodologies

Last update on July 31, 2009 12:40 PM by jak58
Published by jak58

[Oracle] Backup Methodologies





Intro


The system backup with NT or UNIX (such as dump or tar) should be performed weekly. Oracle databases can be saved either by stopping the database or performing it while the database is still running.

Note that all of the control files, data and archive logs should be saved at the same time and to ensure the integrity and consistency of restorations.
Note that even if REDO logs are saved, they should not be restored without the Online redo logs being lost or corrupted( try to maximize the use of Online redo logs and control files the most recent possible). If it is needed that you use control files restored from a backup, make use the USING BACKUP CONTROLFILE option in the restore command Import / Export.

Archive Logging


Archive logging is strongly recommended for all Oracle databases.
Archive logging is automatic and can consume disk resources in a highly active environment. If a restore is required, the system will ask the Archive logs and perform restores from them.
The archive logs can restore from a point in time.
For live backups, archives logs are needed.
To control the destination and frequency of the archive log, make use of the parameters available at INIT.ORA.
Best answers for « Backup Methodologies » in :
Backup Show Backup Setting up a redundant architecture ensures that system data will be available but does not protect the data against user-introduced errors or against natural disasters such as fires, floods or even earthquakes. Therefore it is necessary to...
Backup Outlook 2003 data Show Backup Outlook 2003 data All Outlook 2003 data ( Emails, Agenda, Contacts, Tasks...) are in one file with .pst extension The file is in the following default folder: C:\Documents and Settings\Login\Local Settings\Application...
[Windows XP] Support/Backup/Recovery/Repair Show [Windows XP] Support/Backup/Recovery/Repair Remote Assistance System Restore ASR : Automatic System Restore Recovery Console Here are some methods to handle major problems with Windows XP Remote Assistance You can ask...
Backup/Restore Mysql database ShowBackup/Restore Mysql database Backup Restore your database Note A simple approach on how to backup and restore MySQL databases. Backup To save an existing database it is recommended that you create a dump. To dump all...
Making a backup of your drivers using DriverMax ShowMaking a backup of your drivers using DriverMax It happens that for some reasons you want to reinstall your OS and that no driver CD are available or for some hardware (integrated GPU or sound card), it is very difficult to find the proper...
Incremental backup of data with .BAT (Batch) ShowIncremental backup of data with .BAT (Batch) Use of incremental back up Example Use of incremental back up Incremental back up can be used to save your important data before you format your computer. During the first batch launch,...
They need your help