In general, backup & recovery combines several strategies & procedures which are protecting database against data lose and reconstructing the database after any kind of data loss.
There are two types of backup strategies:
Physical backup is the foundation of any sound backup & recovery strategy. Logical backup is a useful supplement to physical backup but not ensure sufficient protection against data loss without physical backup. Unless otherwise specified, the term backup refers to physical backup.
Oracle provides two backup & recovery solutions –
RMAN can take backups of –
A database recovery involved two tasks:
There are two types of backup strategies:
- Physical Backup – are backups of the physical files used in restoring &recovering database, such as datafiles, controlfiles and archived redo logs.
- Logical Backup – contains logical data exported from database with oracle utilities (i.e, datapump) and stored in a binary file.
Physical backup is the foundation of any sound backup & recovery strategy. Logical backup is a useful supplement to physical backup but not ensure sufficient protection against data loss without physical backup. Unless otherwise specified, the term backup refers to physical backup.
Oracle provides two backup & recovery solutions –
- Recovery Manager (RMAN) managed backup & recovery.
- User managed backup & recovery.
RMAN can take backups of –
- Datafiles
- Controlfiles
- Redo logs / archived redo logs
- Serve parameter file (SPFiles)
A database recovery involved two tasks:
- Restore- retrieve datafiles or controlfiles from backup.
- Recover- apply archived & on-line redo log changes on restored datafiles ( it is also known as media recovery)