Re: Disk crashed

Hi Lee,

First delete references to the missing file from the database:

    ALTER DATABASE <db_name>
    DATAFILE '/mnts/disk2/rollback/rollback0a.dbf' OFFLINE DROP;

Add an empty datafile to the tablespace that held the missing file.

If you are doing cold backups there is no need to backup your rollback segments since they only exist to allow the initial contents of tables and indexes to be restored in the event an insert, delete, or update doesn't run to completion.

Get a copy of the DBA Handbook by Kevin Loney and start reading.

Regards
Jerry Gitomer

Lee, YuenFai (BNR:QUAL:7S44) wrote in message <37C532B3.75424A42_at_americasm01.nt.com>...
>Hi,
>
>I'm new to the DBA role currently running Oracle 7.3.4 on
HP10.20. Less
>than two weeks on the job and the rollback segment disk crashed.
>
>Found out the disk does not have any backup, nor there are any
exports
>ever performed on the database.
>
>The missing rollback data file is preventing the database from
starting
>up. I can only go to mount state.
>
>SVRMGR> startup
>ORACLE instance started.
>Total System Global Area 6376352 bytes
>Fixed Size 38984 bytes
>Variable Size 4272984 bytes
>Database Buffers 2048000 bytes
>Redo Buffers 16384 bytes
>Database mounted.
>ORA-01157: cannot identify data file 5 - file not found
>ORA-01110: data file 5: '/mnts/disk2/rollback/rollback0a.dbf'
>
>Is there any way to create a new rollback data file for this
database ??
>
>Thanks in advance.
>--
>
>...Yuen-Fai
>ESN 395-3431
Received on Thu Aug 26 1999 - 09:53:24 CDT