176835e65d7de8af70.png (566.89 KB, 下载次数: 304)
2020-3-9 13:45 上传
定位到错误根源：ora-19815: WARNING:db_recovery_file_dest_size of 4039114752 bytes is 99.68% used, and has 12749824 remaining bytes available.
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 5344731136 bytes
Fixed Size 2290648 bytes
Variable Size 2701134888 bytes
Database Buffers 2634022912 bytes
Redo Buffers 7282688 bytes
数据库装载完毕。
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:\Users\Administrator>
C:\Users\Administrator>rman target /
恢复管理器: Release 11.2.0.4.0 - Production on 星期一 3月 9 11:30:52 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
已连接到目标数据库: ORCL (DBID=1277427711, 未打开)
RMAN> delete archivelog all completed before 'sysdate-3';
C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期一 3月 9 11:33:57 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
OPEN_MODE
----------------------------------------
MOUNTED
SQL> alter database open;
数据库已更改。
SQL>
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |