Eric de Redelijkheid wrote:
> Anno Domini 7-4-2005 18:29, Srini sprak aldus:
>
>> Hi All,
>>
>> I am facing a grim situation, where no backups are available and temp,
>> all redo, one rbs datafiles are corrupted.
>>
>> dat, idx and sys files are ok (checked with dbv)
>>
>> Tried to recover with different options and could not be successful.
>>
>> Do you have any suggestions/solution for this challenge?
>>
>> Thanks,
>> Srini
>>
>>
>>
> How can temp and redo get corrupted?
>
> - shouldn´t you be able to fix the redo logs with an alter system switch
> logfile or if your database is down an alter database open resetlogs?
> - can you drop and recreate the temporary tablespace
> - can you delete the rollback entries out of the init.ora so that after
> a restart of the database you are left only with system rollback?
> - what does the alterlog say?
> - is your database up or down at the moment
> - are you sure that all off the datafiles are in the controlfile. Check
> your V$-views after a startup mount.
The chances of all 3 being corrupted is minimal. The advice to open an
iTAR the same as I'd have given.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Apr 08 2005 - 19:16:08 CDT
