Backup and recovery is one of the most important aspects of a DBA's job.
If you lose your company's data, you could very well lose your job.
The following methods are valid for backing-up an Oracle database: It is advisable to use more than one of these methods to backup your database.
For more information about the Oracle export and import utilities, see the Import/ Export FAQ.Hardware and software can always be replaced, but your data may be irreplaceable!Normally one would schedule a hierarchy of daily, weekly and monthly backups, however consult with your users before deciding on a backup schedule.Backup frequency normally depends on the following factors: Carefully plan backup retention periods.Ensure enough backup media (tapes) are available and that old backups are expired in-time to make media available for new backups. Frequently test your ability to recover and document all possible scenarios.