Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2226416
  • 博文数量: 533
  • 博客积分: 8689
  • 博客等级: 中将
  • 技术积分: 7046
  • 用 户 组: 普通用户
  • 注册时间: 2010-11-26 10:00
文章分类

全部博文(533)

文章存档

2024年(2)

2023年(4)

2022年(16)

2014年(90)

2013年(76)

2012年(125)

2011年(184)

2010年(37)

分类: Oracle

2014-01-08 10:36:21




ORA-16038: log 3 sequence# 37 cannot be archived


ERROR at line 1:
ORA-16038: log 3 sequence# 37 cannot be archived
ORA-19502: write error on file "", blockno  (blocksize=)
ORA-00312: online log 3 thread 1: '/oracle/oradata/aiki/redo03.log'


SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     37
Next log sequence to archive   37
Current log sequence           39
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open

 

------------------------------------------

the manner of solution

SQL> recover database until cancel;
Media recovery complete.

SQL> alter database open resetlogs;

Database altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           2

SQL> startup
ORACLE instance started.

Total System Global Area  385875968 bytes
Fixed Size                  1219568 bytes
Variable Size             113247248 bytes
Database Buffers          268435456 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

 

阅读(774) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~