11.2.0.2 OEL
Ive inherited a dataguard setup.
Primary: 2 node RAC ASM
Standby: single instance, mounted volume
I went to test opening the standby as snapshot standby
DGMGRL> convert database sigbcp to snapshot standby;
Converting database "stdby" to a Snapshot Standby database, please wait...
Error: ORA-00349: failure obtaining block size for ''
Failed.
Failed to convert database "stdby"
DGMGRL>
after a bit of investigation, it looks like some of the logfiles havent converted their name from ASM. when I select the log file names on standby I see some are converted ok but some have not
select member from v$logfile;
/u02/database/redo/log1
/u03/database/redo/log2
/u04/database/redo/log3
+DATA/sid/log4
+DATA/sid/log5
From reading, I know I can build up my log_file_name_convert and set it dynamically but is there anything to be done other that that? ie, do I have to restart or even go as far as rebuilding the instance.