home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!oracle!unrepliable!bounce
- Newsgroups: comp.databases.oracle
- From: kjou@us.oracle.com (Kathy Jou)
- Subject: Re: DB file not in DBA_DATA_FILES - problem
- Message-ID: <1992Jul22.180853.24460@oracle.us.oracle.com>
- Followup-To: kjou@oracle.com
- Sender: Kathy Jou
- Nntp-Posting-Host: hqpyr1.us.oracle.com
- Organization: Oracle Corporation, Redwood Shores CA 94065
- References: <1992Jul21.112252.1@jaguar.uofs.edu>
- Date: Wed, 22 Jul 1992 18:08:53 GMT
- X-Disclaimer: This message was written by an unauthenticated user
- at Oracle Corporation. The opinions expressed are those
- of the user and not necessarily those of Oracle.
- Lines: 29
-
- In article <1992Jul21.112252.1@jaguar.uofs.edu> littlec1@jaguar.uofs.edu (Chris Little) writes:
- >
- >Major problem!! While adding a database file to a tablespace, my main
- >process died. Now upon recovery I see that the DBWR process is
- >accessing that file, but that file's description is not in DBA_DATA_FILES.
- >Also, I doubt the DBWR is writing to it because I HAD to add another file
- >in order to continue extending the database, which is what I was doing
- >in the first place.
- >
- >Any suggestions?
- >
- >--
- >Chris Little, Programmer/DBA
- > University Computing Systems
- > University of Scranton
- > LITTLEC1@JAGUAR.UOFS.EDU Scranton, PA 18510
-
- I would venture to guess that something is inconsistent in the data dictionary.
- If it is at all possible, then the safest action is to recreate the tablespace
- from an export of the objects that currently reside in it. Does the control
- file still recognize this datafile? How did you determine that DBWR is
- accessing that datafile which was not successfully added? Did you perform
- the add datafile operation again, using the same datafile name? If the
- controlfile and dba_data_files match, then things should be OK.
-
-
- Kathy Jou
- Oracle Corporation
-
-