Wednesday, September 24, 2008

RMAN Recovery - All data files or tables using OEM

Perform Recovery
Perform Recovery


Whole Database Recovery


Restore all datafiles

Specify Time, SCN or log sequence. The backup taken at or prior to that time will be used. No recovery will be performed in this operation.
Object Level Recovery
Object Type
Operation Type


Flashback Existing Tables


Flashback Dropped Tables

Encryption

Host Credentials
To perform recovery, supply operating system login credentials to access the target database.
* Username


* Password



Save as Preferred Credential
Overview
  • Restore and/or recover the entire database or selected objects
  • Restore files to a new location
  • Recover tablespaces to a point-in-time based on a timestamp, system change number (SCN), or log sequence number
  • Recover datafile data blocks that are marked as corrupted, or based on datafile block IDs or tablespace block addresses
  • Flashback database or tables to a specific system change number (SCN) or timestamp

No comments: