This discussion is archived
2 Replies Latest reply: Feb 23, 2012 8:53 AM by 891445 RSS

ORA-00349: failure obtaining block size

891445 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.

Legend

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