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 full again

yxes2013Oct 9 2013 — edited Oct 9 2013

Hi all,

11.2.0.1

Aix 6.1

Our database hangs again due to archive log full.

I remove everything in the fast_recovery_area so the size will be free

and shutdown abort the database, but still the same error:

SQL> startup

ORACLE instance started.

Total System Global Area 6196547584 bytes

Fixed Size                  2232952 bytes

Variable Size            3657436552 bytes

Database Buffers         2516582400 bytes

Redo Buffers               20295680 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 7078052

Session ID: 125 Serial number: 5

Please helppp....

Thanks,

zxy

This post has been answered by user10274093 on Oct 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2013
Added on Oct 9 2013
19 comments
4,138 views