2 Replies Latest reply: Feb 23, 2012 10:53 AM by 891445 RSS

    ORA-00349: failure obtaining block size

    891445
      I am trying to drop and recreate ONLINE redo logs on my STANDB DATABASE (11.1.0.7)., but i am getting the below error.
      On primary, we have done the changes., ie we added new logfile with bigger size and 3 members. When trying to do the same on Standby we are getting this error.
      Our database is in Active DG Read only mode and the oracle version is 11.1.0.7.

      I have deffered the log apply and cancelled the managed recovery, and dg is in manual mode.






      SQL> alter database Add LOGFILE GROUP 1 ('+DT_DG1','+DT_DG2','+DT_DG3') SIZE 1024M;
      alter database Add LOGFILE GROUP 1 ('+DT_DG1','+DT_DG2','+DT_DG3') SIZE 1024M
      *
      ERROR at line 1:
      ORA-00349: failure obtaining block size for '+DT_DG1'
        • 1. Re: ORA-00349: failure obtaining block size
          CKPT
          888442 wrote:
          I am trying to drop and recreate ONLINE redo logs on my STANDB DATABASE (11.1.0.7)., but i am getting the below error.
          On primary, we have done the changes., ie we added new logfile with bigger size and 3 members. When trying to do the same on Standby we are getting this error.
          Our database is in Active DG Read only mode and the oracle version is 11.1.0.7.

          I have deffered the log apply and cancelled the managed recovery, and dg is in manual mode.
          SQL> alter database Add LOGFILE GROUP 4 ('+DT_DG1','+DT_DG2','+DT_DG3') SIZE 1024M;
          alter database Add LOGFILE GROUP 4 ('+DT_DG1','+DT_DG2','+DT_DG3') SIZE 1024M
          *
          ERROR at line 1:
          ORA-00349: failure obtaining block size for '+DT_DG1'
          First why you are dropping & recreating online redo log files on standby.
          On standby only standby redo log files will be used. Not sure what you are trying to do.

          here is example how to create online redo log files, Check that diskgroup is mounted and have sufficient space to create.
          sys@ORCL> select member from v$logfile;
          
          MEMBER
          -----------------------------------------------------------
          C:\ORACLE\ORADATA\ORCL\REDO03.LOG
          C:\ORACLE\ORADATA\ORCL\REDO02.LOG
          C:\ORACLE\ORADATA\ORCL\REDO01.LOG
          
          sys@ORCL> alter database add logfile group 4 (
            2     'C:\ORACLE\ORADATA\ORCL\redo_g01a.log',
            3     'C:\ORACLE\ORADATA\ORCL\redo_g01b.log',
            4     'C:\ORACLE\ORADATA\ORCL\redo_g01c.log') size 10m;
          
          Database altered.
          
          sys@ORCL> select member from v$logfile;
          
          MEMBER
          -----------------------------------------------------------
          C:\ORACLE\ORADATA\ORCL\REDO03.LOG
          C:\ORACLE\ORADATA\ORCL\REDO02.LOG
          C:\ORACLE\ORADATA\ORCL\REDO01.LOG
          C:\ORACLE\ORADATA\ORCL\REDO_G01A.LOG
          C:\ORACLE\ORADATA\ORCL\REDO_G01B.LOG
          C:\ORACLE\ORADATA\ORCL\REDO_G01C.LOG
          
          6 rows selected.
          
          sys@ORCL>
          Your profile:-

          888442      
               Newbie
               
          Handle:      888442
          Status Level:      Newbie
          Registered:      Sep 29, 2011
          Total Posts:      12
          Total Questions:      8 (7 unresolved)

          Close the threads if answered, Keep the forum clean.
          • 2. Re: ORA-00349: failure obtaining block size
            891445
            Since we have done the changes on primary, I want to keep the standby alike to primary.

            I am not sure if this is matters when we change the roles.
            ie.,If we change the role, I dont want the standby (or primary when role changed) to be run with Smaller redo-log files.


            Thanks for your answer. I was having problem with the Disk group. Now it is resolved.