Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: datafile without path affecting backup
I don't know if there is any way to identify which objects belong to which datafile when multiple datafiles service a tablespace. Did you try issue Recover datafile 'filepath/filename'; ?
In article <8fbu3l$6mg$1_at_nnrp1.deja.com>,
dulundell_at_my-deja.com wrote:
> Thanks for the info. We tried renaming/reassigning a path to the
> datafile but received a message that it needed media recovery. The
> tablespace that the datafile is in also has another datafile that we
> definately need. We are unable/don't know how to determine what
> objects are associated with which datafile in the tablespace. We
don't
> think the datafile in question is being used but don't want to get rid
> of it until we are sure what it holds. Do you have any ideas on how
to
> find that out? Thanks in advance.
> Martin
> In article <8f722q$pe3$1_at_nnrp1.deja.com>,
> rspeaker_at_my-deja.com wrote:
> > you can pull the tablespace name and datafile name from
dba_data_files
> > to see if Oracle has a tablespace associated with that datafile. If
> > not, you can alter database datafile 'name' offline drop to make
sure
> > there is no lingering reference to the file inside Oracle, then
remove
> > the OS file. If Oracle does show a tablespace association, then
query
> > dba_segments to see the segment_name, segment_type, and owner of any
> > segments stored in that tablespace. If there aren't any you should
be
> > okay to drop the tablespace, then remove the datafile. If there are
> > segments stored, or you just simply want to keep the file around,
I'd
> > suggest renaming it. Take the tablespace offline, alter database
rename
> > datafile 'old_path/old_name' to 'new_path/new_name' then put the
> > tablespace back online.
> >
> > HTH,
> > Roy
> >
> > In article <8f6tu6$kca$1_at_nnrp1.deja.com>,
> > dulundell_at_my-deja.com wrote:
> > > I have a datafile that has no path associated with it. We cannot
use
> > > the back-up utility until this is resolved. Any ideas on how to
find
> > > out what is there, if a path can be assigned, or even if Oracle is
> > > referencing this datafile for anything? Thanks
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed May 10 2000 - 00:00:00 CDT