| |
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. |
| February 02, 2008 10:32:51 |
#1 |
| ayubfkhan |
Member Since: February 2008 Total Comments: 1 |
RE: Types of Backup
|
| Hot backups are when database is up and running you take backup(DB has to be in archivelog mode in order to do that.) Cold backups are shutdown the database and copy datafiles, control files and save them some place safer(on a different server) Good dba should do that atleast once a month. When you rman backups benefit is that it only backsup blocks that have been used, empty data does not get backed up. This is very efficient as far as space issues go. |
| |
Back To Question | |
