problem in test database

[anubhav singh]

Hi all,
i m getting following errors messages in my test databases.
while trying to open my database

ORA-16038: log 2 sequence# 462 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 2 thread 1: '/data/prod/redo02.log'

can anybody help me, to understand this situation & give me a proper solution.

regrds

Sahil

[stecal]

Have you looked up the errors in the documentation?

[sankargvs]

can check disk space on the archive log destination ?
i think it is full..

[stecal]

Archive log destination area being full has a different error stack.

[jkoopmann]

this is related to Oracle not being able to write to the desginated file. could be Oracle related or O/S related where the disk might have gone away, have an error on it, or the redo log file is no longer around.

i would check to see if this log file is actually out on disk.

does your database open properly? if so, then i would drop this redo log file and create another one in it's place.

it also might be advantageous for you to switch through the log files to validate that they are in good condition.

[jkoopmann]

also noticed that the location of the redo log in question has a path that includes "prod". is this really your test database.