Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

How does archive log file helps to make backup consistent?

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

Answer:

If database is in Archive Log Mode the only it is possible to perform HOT (Online) Backup, however all transaction entries would be done in Redo File and eventually it will be written to Archive Log File, it also called Archived Redo Log files.Hence by backing up Datafiles/Redo Log Files/Control Files and Archived redo Log Files you can have a consistent backup. Only in caseof Cold backup you dont reuire Archive Redo Log files as database instance is down while performing Cold backup.
For more details you may refer - http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12007.htm

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
How to apply archive log file in Oracle?What is schema in Oracle Architecture?