ora-00257 默认的 db_recovery_dest 满 用户不能登入 （解决）

This afternoon, customer had faced one problem:

The user can not not connect to database,
ora-00257 error log occur:

Caustion:
  The achivelog is full
 
  1: Even we delete the archivelog from OS level, the user still can not connect to database.
  Reason:
    The RMAN dose not know you the database had delete the backup or archivelog.
   
Solution:(one of below is okay)
  1:execute below comamnd to delete the archivelog from phishicay and logic:
    RMAN>delete archivelog until time 'sysdate -7';
   
  2: Extend the recovery_archivelog size:
    alter system set DB_RECOVERY_FILE_DEST_SIZE=10G (the default setting is 2G)
   
  3: alter database flashback off
 
Summary:
  Finally, alter system to generate the archivelog:
  alter system switch logfile;