Basics of Oracle Backups-Easy guide to learn about Oracle backups

Articles on the basics of Oracle backup

Sponsored Links

Choosing the method of Oracle backups

Oracle backups can be done by the following methods

• Offline Oracle backups
• Online Oracle backups
• Export Oracle backups

Offline Oracle backups

Offline Oracle Backups are achieved by

 

• Shutting down the Oracle database
• Backing up of the data  If you are using Unix,the simplest way to Oracle backup is
  • sh oraback.sh

         Prerequisites for oraback.sh

•   The oratab file should not be corrupted

            oraback.sh backs up all instances in oratab    

• Starting up the Oracle database so that Oracle backup is complete

Online Oracle backups

Steps to do online Oracle backups

•     Switch the tablespace to backup mode
  •     Use Alter tablespace A begin backup  (where A is the tablespace name)

•     Do the backup

•     Switch the tablespace to non-backup mode
  •     Use Alter tablespace A end backup
• The Oracle backup is complete

Export Oracle backups

• Export Oracle backups do only logical backup to a file,not physical backups
• The drawback is that exports work on a point in time- that is a complete or selective Oracle backup is made to the file,which is then imported.

Strong tip on Oracle data backups!

Always have the Oracle database in ArchiveLog mode for Oracle backups to work effectively

See also,

Oracle backup software

Simple and best unix backups- tar,ufsdump,cpio

 

 

Sponsored Links

Sponsored Links

Home|Sitemap|Search|Feedback|Advertisers|Privacy Policy

Disclaimer: While any information,technique or suggestion is carefully researched and often based on user feedback,data-recovery-reviews.com is not responsible for any data loss or any other financial loss sustained based on advice given on data-recovery-reviews.com.Products reviewed by data-recovery-reviews.com  cannot be construed as  endorsements.Copyright © 2004 data-recovery-reviews.com
Last modified: December 12,2006