| |
GeekInterview.com > Interview Questions > Oracle > Backup and Recovery
| Print | |
Question: Types of Backup
Answer: What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail. |
| September 09, 2008 11:03:15 |
#3 |
| joshanil |
Member Since: September 2008 Total Comments: 1 |
RE: Types of Backup
|
1. Hot, inconsistance and online backup are same
2. Cold, close consistance and offline backup are same
For 1. db must be archive mode, inconsistance mean the SCN are not same
For 2. db may be archive mode, consistance mean SCN are same (controlfile, datafile)
Logical backup through import/export utilities
Physical backup simply copy all file using OS command
|
| |
Back To Question | |
