Oracle Database Discussions

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!

ORA-00344 (unable to re-create online log) due to OSD-04001 (invalid logical block size (OS 512)

Joe GiambroneFeb 2 2015 — edited Feb 4 2015

Windows (yup..sorry)....Server 2008 Enterprise SP1

Oracle 12.1.0.1

I supplied a vendor a COLD backup and a BACKUP CONTROLFILE TO TRACE file.

When they go to OPEN RESETLOGS they receive the ORA-00344, ora-27040, then the Operating System Dependent (OSD-04001)

I do not have access to the restore site...so I am having the vendor try things....my next step is to change db_block_size to 4096 vs 8192

They are able to build the controlfile : CREATE CONTROLFILE SET DATABASE "XXXXX" resetlogs noarchivelog

the issue is with the open

We even removed the LOGFILE groups to let the o/s build it....still erred....ideas?

This post has been answered by Joe Giambrone on Feb 3 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2015

Added on Feb 2 2015

#general-database-discussions

8 comments

3,950 views