This discussion is archived
8 Replies Latest reply: Oct 9, 2012 7:43 AM by User477708-OC RSS

Dataguard error: log_file_name_convert  issue

User477708-OC Journeyer
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points