Forum Stats

  • 3,826,752 Users
  • 2,260,703 Discussions
  • 7,897,071 Comments

Discussions

duplicate database then RMAN-20003: target database incarnation not found in recovery catalog

rugbyRCT
rugbyRCT Member Posts: 25 Bronze Badge
edited Mar 19, 2020 3:41AM in Recovery Manager (RMAN)

hello gurus,

    I executed a duplicate database and i have received this next message :

"RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog"

1 - My database is version 12.1.0.2

2 - i have executed :

RMAN> run {
allocate auxiliary channel CH01 type 'SBT_TAPE'
parms='ENV=(NB_ORA_CLIENT= erpprdXXX01vm03, NB_ORA_SERV=sbre117)';
allocate auxiliary channel CH01 type 'SBT_TAPE'
duplicate database OAXXPRD DBID=4231850259 to OAXXPRE;
release channel CH01;

I have controled my catalog of my database :

>>>SELECT name, DBID, RESETLOGS_TIME FROM rc_database WHERE dbid=4231850259;

OACNPRD    4231850259    24-NOV. -18 12.06.46

>>>

SELECT dbid, name, dbinc_key, resetlogs_change#, resetlogs_time, current_incarnation

FROM rc_database_incarnation WHERE dbid=4231850259 ORDER BY resetlogs_time;

4231850259    OACNPRD    568970    7885741546    28-MAI  -14 03.36.07    NO

4231850259    OACNPRD    568869    5981997402758    24-NOV. -18 12.06.46    YES

>>>

select DB_KEY, DBID,NAME,RESETLOGS_CHANGE#,CURRENT_INCARNATION,PARENT_DBINC_KEY,STATUS

from RC_DATABASE_INCARNATION where name='OACNPRD' order by dbid,resetlogs_time;

568868    4231850259    OACNPRD          7885741546    NO      (null)        PARENT

568868    4231850259    OACNPRD    5981997402758    YES    568970    CURRENT

>>>>

All seemes correct but i do not understand why i have this next problem.

What is the guru who may help me ?

Have you an idea ?

Best regards

JP



Adityanath Dewoolkar

Best Answer

Answers