FIX-ORA-00257

 FIX-ORA-00257 

[oracle@adcp ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 22 12:28:55 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1195
Next log sequence to archive   1195
Current log sequence           1197

SQL> sho parameter db_recovery_file;

NAME                     TYPE     VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest             string     /oracle_data/u01/app/oracle/fl
                         ash_recovery_area
db_recovery_file_dest_size         big integer 10G

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@adcp ~]$ df -h /oracle_data/u01/app/oracle/flash_recovery_area
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup_Oradata-LogVol_oracle
                      900G  110G  746G  13% /oracle_data

[oracle@adcp ~]$ du -sh /oracle_data/u01/app/oracle/flash_recovery_area
8.7G    /oracle_data/u01/app/oracle/flash_recovery_area

[oracle@adcp ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 22 12:31:21 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set db_recovery_file_dest_size = 20g;

System altered.


OR
 
We can use following steps for this
1. find the location of Archive destination by
 show parameter archive_dest

 lets say it provide  LOCATION=/u10/oradata/mydb/arch

2. move some files to some other location using os command
 cd /u10/oradata/mydb/arch
 mv /u10/oradata/mydb/arch/* /u15/oradata/mydb/arch-bkp/


Or it can be done using RMAN also

rman target /

RMAN> backup archive log all format '/u15/oradata/mydb/arch-bkp';

RMAN> delete archive until time 'trunc(sysdate)';