Re: URGENT HELP NEEDED. Datafile cannot be read.

A couple of leading questions:

1-Why was the db brought down? Did it crash or was it deliberate? WHy?

2-Does this datafile contain all your rollback segments? or are there other datafiles for the tablespace that contain rollbacks?

3-Has the read/write permissions changed for the file and maybe Oracle can't see it.

In ignorance of other possibilities, mount the database, vary the datafile offline, then open the database. You can then drop the datafile and recreate it. This might work if it contains all your rollback segments or is expansion area for segments located in other files.

I assume from the file name that the file contains only rollback data.

Other thought---if the db is being brought up because of a crash and the system has not been rebooted, there may be a lock on the file from the earlier up time that has not been cleared. A system reboot might do it.

In article <6mq5iq$srn$1_at_news01.deltanet.com>,   "Matt Heiman" <boo_at_deltanet.com> wrote:
>
> I am receiving the following error that is preventing me from being able to
> bring my database online.
>
> SVRMGR> startup;
> ORACLE instance started.
> Total System Global Area 6287564 bytes
> Fixed Size 45836 bytes
> Variable Size 6110656 bytes
> Database Buffers 122880 bytes
> Redo Buffers 8192 bytes
> Database mounted.
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00376: file 12 cannot be read at this time
> ORA-01110: data file 12: 'DKB100:[ORACLE7]ROLLBACKS.DBF'
>
> I am running Oracle 7.3.2.0 on OpenVMS. I have tried to restore the
> datafile from a cold backup, mount the database, recover the datafile and
> then tried to open the database but received the same error. The archive
> files were all applied successfully and I was told that the datafile was
> recovered but ...
>
> Can anyone help this loss soul?
>
> Matt Heiman
> boo_at_deltanet.com
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 24 1998 - 00:00:00 CDT