>>>>>>>>>>>###Errors in file d:\app\baoshengzhu\diag\rdbms\oracle\oracle\trace\oracle_:
天灰歌词ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 4102029312 字节) 已使⽤ 100.00%, 尚有 0 字节可⽤。
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increa db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was ud to delete files, then u RMAN CROSSCHECK and
DELETE EXPIRED commands.
>>>>>>>>>>>>>>>>###
第⼆步：
丰满女人图片lect * from v$recovery_file_dest;
alter system t db_recovery_file_dest_size=10737418240 ---这⾥是改为10G。
alter databa open
exit
第三步：
rman target /
进⼊rman⼯具窗⼝
rman target /
RMAN>crosscheck archivelog all; -- 运⾏这个命令可以把⽆效的expired的archivelog标出来。RMAN>delete expired archivelog all; -- 直接全部删除过期的归档⽇志。
RMAN>delete noprompt archivelog until time "sysdate -3"; -- 也可以直接⽤⼀个指定的⽇期来删除。重新打开数据库：正常使⽤
