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
Michal
Messages: 2
Registered: September 2002
Junior Member
Hello,

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.

Thanks

Michal

Report message to a moderator

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
Grant
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

Report message to a moderator

Previous Topic: Two users similar... which destroy?
Next Topic: Re: Codd's Rule of RDBMS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 22:21:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.