Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sector size problem when create a "Standby" in Standard Edition

Mr.D.Apr 24 2015 — edited Apr 24 2015

Hi,

I've a primary database 11.2.0.4 Standard Edition with Grid Infrastructure with ASM.

DiskGroup in ASM uses sector size ok 4k.

I've also a "Standby" the uses filesystem with logical and physical sector size of 512.

When duplicate from primary I get this warning:

ORACLE error from auxiliary database: ORA-01378: The logical block size (4096) of file /u03/oradata/ORCL/onlinelog/group_1.268.874153703 is not compatible with the disk sector size (media sector size is 512 and host sector size is 512)

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-01378: The logical block size (4096) of file /u03/oradata/ORCL/onlinelog/group_2.265.874153719 is not compatible with the disk sector size (media sector size is 512 and host sector size is 512)

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-01378: The logical block size (4096) of file /u03/oradata/ORCL/onlinelog/group_3.263.874153759 is not compatible with the disk sector size (media sector size is 512 and host sector size is 512)

RMAN-05535: WARNING: All redo log files were not defined properly.
ORACLE error from auxiliary database: ORA-01378: The logical block size (4096) of file /u03/oradata/ORCL/onlinelog/group_4.261.874153735 is not compatible with the disk sector size (media sector size is 512 and host sector size is 512)

RMAN-05535: WARNING: All redo log files were not defined properly.
Finished Duplicate Db at 2015-04-21 23:37:10
released channel: CH1

I can recreate 3 redologs with correct sector size, but I unable to drop current log file:

ERROR at line 1:

ORA-01623: log 4 is current log for instance ORCL (thread 1) - cannot drop

ORA-00312: online log 4 thread 1:

'/u03/oradata/ORCL/onlinelog/group_4.261.874153735'

So how can I solve this problem?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 22 2015
Added on Apr 24 2015
6 comments
3,650 views