[Online lesson excerpt]8.3 simulation state for active log corrupted Data recovery Experiment (incomplete recovery)

1 Viewing the current log status

The first incomplete recovery is the loss of data, so we create some test data in the currently open data to verify that the data still exists when we complete the incomplete recovery.

2 simulating the deletion of logs from the current state

3 Start data validation error message

You can see the alert file in the alert message:

4 Incomplete recovery of the database

After we use Resetlog, the system prompts are not consistent and need to be restored. The next step is to use the hidden parameters, and do not allow the database to be validated for consistency when it is opened.

5 Close Hidden parameters

[Online lesson excerpt]8.3 simulation state for active log corrupted Data recovery Experiment (incomplete recovery)