oracle无法挂载,ORACLE数据库可mount，但无法open

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