What I can do after lost rollback files?


I'm new to DBA stuff, and I've hit a problem.  One
of my hard drives failed and needed replacing.  The disk that failed
contains my rollback info and I've discovered to my horror that NTbackup
failed to backup anything from that drive (I assume it's because the
database was never shutdown).  None of the other disks were affected so all
other datafiles are OK

As a result of this Oracle won't start, I'm assuming that this is because of
the missing files.  Is there any way for me to start Oracle without the
rollback files and recreate them?  Or is there another solution.



Ans:

I think you can proceed this way.
1) Modify your init.ora and remove the entry for those rollback segments.
2) Mount the database and do
alter database datafile offline drop;
3) May be you have to drop the tablespace also once you open the database. I
dont remember exactly.
You wont be able to recover anything, but atleast you can open your database.

Hosted by www.Geocities.ws

1