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.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24766946/viewspace-701192/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24766946/viewspace-701192/