Is it expected to have more than one RMAN incarnation with CURRENT status for the same db?
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.