Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Archive log not generating in destination.

891135Jul 17 2012 — edited Jul 17 2012
Hi All,
In one of our databases we have been facing the below error for which there is no archive logs in archive destination. But the mysterious thing is log switch is occuring sometimes.

Database version is Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options

Below is the portion of the alert log.

Mon Jul 2 16:25:04 2012
Errors in file /gbdhpb10/oracle/home/admin/gbdhb10d/bdump/gbdhb10d_arc1_15082.trc:
ORA-19510: failed to set size of 502328 blocks for file "/gbdhpb10/oracle/arch/gbdhb10d/arch1_16066_646412782.dbf" (blocksize=1024)
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 9
Mon Jul 2 16:25:04 2012
Errors in file /gbdhpb10/oracle/home/admin/gbdhb10d/bdump/gbdhb10d_arc1_15082.trc:
ORA-19510: failed to set size of 502328 blocks for file "/gbdhpb10/oracle/arch/gbdhb10d/arch1_16066_646412782.dbf" (blocksize=1024)
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 9


Please help to understand the exact issue and how we can get rid of this.

Also when log switch is occuring no archive is getting generated in the destination.

Thread 1 cannot allocate new log, sequence 16276
Private strand flush not complete
Current log# 3 seq# 16275 mem# 0: /gbdhpb10/oracle/redo/gbdhb10d/redo02/redo02.log
Thread 1 advanced to log sequence 16276
Current log# 1 seq# 16276 mem# 0: /gbdhpb10/oracle/redo/gbdhb10d/redo00/redo00.log
Tue Jul 17 01:30:53 2012
Thread 1 advanced to log sequence 16277
Current log# 2 seq# 16277 mem# 0: /gbdhpb10/oracle/redo/gbdhb10d/redo01/redo01.log
Tue Jul 17 01:42:46 2012
Thread 1 advanced to log sequence 16278
Current log# 3 seq# 16278 mem# 0: /gbdhpb10/oracle/redo/gbdhb10d/redo02/redo02.log
Tue Jul 17 01:45:24 2012
Thread 1 advanced to log sequence 16279
Current log# 1 seq# 16279 mem# 0: /gbdhpb10/oracle/redo/gbdhb10d/redo00/redo00.log
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2012
Added on Jul 17 2012
15 comments
1,228 views