SQL> startup
ORACLE 例程已經啟動
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
數據庫裝載完畢
ORA
ORA
ORA
Thu Feb
Errors in file d:\oracle\product\
ORA
Thu Feb
Errors in file d:\oracle\product\
ORA
Thu Feb
************************************************************************
You have following choices to free up space from flash recovery area:
Thu Feb
************************************************************************
then consider changing RMAN ARCHIVELOG DELETION POLICY
You have following choices to free up space from flash recovery area:
BACKUP RECOVERY AREA command
reflect the new space
then consider changing RMAN ARCHIVELOG DELETION POLICY
system command was used to delete files
DELETE EXPIRED commands
************************************************************************
BACKUP RECOVERY AREA command
Thu Feb
Errors in file d:\oracle\product\
ORA
ORA
從上面信息知道是flash recovery area閃回恢復空間中默認
SQL> exit
從 Oracle Database
With the Partitioning
C:\Documents and Settings\mengzhaoliang>rman target/
恢復管理器: Release
Copyright (c)
已連接到目標數據庫: ORCL (DBID=
RMAN> list archivelog all;
使用目標數據庫控制文件替代恢復目錄
已存檔的日志副本列表
關鍵字 Thrd Seq S 短時間 名稱
RCL\ARCHIVELOG\
RCL\ARCHIVELOG\
RMAN> delete archivelog all;
釋放的通道: ORA_DISK_
分配的通道: ORA_DISK_
通道 ORA_DISK_
已存檔的日志副本列表
關鍵字 Thrd Seq S 短時間 名稱
RCL\ARCHIVELOG\
是否確定要刪除以上對象 (輸入 YES 或 NO)? yes
已刪除的存檔日志
存檔日志文件名 =D:\ORACLE\PRODUCT\
_
RMAN> exit
恢復管理器完成
C:\Documents and Settings\mengzhaoliang>sqlplus
SQL*Plus: Release
Copyright (c)
連接到:
Oracle Database
With the Partitioning
SQL> alter database open;
數據庫已更改
數據庫已經打開!
From:http://tw.wingwit.com/Article/program/Oracle/201311/18516.html