Solved

oracle database files location

Posted on 2013-02-07
7
404 Views
Last Modified: 2013-02-07
I am not an oracle DBA but is there any easy way to determine where on the server, the actual database file(s) (is there more than one, for SQL server it is mdf and ldf?) are housed? i.e. a command or a query?

What are the risks if the datbase files are on say for example a share that everyone group has access to, can users copy the database files and gain access to the data - or is that a bit far fetched?
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 167 total points
ID: 38864062
Actual data files:
select file_name from dba_data_files;
select file_name from dba_temp_files;


Now there are additional files like online redo logs, controlf iles, spfile (database parameters).  Do you want these as well?
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 167 total points
ID: 38864069
you'll have to look in various places depening on the file types

select * from dba_data_files
select * from dba_temp_files

you can find other files like archive logs, and control files by looking in v$parameter
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38864079
Just in case, the spfile and controlf files:
select name,value from v$parameter where name in ('spfile','control_files');

Online redo logs:
select member from v$logfile;
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 3

Author Comment

by:pma111
ID: 38864090
If a malicious admin or through poor acl a user can get file system access to these files, what's the risk?? What could they do with the files??
0
 
LVL 3

Author Comment

by:pma111
ID: 38864102
And how about oracle backups, where could you see any rman jobs configured and where its outputting the backup file to. And if the backup file is going to an insecure share, what's the risk?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38864108
>>What could they do with the files??

Delete them?
Copy them and they have your data.

>>where could you see any rman jobs

You can use RMAN list and report commands to see where they are going.

>>And if the backup file is going to an insecure share, what's the risk?

I can take your backups and restore them to my server.
I can delete them.
0
 
LVL 23

Assisted Solution

by:David
David earned 166 total points
ID: 38864121
"... then there's trouble in River City, friends...."

With enough privileges, any file on a storage system / drive is readable; writeable; and eraseable.  Your malicious admin could do the same with the backups.  So, it's generally a good idea to keep admins content and well rewarded.

Somewhat tongue-in-cheek to your question, but the real answer is a data bank can be destroyed in seconds.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Help with Data Warehouse / Data Marts 4 42
only show the last 365 days 6 35
databases from multiple applications - same instance 6 40
User Prompt in Vertica SQL (vsql) 1 39
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question