Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
duplicate database then RMAN-20003: target database incarnation not found in recovery catalog

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
Best Answer
-
Check if the below MOS note is relevant for you:
RMAN DUPLICATE fails with RMAN-20003 / RMAN-20005 (Doc ID 2036644.1)
If yes, kindly use workaround provided in the document.
Regards,
Adi
Answers
-
Check if the below MOS note is relevant for you:
RMAN DUPLICATE fails with RMAN-20003 / RMAN-20005 (Doc ID 2036644.1)
If yes, kindly use workaround provided in the document.
Regards,
Adi
-
hello Adi,
thank you for the workaround process.
but i do not know how may I download the patch 14683854
because it is necessary to get the extended support.
I read in the readme.txt of this patch, it is for RMAN-2005 and my error is RMAN-2003 the readme.txt.
is it the same ?
best regards
JP
-
Hello,
I guess for RMAN-2003, workaround is sufficient.
But about patch availability & relevancy its better to check with Oracle Support to get their opinion.
Regards,
Adi
-