Oracle hangs on ALTER DATABASE OPEN RESETLOGS; when atempting to open the database. Thanks

[Indira Aramandla]

Hi,

An I/O failure could be of any reason. Soem of the reasons coule be......

1. Check that the file is accessible. Correct the file/device as indicated by accompanying errors.

2.Possible lack of space on device.

3. May be you have placed your datafiles in a different directory path. You recreated your controlfile and did not list the new location of the redo log groups.

Can you check the script which has the file name and path and verify with the physical name and path of the file.


IA

[Massimo Bianchi]

Hi,
i don't know if you have already solved your problem, but this looks like some files (online logs) are damaged, maybe wrong permission, maybe wrong ownership, maybe they are really messed up by some mars activity :)

Seriuosly: since you have already issued the create controlfile with the resetlogs, you should make sure that those file are fully accessible by oracle, also check directories.


If in need, restore the online redolog, they are the compromised part.

Massimo

[Mike Miller_8]

The next time you try the 'alter database open resetlogs' monitor your other volumes and see if one of them becomes pegged or grows quickly unexpectedly.

Failing this, try doing a fsck on the volume that the log should go on.

= Mike =

[Volker Borowski]

Hi,

by any chance ...
Did you increase the size/number/location of the logfiles in your sourcedb and did not adjust the filesystem size/layout on target ?
...and simply run out of space / existing directories ?

Volker