Hi everyone!
I face some issue when i try to duplicate from active database.
Everything is scripted to automate the task.
Here is my RMAN CMDFILE:
run
{
allocate channel tg type disk;
allocate auxiliary channel au type disk;
SET NEWNAME FOR DATABASE TO '+DATA';
DUPLICATE TARGET DATABASE TO QA_SYSTEM FROM ACTIVE DATABASE
NOFILENAMECHECK;
}
EXIT;
For Controlfiles and Redologs i've set the *.DB_CREATE_ONLINE_LOG_DEST_1='' Parameter.
Everything works fine so far but RMAN creates in summary 3 Controlfiles and 1 of 3 is corrupt.
ORA-00205: error in identifying control file, check alert log for more info
ORA-00204: error in reading (block 1, # blocks 1) of control file
ORA-00202: control file: '+DATA/QA_SYSTEM/CONTROLFILE/current.311.1128292157'
ORA-17510: An attempt to do I/O of size 32768 to block 1 is beyond file size 0. Logical block size: 16384.
ASMCMD> cd DATA/QA_SYSTEM/CONTROLFILE
ASMCMD> ls -ls
Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name
CONTROLFILE UNPROT FINE FEB 08 21:00:00 Y 16384 1245 20398080 33554432 Current.277.1128289265
CONTROLFILE UNPROT FINE FEB 08 21:00:00 Y 16384 1 16384 33554432 Current.311.1128289265
CONTROLFILE UNPROT FINE FEB 08 21:00:00 Y 16384 1245 20398080 33554432 current.290.1128289511
You can see, Current.311… has just 1 Block and cant be used. Its a lucky thing:
I tried to workaround this with just using 1 Controlfile (first one that get grepped in asm) but if the corrupt one is the first, it doenst work..
My question is: Does RMAN Create these Controlfiles from scratch?
A Disk Failure can be excluded. When i use a manually restore of the source system controlfile, everything works fine.
My Testsystem has Oracle EE 12.2.0.1 i know its kinda outdated, but i didnt find a bug or mos note.
Is there something i miss?
Thanks for help!
Regards