home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!gatech!destroyer!gumby!yale!yale.edu!jvnc.net!netnews.upenn.edu!uofs!jaguar.uofs.edu!littlec1
- From: littlec1@jaguar.uofs.edu (Chris Little)
- Newsgroups: comp.databases.oracle
- Subject: Re: DB file not in DBA_DATA_FILES - problem
- Message-ID: <1992Jul24.144017.1@jaguar.uofs.edu>
- Date: 24 Jul 92 19:40:17 GMT
- References: <1992Jul21.112252.1@jaguar.uofs.edu> <1992Jul22.180853.24460@oracle.us.oracle.com>
- Sender: news@uofs.uofs.edu
- Followup-To: kjou@oracle.com
- Organization: University of Scranton
- Lines: 39
- Nntp-Posting-Host: jaguar.ucs.uofs.edu
-
- > 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?
-
- No. I did a dump of the control file to determine that.
-
- > How did you determine that DBWR is
- > accessing that datafile which was not successfully added?
-
- On VMS I did a $ SHOW DEVICE/FILE {device-name},
- where {device-name} is the name of the disk on which the database files reside.
- This command tells what files are being accesses and by what processes.
-
- > Did you perform
- > the add datafile operation again, using the same datafile name?
-
- Yes, but I got an error saying that that filename already was being used
- by the database.
-
- >If the
- > control file and dba_data_files match, then things should be OK.
-
- This indeed is the case. I shut down the instance and brought it back up again.
- This eliminated the DBWR process that was accessing the file, so I was then
- able to delete the file. I wonder what would have happened if I just killed
- that process at the VMS level, without shutting down the instance.
-
- > Kathy Jou
- > Oracle Corporation
- --
-
- Thank you, Kathy.
-
- --
- Chris Little, Programmer/DBA
- University Computing Systems
- University of Scranton
- LITTLEC1@JAGUAR.UOFS.EDU Scranton, PA 18510
-