[Lesson]9.2 Simulation database, table space and recovery operation after data file corruption

1 Environment Preparation

Make a full backup of the database:

Verify the current backup file:

2 Recovery of database corruption

2.1 Impersonation Database corruption

Try restarting the database to see the error:

The important point here is that we use the Catlog database as the directory database, so even if the control file is lost it does not affect our recovery.

Now let's check the alarm file for error:

2.2 Database Recovery

3 Recovery of table space corruption3.1 Damage to the simulation table space

Looking at the table space for the current library, we now simulate TEST_MSSM and TEST_ASSM table space corruption.

To delete a tablespace file:

Restart the database to view the error message:

Let's check the error message in the alarm file:

3.2 Restoring a table space

Confirm the status of the tablespace again:

4 recovery After a corrupted data file4.1 Corrupted analog data file

Try to start the database:

4.2 Recovery of data files

[Lesson]9.2 Simulation database, table space and recovery operation after data file corruption