Oracle archive log on USE_DB_RECOVERY_FILE_DEST

ORA-02097: parameter cannot be modified 
ORA-16018: cannot use LOG_ARCHIVE_DEST 


error in alert log file


/opt/app/oracle/diag/rdbms/orcl/orcl/trace

=======================================

Fri Oct 28 16:24:14 2011
Errors in file /opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_16275.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4070572032 bytes is 97.07% used, and has 119123968 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Fri Oct 28 16:27:14 2011

=====================================



SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST 



USE_DB_RECOVERY_FILE_DEST ----- try not to use this area for archive log file , system will hang after destination full



SQL> show parameter DB_RECOVERY_FILE_DEST

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /opt/app/oracle/flash_recovery_area
db_recovery_file_dest_size           big integer 3882M



SQL> alter system set log_archive_dest = '/opt/app/oracle/admin/arch';
alter system set log_archive_dest = '/opt/app/oracle/admin/arch'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

SQL> alter system set DB_RECOVERY_FILE_DEST='' ;  ----- unset this value first 

System altered.



SQL> alter system set log_archive_dest = '/opt/app/oracle/admin/arch' scope=both ;

System altered.



SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /opt/app/oracle/admin/arch
Oldest online log sequence     59
Next log sequence to archive   61
Current log sequence           61


SQL> alter system switch logfile;

System altered.



SQL> !ls -ltr /opt/app/oracle/admin/arch
total 153136
-rw-r----- 1 oracle oinstall 156810752 2011-10-29 05:59 1_61_757353423.dbf