Incomplete reply-alter database open Resetlogs

Source: Internet
Author: User

First to understand what the ALTER DATABASE open resetlogs mean, why use Resetlogs to open the database, this command issued after the Oracle has done?


The ALTER DATABASE open Resetlogs is to reset the redo log when the data is being opened, and the sequence of the redo log is about to reset to zero, why reset the redo log?


After incomplete recovery, the original online redo log contains data that was not pre-recovered, and the data is no longer valid for the restored database, so the database will require the sequence of the online redo log to be zeroed before open.


The Resetlogs command represents the end of a logical lifetime of a database and the beginning of another logical lifetime of a database, and the SCN is not reset each time the Resetlogs command is used, but Oracle resets the log sequence number and resets the online redo log content.


Oracle calls this database logical lifetime incarnation

Each time you use Resetlogs to open the database, you will make incarnation + 1, that is, to generate a new incarnation;

If you want to revert to the previous incarnation Scn/time, you need to revert to the previous incarnation;


For the above case, the specific is to first

Reset database to incarnation 2;

Try again not to fully recover


This article is from the IT dwarfs! "Blog, be sure to keep this provenance http://lqx049.blog.51cto.com/1919902/1714817

Incomplete reply-alter database open Resetlogs

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.