现象:
问题分析:
备份数据量大,闪回空间磁盘存储不够,导致数据库连接中断
解决办法(SYSDBA):
1、按需删除归档日志信息
su – oracle
rman target /
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog until time 'sysdate-1';
删除log sequence为16及16之前的所有归档日志
delete archivelog until sequence 16;
删除系统时间7天以前的归档日志,不会删除闪回区有效的归档日志
delete archivelog all completed before 'sysdate-7';
删除系统时间1天以内到现在的归档日志
delete archivelog from time 'sysdate-3';
清除所有的归档日志
delete noprompt archivelog all completed before 'sysdate';
清除所有的归档日志
delete noprompt archivelog all;
2、扩充闪回存储空间:
su - oracle
sqlplus / as sysdba;
SQL> show parameter db_recovery_file_dest;
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest string
+DATADG
db_recovery_file_dest_size big integer
312G
SQL>select file_type, percent_space_used as used,percent_space_reclaimable as reclaimable, number_of_files as "number" from v$flash_recovery_area_usage; 查看占用率
SQL>alter system set db_recovery_file_dest_size=500G scope=both;
System altered. 表示执行成功
SQL> show parameter db_recovery_file_dest;
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
db_recovery_file_dest string
+DATADG
db_recovery_file_dest_size big integer
500G
3、数据库恢复连接,再次登录查看目前的使用率
SELECT FILE_TYPE,
PERCENT_SPACE_USED AS USED,
PERCENT_SPACE_RECLAIMABLE AS RECLAIMABLE,
NUMBER_OF_FILES AS "number"
FROM V$FLASH_RECOVERY_AREA_USAGE;