Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Corrupted dbf file... help!!
On Sep 10, 2:32 am, Kaka <kaka...._at_gmail.com> wrote:
> Does the file exist?
> Answer: yes, but the weird thing is, when you try to do fuser on the
> dbf file, apparantly the operating system does not see it.
>
> fuser -cu /u01/oradata/ax5.old/data014.dbf
> /u01/oradata/ax5.old/data014.dbf: fuser: No such file or directory
>
> Did you read the DBWR trace file?
> What does it say?
>
> Answer: (see below)
>
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
> With the Partitioning and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
> ORACLE_HOME = /home/oracle/product/9.2.0
> System name: SunOS
> Node name: ax-db05
> Release: 5.8
> Version: Generic_108528-23
> Machine: sun4u
> Instance name: ax5
> Redo thread mounted by this instance: 1
> Oracle process number: 3
> Unix process pid: 19353, image: oracle_at_ax-db05 (DBW0)
>
> *** SESSION ID:(2.1) 2007-09-09 16:38:37.334
> ORA-01157: cannot identify/lock data file 198 - see DBWR trace file
> ORA-01110: data file 198: '/u01/oradata/ax5/data014.dbf '
> ORA-27037: unable to obtain file status
> SVR4 Error: 2: No such file or directory
> Additional information: 3
>
> Have you opened an SR at metalink?
> Answer: Not yet, i don't have an account. :(
Just curious: how did you manage to upgrade to 9.2.0.3 without Metalink access?
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Sep 10 2007 - 05:04:46 CDT