Re: how to parse control files - get listing of dbfs and rdos

The only reason is that some of our DBAs forget to use the proper script and do it "the old fashioned way" and if they do it after adding a dbf file then you have an incomplete list. This has burned us once before while trying to restore from a backup with a missing dbf file.

I would like as close to a full proof automated method as possible for getting a complete list of files (really directories in our case) related to an instance for doing a full backup of that instance. Directory naming standards go along way but don't stop user error when creating dbf files (putting them in the wrong place).

Ed

In article <957969761.27275.0.nnrp-07.c30bdde2_at_news.demon.co.uk>,   "Andrew Williamson" <andrewweb_at_my-deja.com> wrote:
> I can't think of any good reason why you must derive these names
 after the
> instance is shut down. Why not do it in your shutdown script so it
 spits
> them out first? After all, it's not going to change once you've shut
 the
> database down...
>
> select name from v$datafile
> union
> select member from v$logfile
> union
> select name from v$controlfile
>
> <quillen_at_my-deja.com> wrote in message
 news:8f9snh$vbn$1_at_nnrp1.deja.com...
> > I need to get a list of all dbf and rdo files for a given Oracle 7/8
> > instance on a Unix (Solaris) server AFTER the instance has been
> > shutdown.
> >
> > The simple approach of doing a 'strings' on the .ctl files and
 getting
> > a list that way is imperfect (some files get dropped).
> >
> > Is there a better way? Is the format of the .ctl documented
 somewhere?
> > Is there source code (perl/c/whatever) that can parse the control
 files?
> > Is there a simple Oracle util that does this? HINT: I'm a Unix admin
> > not a DBA.
> >
> > Thanks,
> > Ed
> >
> >
> > 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