Re: Disk crashed

Jerry

I'm sorry, but I have to disagree with a couple of points you made here.

Firstly, if the database was shutdown abort as opposed to cleanly, then the recovery approach needed is completely different. This is one that as a newcomer to the DBA world, the original poster really should contact Support to make sure they end up with a non-corrupted database.

Secondly, while seasoned DBA's sometimes take the approach of not backing up the rollback segment tablespace, I've generally found this to cause more problems than it's worth. All you're saving is a bit of time and disk space. Again, as a newcomer to the DBA world, it would be a lot easier for the original poster to back upi everything, and then restore it all if needed.

Other viewpoints as always welcome!

Pete

Jerry Gitomer wrote:

> 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 - 11:06:18 CDT