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

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.
Received on Wed May 10 2000 - 00:00:00 CDT