2011-11-28ORACLE维护日志

关闭日志回闪；

alter database flashback off;

 

解决ORA-01507

alter database clear unarchived logfile '/usr/oracle/oradata/TEST/test/redo03.log';

 

解决ORA-00257

检查flash recovery area使用情况。

select * from v$FLASH_RECOVERY_AREA_USAGE;

清理ARCHIVELOG

cd /usr/oracle/flash_recovery_area/test/archivelog

 

RMAN释放空间

rman target sys/pass

检查一些无用的archivelog

crosscheck archivelog all;

删除过期的归档

delete expired archivelog all;

删除截止到前一天的所有archivelog

delete archivelog until time 'sysdate-1';

 

恢复noarchive log

shutdown immediate;

startup mount;

alter database noarchivelog;

alter database open;

shutdown immediate;

 

启动archive log模式

shutdown immediate;

startup mount;

alter database archivelog;

alter database open;

 

删除一些archlog log

select group#,sequence# from v$log;

alter database clear unarchived logfile group 1;

alter database open;

 

指定archivelog位置

select name from v$datafile;

alter system set log_archive_dest='' scope=spfile

 

查看大小

show parameter recover;

 

修改大小

alter system set DB_RECOVERY_FILE_DEST_SIZE=20G;