Quick solution for ORA-01665: control file is not a standby control file


From time to time when I’m creating standby databases manually, I’m facing next annoying message when starting managed recovery of standby database:

ORA-01665: control file is not a standby control file

It means that I have restored not standby control file

To cope with this situation I have to CREATE STANDBY CONTROLFILE on primary, copy it to standby, then restore it(better read full store here), depending on disk configuration rename data, log-files…, but… I’m quite lazy… and prefer quick solutions if they are present.

So, the quick solution for ORA-01665 will be: Continue reading