路過MIS的睏貓

ORA-19815: WARNING: db_recovery_file_dest_size 100.00% used

[oracle@mar bdump]$ sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Fri Mar 24
10:43:41 2006

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



SQL> conn / as sysdba
Connected.
SQL> startup force mount;
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162275532 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
SQL> show parameter recov

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area/
db_recovery_file_dest_size big integer 3G
recovery_parallelism integer 0
SQL> alter system set db_recovery_file_dest_size=4G scope=both;

System altered.

SQL> startup forec open;
SP2-0714: invalid combination of STARTUP options
SQL> startup force open;
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162275532 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.