View recovery data during database recovery

It is believed that many people have encountered the accidental deletion of data and asked the DBA to restore the data, but the user only knows the approximate time of occurrence. At this time, you may see that there are two backups at the same time as the error occurs. If you restore to the last one, you may have to check the data and find that something went wrong. If there are many logs, it takes a lot of time. Today, we see the Oracle recovery principle in the following sentence:

Beforeusing the open resetlogs command to open the database in read/writemode after an incomplete recovery, it is agood idea
First open the database inread-only mode, and inspect the data to make sure that the databasewas recovered tothe correctpoint.

That is to say, you can change the database to read-only before it becomes available.

 

In fact, SQL Server can also do this. When restoring the log, use reconvery with standby. After confirming that all the data is retrieved, you can change the database to writable:

Restore database with reconvery.