ORA-16038: log 1 sequence# 16 cannot be archived
917666Feb 16 2012 — edited Feb 16 2012Dear All,
I am using oracle database 10g release2 on linux platform............
I am just moving logsegment type object from one tablespace to another tablespace.
But due to low space for redo log file my alter query was hanged on and not completed sucessfully. and the
directory is showing full.
then i abort the query by shutdown database by using shutdown immediate command.
After that when i m trying to startup my databse in normal mode i am getting following error....
ERROR at line 1:
ORA-16038: log 1 sequence# 16 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 1 thread 1:
'/var/oracle/oradata/clone/redofiles/REDO_RLOG_01a.dbf'
ORA-00312: online log 1 thread 1:
'/var/oracle/oradata/clone/redofiles/REDO_RLOG_03b.dbf'
so pls suggest me the solution to resolve this problem.
Edited by: user13144127 on Feb 16, 2012 11:46 AM