Thursday, November 3, 2011

Why should backup Your Oracle database

Backup is like second life for any database and it is the most important role of database administrator's job. We can replace corrupt software and hardware with new one but without backup, accessing corrupt oracle database is like nightmare. In some cases you can try any third party oracle database recovery software to recover corrupt/damaged oracle database.

    “If you lose organization's data, may lose your job”  

Schedule to get Backup: you can schedule your routine to get backup of oracle database on daily, weekly and monthly basis. Normally oracle database backup routine depends upon the below factors.

  1. Value of  data: High or Low
  2. Transaction Rate
  3. Number of Users
  4. Database Availability
  5. Many Other

Note: If possible, try to consult your database users before deciding a plan.

Methods for Backing-Up: Oracle database offers four methods for backing-up of an Oracle database.

  • Export/Import
  • Cold or offline backup
  • Hot or online backup
  • RMAN backup

Sometimes backup accomplished by one method is not able to fix the corruption so it is recommended to you to take backup of oracle database by two methods.

Recovery without Backup: Yes, it is possible to recover corrupt oracle database file and its objects without backup. For this, you can try any third party oracle database recovery tool. These tool use advanced scanning algorithm to scan and repair corrupt oracle database file and objects like tables, tablespaces, triggers, views, keys and many more.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...