What is archive log file?

@ : Home > > Interview Room

In archive log mode, the database will makes archive of all redo log files that are filled, called as archived redo logs or archive log files.

- By default your database runs in NO ARCHIVE LOG mode, so we can’t perform online backup’s (HOT backup).
- You must shut down database to perform offline backup (COLD backup) and recovery can be done to the previous backup state.
- Archive log files are stored in a default location called FRA (Flash Recovery Area).
- We can also define our own backup location by setting LOG_ARCHIVE_DEST parameter.

Enable Archive log mode in oracle database 11g

Alert me