路過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.