BACKUP AND RECOVERY SECTION

BACKUP AND RECOVERY SECTION
Ch 10

There are two major types to take backup & recovery in oracle :
1- USER MANAGED BACKUP & RECOVERY
2- RMAN (RECOVERY MANAGER)
USER MANAGED BACKUP
Physical Backup Logical Backp
(datafile,controlfile,logfiles) (Imp & Exp)
(This Backup is
Takeout from
No-Archive Archive instance/SGA)
Full Offline Full Offline Database Backup
Database Full Online Database Backup
Backup Partial Offline Database Backup
Partial Online Database Backup
Note:
In No-Archive Mode just Shutdown the database and take Backup of (Physical Files)