C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on 星期一 3月 9 11:22:25 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
已连接。
SQL> select open_mode from v$database;
select open_mode from v$database
*
第 1 行出现错误:
ORA-01012: not logged on
进程 ID: 0
会话 ID: 0 序列号: 0
定位到错误根源：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 断
开
恢复管理器: 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
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2020-3-9 13:46:38
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对