<< 今天考oracle 007這門過關 | 回blog首頁 | perl執行外部指令 >>

2006年03月24日

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.
 

Posted by my_work at 樂多Roodo! │10:53 │回應(2) │引用(1)
樂多分類：網路/3C 工具：編輯本文
Ads by Roodo! 

引用URL

http://cgi.blog.roodo.com/trackback/1307934
引用列表:
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. \r\...
ORA-19815: WARNING: db_recovery_file_dest_size 100.00% used【路過MIS的睏貓 ::PIXNET BLOG::】 at 2007年05月18日 11:45
回應文章
大大要加油哦
Posted by 小朋友 at 2006年03月24日 14:48
多謝你的加油
Posted by 睡貓 at 2006年03月24日 23:43


回最上方