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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RMAN duplicate to before refresh date returns RMAN-06024

Terri WrightNov 11 2022

This is a well used customer database in QA and there was a refresh recently. I've been tasked to duplicate the database to our POC box from backup before refresh date.
I've tried until time and until scn and both fail for controlfile.
It is looking for: CONTROLFILE/current.355.1120478111
But the current is: /CONTROLFILE/current.521.1118330231
AND, there was no +ASM mulitplex of CF but a disk copy which still exists. "controlfile/o1_mf__wrch3tcg_.ctl"
After refresh, I multiplex CF to +DATA_DG and +ARCHIVE_DG.
So rman duplicate looking for CONTROLFILE/current.355.1120478111 and controlfile/o1_mf__wrch3tcg_.ctl (<- this one still exists).
But what is available in v$controlfile is: +DATA/CONTROLFILE/current.521.1118330231 and +ARCH/CONTROLFILE/current.905.1120326525
Can anyone help? I tried Oracle Doc ID 1348071.1 to run "backup archivelog all" but still get same error.

Comments

Post Details

Added on Nov 11 2022
1 comment
300 views