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