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

Last updated on OCTOBER 01, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

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 REPO 3026357038 PARENT 1 07-jul-2014 05:38:47
1 17 REPO 3026357038 PARENT 1594143 04-jan-2016 06:52:00
1 2 REPO 3026357038 CURRENT 19391756 02-feb-2016 09:39:00
21 39 REPO 3015261543 PARENT 1 24-aug-2013 11:37:30
21 22 REPO 3015261543 CURRENT 925702 28-sep-2015 12:25:16

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms