arulibra

 Profile Answers by arulibra Questions by arulibra

• Jan 27th, 2009

 

When you have multiple databases you have to set your DBID (Database Id), which is unique to each database. You have to set this before you do any restore operation from RMAN.

There is possibility that incarnation may be different of your database. So it is advised to reset to match with the current incarnation. If you run the RMAN command ALTER DATABASE OPEN RESETLOGS, then RMAN resets the target database automatically so that you do not have to run RESET DATABASE. By resetting the database, RMAN considers the new incarnation as the current incarnation of the database.

nareshkumarmca

 Profile Answers by nareshkumarmca 

• Jan 23rd, 2010

 

DBID means database id.

Incunation means:  Database incarnation is effectively a new “version” of the database that happens when you reset the online redo logs using “alter database open resetlogs;”.

Database incarnation falls into following category Current, Parent, Ancestor and Sibling

i) Current Incarnation: The database incarnation in which the database is currently generating redo.

ii) Parent Incarnation: The database incarnation from which the current incarnation branched following an OPEN RESETLOGS operation.

iii) Ancestor Incarnation: The parent of the parent incarnation is an ancestor incarnation. Any parent of an ancestor incarnation is also an ancestor incarnation.

iv) Sibling Incarnation: Two incarnations that share a common ancestor are sibling incarnations if neither one is an ancestor of the other.

Priyan

• Mar 26th, 2013

 

Incaranation help to go backup to old position of the database.