Questions about redo log files and archive files

zhaozj2021-02-16  67

Author: msnch Date: 02-10-03 07:57

Questions about redo log files and archive files

What is the different log files and archiving files, they have anything, if you want to recover, which is right, now I have seen a book.

Author: snowhite2000

Time: 02-10-03 08:58

Log file: Online Redo log file? Archive file: Archived log files? Log file (Redo log groups) is cycled, if you have three groups, it is loop once, the original file will be overwritten, if one is full, Loop to the next (WRAP), which is full of this COPY is archived log file.

Author: msnch

Time: 02-10-03 09:24

If Database has a problem, what is the right thing to recover?

Author: snowhite2000

Time: 02-10-03 10:00

Your problem is, the more big, the snowball is rolling. When you ask this question, is it based on the starting point? What is the role of Backup and Recovery? Online Redo Log File? Record all changes in the database. Oracle's commit command is to write all log buffers into the redo log, so all changes will become permanent changes. After commit, in fact, your data file has not changed immediately. If this time, your database is closed, it is possible to clean up the database file by recording the record in Redo Log when you start. Why do you archive? If you did a database full backup last night, this afternoon's database has been issued, it is needed, when do you want RECOVER When? If you don't have Archived All Log Files, you can only restore to your backup last night. But if your database is broken, after backing up last night, the Redo log file before today, you are Archived, the last online redo log file is also good, you can Recover to Point Of Failure. Don't read your own book, don't ask how to automatically automatically archive log files.

转载请注明原文地址:https://www.9cbs.com/read-16627.html

New Post(0)