全部博文(535)
分类: Oracle
2014-01-08 10:36:21
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.