Search This Blog

Total Pageviews

Friday 8 October 2010

ORA-16038: log 1 sequence# cannot be archived

SQL> startup; ORACLE instance started.

Total System Global Area 534462464 bytes
Fixed Size 2146112 bytes
Variable Size 322961600 bytes
Database Buffers 205520896 bytes
Redo Buffers 3833856 bytes
Database mounted.
ORA-16038: log 1 sequence# 187 cannot be archived
ORA-19502: write error on file "", block number (block size=)
ORA-00312: online log 1 thread 1: '/opt/app/oracle/datafile/vihaan/redo01.log'


clear some space in mount point

like find . -atime +2 -exec rm {} \;

Oracle DBA

anuj blog Archive