Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

i'm facing a problem with my oracle 10.2.0 database it's running on HP-UX 11.31

the problem is when ever i try to run

SQL> alter system archive log all;

it show that error alter system archive log all * ERROR at line 1: ORA-16014: log 1 sequence# 88001 not archived, no available destinations ORA-00312: online log 1 thread 1: '/oracle/u01/app/oracle/oradata/OVPI/redo01.log

then i googled and found that i can increase the size of the recovery_file, it was 3G so i did change it to be 4G

then i got this error ORA-16038: log 1 sequence# 88016 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 1 thread 1: '/oracle/u01/app/oracle/oradata/OVPI/redo01.log'

the problem is when ever i increase the size , some new files added and fill the space and i got the same error with a new sequence number .. how to solve this please

this problem is affecting my db and my backup operation too

share|improve this question
Are you removing archived log files once they have been backed up (possibly multiple times)? If not then you'll eventually run out of space however much you allocate. – Alex Poole Jun 21 '12 at 11:39

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.