What Is The Difference Between Online And Offline Backups?

1.	What Is The Difference Between Online And Offline Backups?
Answer» A HOT backup is a backup PERFORMED while the database is online and AVAILABLE for read / write. Except for ORACLE exports, one can only do on-line backups when running in ARCHIVELOG mode. A cold backup is a backup performed while the database is off-line and UNAVAILABLE to its users. A hot backup is a backup performed while the database is online and available for read / write. Except for Oracle exports, one can only do on-line backups when running in ARCHIVELOG mode. A cold backup is a backup performed while the database is off-line and unavailable to its users.

Answer»

A HOT backup is a backup PERFORMED while the database is online and AVAILABLE for read / write. Except for ORACLE exports, one can only do on-line backups when running in ARCHIVELOG mode.

A cold backup is a backup performed while the database is off-line and UNAVAILABLE to its users.

A hot backup is a backup performed while the database is online and available for read / write. Except for Oracle exports, one can only do on-line backups when running in ARCHIVELOG mode.

A cold backup is a backup performed while the database is off-line and unavailable to its users.

Discussion

No Comment Found

Related InterviewSolutions

How To Create An Oracle Database?
How To Start Oracle Sql Developer?
Is Oracel Sql Developer Written In Java?
What Is The Reports View In Oracle Sql Developer?
What Do You Think About Oracle Sql Developer?
What Is An Anonymous Block?
How To Declare A Local Variable?
How To Initialize Variables With Default Values?
How To Assign Values To Variables?
What Are The Arithmetic Operations?