Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

LIST INCARNATION OF DATABASE meaning

2025-04-06 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Http://blog.itpub.net/7259433/viewspace-2146710/

The Resetlogs command represents the end of one database logical lifetime and the beginning of another database logical lifetime. Each time you use the Resetlogs command, SCN is not reset, but oracle resets the log sequence number and resets the contents of the online redo log. Oracle calls the logical lifetime of the database incarnation. Every time you open the database with resetlogs, it will cause incarnation + 1, that is, to generate a new incarnation.

If you want to restore to the previous scn/time of incarnation, you need to restore to the previous incarnation.

After rman recover, after resetlog is opened, if you want to re-recover, then you need reset database to incarnation....

-- backup recovery

Run {

Set until scn 2122840

Shutdown immediate

Startup mount

Restore database

Recover database

Alter database open resetlogs

}

-- backup and restore again

List incarnation

Startup mount

Reset database to incarnation 5

Restore database until scn

Recover database until scn

Incarnation means "avatar" in English. So what does it mean in oracle? What's the use?

Current Incarnation (current avatar): the avatar currently in use in the database.

Parent Incarnation (parent avatar): the last avatar of the current avatar in the database. When the parent avatar is turned on as OPEN RESETLOGS, the current avatar is generated.

Ancestor Incarnation (ancestral incarnation): before the father incarnates, tossing and turning to generate the incarnation of the father.

Direct Ancestral Path (direct ancestral path / genealogy): the branch path generated from the initial avatar of the database to the current avatar, including the ancestral and parent avatars of the database.

Orphan Incarnation (orphan avatar): other database avatars that are not on the genealogy of the current incarnation in the database.

Orphaned Backups (orphan backup): a database backup that is not generated on the genealogy of the current avatar of the database. The current avatar cannot make

First of all, we can look at a picture to have a basic understanding of incarnation.

As shown in the figure, during the process from SCN1 to SCN1000, the database belongs to incarnation 1, develops to horizontal SCN 2000, and is not completely restored to SCN1.

000, at this time after the SCN1000 to the horizontal SCN2000 is (orphan incarnation). And SCN1000 develops to the above SCN2000 to form incarnation 2.

Incarnation 1 is the parent incarnation of incarnation 2. When SCN2000 continued to develop to SCN3000, it did not fully recover to SCN.

2000 SCN 2000 continued to develop horizontally to SCN3000, forming incarnation 3. So incarnation 1 is the incarnation 3 (grandparent incarnation)

Incarnation 2 is the ancestor incarnation of incarnation 1.

The gray track for all incarnation 1 to incarnation 3 is Direct Ancestral Path.

All backups after SCN 1000 in Incarnation 1 and all backups after SCN 2000 in Incarnation 2 are orphan backups.

From then on, I should be able to get a general understanding of Incarnation.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report