Re: Can anyone help me!

Thank you for your reply. But I think the problem may not due to Premissions, file removed, Disk Failure and Filesystem not mounted. I have check it but still get such messages.

Antony

Mark D Powell wrote in message <8s7b7h$pfd$1_at_nnrp1.deja.com>...
>In article <39e7296c_at_newsgate.imsbiz.com>,
> "Antony Mak" <cheong_at_broadway-ps.com> wrote:
>> Can anyone help me how to solve this problem?
>>
>> ORACLE Instance xbpscia (pid = 6) - Error 376 encountered while
 recovering
>> trans
>> action (9, 20) on object 5560.
>> Fri Oct 13 23:22:04 2000
>> Errors in file /xcia/disk2/BDUMP/smon_22152_xbpscia.trc:
>> ORA-00376: file 46 cannot be read at this time
>> ORA-01110: data file 46: '/xcia/disk14/dtws_idx_prod.dbf'
>>
>> --
>> antony_at_broadway-ps.com
>>
>Your database can not read one of its datasets. You need to determine
>why? Premissions? Someone removed the file? Disk Failure? File
>system not mounted?
>
>One you have the file back then you need to perform recovery. The
>amount of work you have to do to perform recovery depends on why Oracle
>can not access the file and what you have to do to get it back.
>
>Being that it appears from the name above to be an index tablespace
>file then you might be able to recover by:
>1) generating all the index source from the dictionary or from your
>souce library
>2) Drop tablespace including contents
>3) Recreate tablespace using same or new file names
>4) Run the index scripts
>
>See the Backup and Recovery manual for guidence before you do anything.
>--
>Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Oct 14 2000 - 14:22:04 CDT