Oracle归档已满的处理办法
SqlPlus:
/ as sysdba
select * from V$FLASH_RECOVERY_AREA_USAGE;
show parameter log_archive_dest;
show parameter recover;
Rman:
connect target /
delete archivelog until time
'sysdate-7';
SqlPlus:
/ as sysdba
select * from V$FLASH_RECOVERY_AREA_USAGE;
show parameter log_archive_dest;
show parameter recover;
Rman:
connect target /
delete archivelog until time
'sysdate-7';