Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> V$ for control files
I am trying to write a universal backup script that I can run from one machine and point at multiple instances of oracle. I need to be able to query the location of all data, control, and redo log files. I have the data and redo log files by querying the v$datafile & v$logfile views but can't seem to find a view for the control files. The sgadefinstance.dbf file is another file that seems to be another file that I can't find in the database.
Any help is appreciated, David Received on Tue Jan 28 1997 - 00:00:00 CST
![]() |
![]() |