Wednesday, June 29, 2011

Recover table from RMAN backup after droping it? is it possible? how can i do it?

Recover table from RMAN backup after droping it? is it possible? how can i do it?
=========================================================


Recovery will always rollforward yours backup from the time you crash the database.Like

Step 1
You created table

Step 2
Full backup

Step 3
Drop table

Step 1 will goes to yours backup file but step 3 goes to redo log

When you recover database

Step 1
Recover table again due to yours backup file

Step 3
Drop table will due to apply yours redo.



incomplete recovery ( just before to the drop table) can recover your table from RMAN backup.

or

so from RMAN backup one table recovery has No direct methods available.
You can recover /duplcate the database to anther database with RMAN backup
or incomplete recovery before the drop table command
Export the concerned table from the restored/duplicated database to the database you want.

or

use flashback (in oracle 10g) for indivisual table recovery purpose.

or

RMAN TSPITR is most useful for recovering the following:

An erroneous DROP TABLE or TRUNCATE TABLE statement
A table that has become logically corrupted
An incorrect batch job or other DML statement that has affected only a subset of the database
A logical schema to a point different from the rest of the physical database when multiple schemas exist in separate tablespaces of one physical database
-------------------------------------***--------------------------------

RMAN is suitable for media recovery.

imp dump file is a data and metadata backup not database backup
it will no longer be furitful when you will have corruption in yours datafiles.

No comments: