Ta-ra-rara-tara!!! (trumpets blaring)
And the solution is:
1) Stop managed recovery on the standby:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
2) Copy the files from standby mp to clone mp.
3) Re-start managed recovery on the standby:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE
DISCONNECT FROM SESSION;
4) Re-create the controlfile on the clone:
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "CLONEDB" RESETLOGS FORCE LOGGING NOARCHIVELOG
-- Etc --
5) Open clone database with resetlogs
And ALL is OK! 
.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote