Thu Jun 05 16:38:38 2014
alter database archivelog
Completed: alter database archivelog
Thu Jun 05 16:39:02 2014
ALTER SYSTEM SET db_recovery_file_dest_size='3G'
SCOPE=BOTH;
Thu Jun 05 16:39:17 2014
alter database open
This instance was first to open
Picked broadcast on commit scheme to generate SCNs
ARCH: STARTING ARCH PROCESSES
Thu Jun 05 16:39:17 2014
ARC0 started with pid=34, OS id=43377
ARC0: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thu Jun 05 16:39:18 2014
ARC1 started with pid=35, OS id=43385
Thu Jun 05 16:39:18 2014
ARC2 started with pid=36, OS id=43387
ARC1: Archival started
Thu Jun 05 16:39:18 2014
ARC3 started with pid=37, OS id=43390
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Thread 1 advanced to log sequence 336 (before internal thread
enable)
Errors in file
/u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_ora_43264.trc:
ORA-19815: WARNING:
db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and
has 0 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.
************************************************************************
Errors in file
/u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_ora_43264.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 1048576 bytes disk space from
3221225472 limit
ARCH: Error 19809 Creating archive log file to '+FLASH'
Errors in file
/u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_ora_43264.trc:
ORA-16038: log 1 sequence# 335 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1:
'+DATA/orcl/onlinelog/redo_1_1.log'
ORA-00312: online log 1 thread 1:
'+FLASH/orcl/onlinelog/redo_1_2.log'
Abort recovery for domain 0
Errors in file
/u01/app/oracle/diag/rdbms/orcl/ORCL2/trace/ORCL2_ora_43264.trc:
ORA-16038: log 1 sequence# 335 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1:
'+DATA/orcl/onlinelog/redo_1_1.log'
ORA-00312: online log 1 thread 1:
'+FLASH/orcl/onlinelog/redo_1_2.log'
ORA-16038 signalled during: alter database open...
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE