Is there any way to check if a controlfile is a standby controlfile or current pre-startup?
If you think this item violates copyrights, please click here
||Is there any way to check if a controlfile is a standby controlfile or current pre-startup?
||BenBart BartBen, Philippines
||May 23, 2018, 18:30, 363 days ago
Is there any way to check if a controlfile is a standby controlfile or not pre-startup?
Reason I am asking is when starting a database, the startup defaults to Active DataGuard which requires a license. So we are hoping to include a pre-check of some sort to check whether a controlfile is a standby and then do startup mount instead if it is.
At the moment, the workaround is we do startup mount by default, query controlfile_type from v$database and then from there do alter database open or do nothing.
Anyone have a better idea :-)
||Reply - Top of page