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

From: <quillen_at_my-deja.com>
Date: 2000/05/09
Message-ID: <8f9snh$vbn$1@nnrp1.deja.com>#1/1

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 Tue May 09 2000 - 00:00:00 CDT