Recovery
scenarios using HOT/COLD/RMAN backups
Hi,
Here the several restoring
and recovering scenarios of database/files/tables using HOT/COLD/RMAN backups.
I have listed all resolutions in one page as below.
|
Backup I had
|
What have I lost?
|
How to recover?
|
|
RMAN
|
system datafile
|
|
|
RMAN
|
Control file
|
|
|
RMAN
|
Users datafile
|
|
|
COLD backup
|
Any of CRD
files(control,redo,data files)
|
|
|
HOT backup
|
control file
|
|
|
HOT backup
|
system datafile
|
|
|
HOT backup
|
sysaux datafile
|
|
|
HOT backup
|
temp datafile
|
|
|
HOT backup
|
undo datafile
|
|
|
HOT backup
|
users datafile
|
|
|
HOT backup
|
online redo log files
|
|
|
HOT backup
|
Tablespace
|
|
|
HOT backup
|
table
|
No comments:
Post a Comment