Text box

Please note that the problems that i face may not be the same that exist on your environment so please test before applying the same steps i followed to solve the problem .

Tuesday 10 April 2012

Using RMAN to perform recovery

To recover a database we have two steps:
1-Retrieving a copy of the datafile from a backup "Restore".
2-Retrieving a copy of the datafile from a backup "Recover".

This should bring the database to the destired SCN (usually the most recent one).


The Restore
command retrieves the datafile onto disk from a backup location on tape, disk, orother media, and makes it available to the database server. RMAN restores from backup any
archived redo logs required during the recovery operation. If backups are stored on a media
manager, channels must be configured or allocated for use in accessing backups stored there.


The Recover command  takes the restored copy of the datafile and applies to it the changes
recorded in the database’s redo logs.

Comparing Complete and Incomplete Recovery