Easy Oracle Database backup and Recovery

  
     
  By dbametrix
  
   
     
  Export utility is very popular backup utility of Oracle. Export backup calls as Logical backup of Oracle. Many developers and DBA are using export of Oracle database as backup.

People use export because it is very easy to operate. There are very few command should be need to execute with export (exp help=y) command and it takes full Oracle database backup. Without knowledge of Oracle DBA operations also able to take backup of full Oracle database using export utility. Using export utility a file is generated calls Dump file because it has default extension .dmp.

Recovery of Oracle database is also simple from export. Import utility calls recovery utility of Oracle database. Import utility easily detects export dump file. Like export utility, import (imp help=y) utility has also very few commands to perform recovery of Oracle database.
Using import utility we can recover full database.

A characteristic of export and import utility is it can be done user level, table level or full database. Means we can take backup of single table or single user level or whole database and recovery can be performed using import in different level.

Export and Import becomes more popular due to easy to understand and easy to perform.

One problem I found that is we are not able to exclude some tables during full export backup or user level export backup. Some of tables are read only tables or never refresh. Then we should need to exclude those tables from our backup because it is useless to take backup of those tables again and again with same data. Unnecessary our export dump file becomes large.

When we are take full backup of database using export utility (exp full=y), same time we can't able to exclude some tables which really we don't want to take backup. Because export utility doesn't perform deselect any table in full database export or user level export. Using expdp we can exclude some table but this new feature was introduced in Oracle 10g. What about previous release?

Using one trick we can exclude some tables in export backup. Change sql of view exu10tab or exu9tab, it can be possible. Off course changing data dictionary view doesn't supported by Oracle, but we can able to perform our backup of Oracle database task for excluding some unwanted tables.

Use Oracle Enterprise Manager or Toad like utilities to change this sql statement (definition) of data dictionary view. Those are very easy options to modify such sql statement. It doesn't recommend to change this definition of Data Dictionary view because it is not supported by Oracle Support. This we can do for performing our important task when space usage is constraint in more important. From Oracle 10g expdp contain parameter named EXCLUDE. We can give list of tables which are wanted to not taking in backup for saving our disk space and not wasting time. But for past release of Oracle database this trick is useful to avoid such read only tables and unwanted table for saving disk space and saving time of backup of Oracle database.

All the Best,
Thanks and Regards,
Dbametrix Solutions

  
   
  Article Source: http://interpret.zar.vg   
     
  About The Author
Gitesh Trivedi is an Expert Oracle DBA and working in Dbametrix. He has excellent 13 years experience.Site
  • www.dbametrix.com "> www.dbametrix.com/
    • offers Remote DBA support and remote Oracle DBA service. All copyright reserved by @Dbametrix. Contact at
  • www.dbametrix.com/remote-dba.html "> www.dbametrix.com/remote-dba.html/

    		•  
         
     
    More Articles about: Software
         		  
     
  • Another Method On How To Unlock Wii Homebrew Without Spending Much
  • From Excel 2003 to Excel 2007 (Part One)
  • Important Factors To Note About Dispatch Software
  • Making Markets Less Competetive With Good Software
  • XSitePro Takes The Complexity Out Of Building Your Website
  • MP3 to MP4 Converter Find the Most Reliable Audio Conversion Software Online
  • Hints And Tips On Using Manufacturing Software
  • The Many Advantages In Using The Journal App
  • Another Online Option To Unlock Wii Homebrew Without Spending Much
  • What is Day Trading
  • Trade Software Forex Success
  • Trusted Way To Unlock Wii Homebrew Without Spending Much
  • How To Use Live Chat Software To Market Your Website
  • 5 Benefits Of Business Voip
  • CRM Software And A Surge In New Business
  • Importance of Design in Online Project Management Software
  • World Wide Web Sources On How To Unlock Wii Homebrew
  • Another Way To Unlock Wii Homebrew Without Spending Much
  • Freedom From Free Microsoft Points
  • 4 Business Benefits Of Live Chat Software
  • 5 Ways Business Voip Can Enhance Your Business Life
  • Tips Of It Careers
  • 3 Simple Ways to Read PDF on Kindle 1 and Kindle Touch
  • What Is Supply Chain Management (SCM)?
  • How to Improve Game Performance
    •      		  
         
         
        © 2012 interpret.zar.vg