yes - you need to copy ALL the dbf files - and the control files as well.
"K. C." <the_ada_at_hotmail.com> wrote in message
news:be879ba7.0201231808.41858a43_at_posting.google.com...
> Do I need to copy the system dbf as well? Like USER.dbf,
SYSTEM.dbf...etc?
>
> Thanks.
>
> "Fergus" <sinhask_at_swbell.net> wrote in message
news:<Xbr38.581$KP2.266498189_at_newssvr12.news.prodigy.com>...
> > shutdown oracle - shutdown abort would do
> > just copy the database (dbf) files, control files etc on to the original
> > location.
> > startup the database
> >
> >
> > "K. C." <the_ada_at_hotmail.com> wrote in message
> > news:be879ba7.0201221756.3c660dc2_at_posting.google.com...
> > > I have a question with regards to restoring a database (Oracle9i) on
> > > Unix. Say I have the cold backup of the database (datafiles, system
> > > datafiles, control file...etc). What's the easiest way to restore the
> > > database? I know that on NT, you can run the oradim utility to create
> > > the instance but I don't think that utility is available for Unix. Is
> > > there any other utility that I can use?
> > >
> > > Thanks in advance.
> > >
> > > KC
Received on Wed Jan 23 2002 - 23:20:17 CST
