Easy Oracle backup and Recovery

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
Links:
As a famous tool of Lionsea company, SD Memory Card Recovery is designed for SD memory card used by digital camera or mobile phone; it can recover lost, deleted, corrupted or formatted photos, video, files from various memory card types including SD Card, MicroSD, SDHC, CF (Compact Flash) Card, XD Picture Card, Memory Stick and more. SD Memory Card Recovery is easy to use and lets people free scan and preview of lost files. So with the help of sd memory card recovery, recovering lost files from sd card will be extremely easy. Compared with other recovery tool, SD memory card recovery is a 100% clean and safe Memory card recovery tool.

CF Card Recovery is a CF Card Recovery software to recover deleted, reformatted and damaged photos and movies from Compact Flash Card. It uses a wizard-style interface to allow you to easily recover pictures and video files from a CF memory card. CF Card Recovery gives a detail introduction of how to recover files from cf card and how to recover photos from cf card. With cf recovery, people will no longer worry about cf card corruption. compact flash recovery Pro is developed by top engineers. Every function in it is designed with a lot of efforts.

Fat Loss Factor will help you lose weight in the shortest time. If you want to get a flat belly, just use this video to tell you how to do. You will never be disappointed. Many customers have tried this tool.

Xbox 360 3 Red Lights Fix - Fix This Problem Today!
Installation Process Of Kaspersky Internet Security 2011
A Great Way of Losing Weight: Walking
5 Tips To Consider Before Buying A Laptop Computer
Strategic and Reputable Website Development