8 Replies Latest reply: Oct 9, 2012 9:43 AM by User477708-OC RSS

    Dataguard error: log_file_name_convert  issue

    User477708-OC
      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.