归档日志报错解决方法

ORA-16038: log 3 sequence# 3210 cannot be archived
ORA-19502: write error on file "", block number  (block size=)
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orcl/redo03.log'

alter database clear unarchived logfile group 3;
alter database open;

 

闪回空间不过

SQL> startup mount    数据库启动到mount下

SQL> alter database flashback on (off);  开启关闭闪回区

注：如遇到38706事件错误，可能是因为归档不正确。先启用归档

SQL>alter database archivelog

SQL> alter system set db_flashback_retention_target=2880 修改闪回时间，默认是1440  闪回时间是指数据库能回退的时