Home » Other » General » All files managed by Oracle instance
All files managed by Oracle instance [message #102761] Mon, 23 September 2002 21:54 Go to next message
Messages: 2
Registered: September 2002
Junior Member

I would like to know how can one find out the list of ALL files related to Oracle instance. The purpose might be to know what should be backed up.
For example I know some systems on mainfrme where you can ask:
"Give me the list of all files managed by such a system" and you will get the list.
Of course DBA should know which files/directories he/she has set up. But sometimes there is no documentation and you would have to go through all file options in DBA Studio.


Re: All files managed by Oracle instance [message #102764 is a reply to message #102761] Tue, 24 September 2002 11:46 Go to previous message
Messages: 578
Registered: January 2002
Senior Member
Connect as SYS and query these views for what u want.

v$controlfile - where your control files are
v$logfile - where your redo logs are
v$datafile - where your data files are
Previous Topic: Two users similar... which destroy?
Next Topic: Re: Codd's Rule of RDBMS
Goto Forum:

Current Time: Sun May 26 01:31:51 CDT 2024