Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

User_4YDQ6Dec 7 2015 — edited Dec 7 2015

version : 11.2.0.3

using CommVault but I don't think that is the issue.

Getting

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

I've tried a number of things!  (using connect target rara/pw@PHRMS, no catalog)

Running this on the destination / aux host.

Using this below with ORACLE_SID=HRA1 (dest sid), dbid below is the source db  ;  rmancat1 is the source (PHRMS2) db

The dbid used is in the recovery catalog with the source SID.

rman << EOF

connect AUXILIARY / catalog rmanbkpuser1/xxxxxxxxx@RMANCAT1;

run {

set dbid=2286605610;

allocate auxiliary channel ch1 type 'sbt_tape'

PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1)"

TRACE 0;

allocate auxiliary channel ch2 type 'sbt_tape'

PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch2)"

TRACE 0;

allocate auxiliary channel ch3 type 'sbt_tape'

PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch3)"

TRACE 0;

allocate auxiliary channel ch4 type 'sbt_tape'

PARMS="SBT_LIBRARY=/opt/simpana/Base64/libobk.so,BLKSIZE=262144,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch4)"

TRACE 0;

set until time = "TO_DATE('NOV 29 2015 21:33:36', 'MON DD YYYY HH24:MI:SS')" ;

duplicate  target database to 'HRA1'

LOGFILE

GROUP 1

(

'HRA_redo1'

)  SIZE 50M,

GROUP 2

(

'HRA1_redo2'

)  SIZE 50M,

GROUP 3

(

'HRA_redo3'

)  SIZE 50M

nofilenamecheck

;

}

exit;

EOF

Any help would be greatly appreciated!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2016
Added on Dec 7 2015
4 comments
1,703 views