Oracle redo online log files

Redo log files are an indispensable part of the ORACLE database. The Oracle server records all database changes to the redo log buffer in order, and the LGWR process retries

Redo log files are an indispensable part of the ORACLE database. The Oracle server records all database changes to the redo log buffer in order, and the LGWR process retries

Oracle redo online Log File reconstruction in seven steps redo online log reconstruction in five minutes redo log Reconstruction

Step 1: create three new online log groups:

Step 2: Change the user status

AlterSystem switch logfile;

Step 3: view the user status

Steps 2 and 3 are repeated, and online logs of active users are transferred to groups 4, 5, and 6;

Step 4: restart the database so that group1, group2, and group3 are all inactive, and then use the following command to delete the original redo group.

Step 5: rebuild group1, group2, group3,

Step 6: Repeat steps 2 and 3 to move the online Log Activity Status of the user redo to group1, 2, or 3;

Step 7: restart the machine and delete the machine When configuring inactive status in group4, group5, and group6.

The following are references.

Redo log files are an indispensable part of the ORACLE database. The Oracle server records all database changes to the redo log buffer in order, the LGWR process writes redo entries from the redo log buffer to the online redo log file. In the event of a media failure, a recovery mechanism is provided, which is also a means for ORACLE databases to ensure data security.

In a real environment, the redo log file may be lost due to accidental deletion or other reasons. If the database detects the loss of the redo log at startup, the database cannot be started. If the database switches to a log file group during running and the next group or all of the redo logs are lost, the database will crash. Therefore, it is necessary to learn the Oracle redo log restoration skills.