My Oracle Support Banner

List Incarnation of Database Gives Information for Multiple Databases (Doc ID 2104327.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


When there are multiple database registered into the same RMAN catalog schema with same DB_NAME but with different DBID, "list incarnation of database" will list information on all databases:

RMAN> list incarnation of database;

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 16 DBNAME 3026357038 PARENT 1 07-jul-2014 05:38:47
1 17 DBNAME 3026357038 PARENT 1594143 04-jan-2016 06:52:00
1 2  DBNAME 3026357038 CURRENT 19391756 02-feb-2016 09:39:00
21 39 DBNAME 3015261543 PARENT 1 24-aug-2013 11:37:30
21 22 DBNAME 3015261543 CURRENT 925702 28-sep-2015 12:25:16


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.