1.查看归档模式:
select name,log_mode from v$database;
2.使数据库为归档模式:
1)SQL>SHUTDOWN NORMAL/IMMEDIATE;
2)SQL>START MOUNT;
3)SQL>ALTER DATABASE ARCHIVELOG;
4)SQL>ALTER DATABASE OPEN;
3.删除归档日志:
1. 进入rman
2. connect target /
3. crosscheck archivelog all;
4. delete expired archivelog all;
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
SYSDATA-7,表明当前的系统时间7天前,before关键字表示在7天前的归档日志,如果使用了闪回功能,也会删除闪回的数据。
5)更改db_recovery_file_dest_size的大小
SQL> show parameter db_recovery_file_dest_size
SQL> alter system set db_recovery_file_dest_size=3G;
4. 打开数据库
$ sqlplus / as sysdba
$ startup
阅读(830) | 评论(0) | 转发(0) |