Reset vs redo quote1/11/2024 ![]() The archive mode can be used for hot backup, incremental backup, and partial recovery. ![]() The data from the most recent full backup to the system error period cannot be restored. The non-archive mode can only be used for cold backup, and can only be used for full backup when restoring. The difference between archive log mode and non-archive log mode ![]() This directory is called the archive directory, and the copied files are called archived redo logs.ĭisaster recovery can only be carried out when the database is running in archive mode.ġ. At this time, the contents of online redo log 1 will be copied to another specified directory. When 1 is full, a log switch occurs and online redo log 2 is written. For example, online redo log 1 is currently being used. ![]() In archive mode, when a log switch occurs, the switched log will be archived. If the database is in non-archive mode, online logs will be discarded when switching. When online redo log group 2 is full, log switching occurs again, To write online redo log group 1, and so on repeatedly. At this time, online redo log group 2 becomes the currently used log. When an online redo log group is full, log switching occurs. Generally, the database must have at least 2 online redo log groups. These operations will be recorded in the online redo log. This log records changes made to the database, such as inserts, deletes, and updates data. Check whether the oracle database is in archive modeĪrchive destination /data/oracle/product/10.2.0/db_1//dbs/arch ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |