SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 27 11:47:33 2016

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> connect sys/ @MyBase as sysdba
Connected.
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 4 sequence# 20288 not archived, no available destinations
ORA-00312: online log 4 thread 1: 'E:\ORADATA\BOC\REDO04.DBF'

SQL> show parameter log_archive_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_2                   string      service=BOC_PR.LO
                                                 CAL lgwr async NOAFFIRM option
                                                 al reopen=180 valid_for=(onlin
                                                 e_logfiles, primary_role)
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
SQL> 

Tue Dec 27 14:37:31 Russian Standard Time 2016
Errors in file c:\admin\renfin\bdump\boc_arc0_900.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 64424509440 bytes is 100.00% used, and has 0 remaining bytes available.

Tue Dec 27 14:37:31 Russian Standard Time 2016
************************************************************************
You have following choices to free up space from flash 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.
************************************************************************
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Dec 27 14:37:31 Russian Standard Time 2016
Errors in file c:\admin\renfin\bdump\boc_arc0_900.trc:
ORA-16038: log 4 sequence# 20288 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 4 thread 1: 'E:\ORADATA\BOC\REDO04.DBF'

Tue Dec 27 14:37:34 Russian Standard Time 2016
ARC1: LGWR is scheduled to archive destination LOG_ARCHIVE_DEST_2 after log switch
ARCH: Archival stopped, error occurred. Will continue retrying
Tue Dec 27 14:37:34 Russian Standard Time 2016
Errors in file c:\admin\renfin\bdump\boc_arc1_1488.trc:
ORA-16014: log 4 sequence# 20288 not archived, no available destinations
ORA-00312: online log 4 thread 1: 'E:\ORADATA\BOC\REDO04.DBF'