Database Backup and Recovery (MOSC)

MOSC Banner

Is it expected to have more than one RMAN incarnation with CURRENT status for the same db?

edited Jan 14, 2015 10:04AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Hi everybody,

While writing some queries on RMAN catalog views found that some databases have two or more incarnations with CURRENT status.

RMAN> list incarnation of database 'TEST11G';

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

20500573 20501011 TEST11G     1024672251       PARENT  1          21-JUN-12

20500573 20501012 TEST11G     1024672251       PARENT  5886271211177 26-SEP-12

20500573 20501013 TEST11G     1024672251       ORPHAN  5912176860994 02-JUL-13

20500573 20500574 TEST11G     1024672251       PARENT  5945029651945 18-JUL-14

20500573 20576349 TEST11G     1024672251       CURRENT 5945038937439 23-JUL-14

21048367 21048730 TEST11G     1087033139       PARENT  1          21-JUN-12

21048367 21048368 TEST11G     1087033139       CURRENT 5957252775619 04-SEP-14

We use to provision dev/test environments by restoring prod backups. My understanding as per documentation is that only one incarnation should be CURRENT at a time.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center