It looks like someone tried to copy the file while the database was open.
(and the system was not put in backup mode and the file copy took out a file
lock - not fatal)
1.is file 46 there?'/xcia/disk14/dtws_idx_prod.dbf' (and the size about what
you expect it to be)
2. If so try starting the database in mount mode.
3. taking the datafile offline.
4. doing a recovery on the datafile (hopefully you get media recovery
complete)
5. bring the datafile on line.
6. open the database.
Jim
"Antony Mak" <cheong_at_broadway-ps.com> wrote in message
news:39e8b229_at_newsgate.imsbiz.com...
> 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 - 17:07:40 CDT
