[Online lesson excerpt]8.2 The recovery experiment for log corruption with a simulated state of inactive (full recovery)

1 Viewing the current log status

From here we can see that we now have three logs, with only 1 members in each group of logs. To demonstrate this experiment, we added 1 members to each group.

2 adding group members to each group

After adding, we verify the status of the current log members:

From the view above, we can see that our log group members have been added to our log group and added to the invalid state of the log members.

3 switching 3 groups of log archives

To view the log status at this time:

You can find that both log Group 1 and log Group 2 are inactive states.

4 Delete Inactive Status log

According to the previous confirmation, our current log Group 1 and log Group 2 are all inactive states, and now we delete the member Redo1.log of log Group 1 directly.

Let's restart the database and see what happens:

We will find that the Log Group 1 Member Redo01.log state becomes the invalid state at this time.

We look at the information in the warning log and notice that there is a hint that the log does not exist.

5 Recovery of log information

Let's log the data again:

[Online lesson excerpt]8.2 The recovery experiment for log corruption with a simulated state of inactive (full recovery)