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 16038 log 1 sequence# 158249 cannot be archived

467014May 30 2010 — edited Feb 13 2012

hi im getting this error on my database when opening

ORA-16038: log 1 sequence# 158249 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/bill01/app/oracle/oradata/billing/redo01.log

i have tried to free the space but still getting the same error

this are the setting on the init file
*.db_recovery_file_dest='/bill01/oracle/archive/BILLING'
*.db_recovery_file_dest_size=21021851648

on /bill01 ...... i have 131 GB free

any idea

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 12 2012

Added on May 30 2010

#general-database-discussions

19 comments

25,289 views