Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using oracle 11g and I need to find the database files to copied to another server. The database was created from migrating from SQL Server 2008 to 11g. There doesn't seem to be a counterpart for sql server's mdf/ldf files.

I read that there are dbf's/ctl's instead but I'm not sure which one is what I need. Also there aren't any files named after the database user that owns the database (after migration, it's the user that has the database) which leaves me puzzled.

I need to know which files are needed so I can copy the oracle database to another remote oracle server easily.

share|improve this question

migrated from May 20 '13 at 19:12

This question came from our site for computer enthusiasts and power users.

@Hennes I only need a guide to get the physical files and I'm not migrating them back to sql server. Sorry if my question is confusing. I need oracle database files to be copied into another oracle server. – Bahamut May 20 '13 at 17:04
select * from dba_data_files, then you need the control files and the init.ora/spfile. You really need a DBA to do this for you though .... – Phil May 20 '13 at 19:18
up vote 1 down vote accepted

An Oracle database uses two basic kinds of disk files - .dbf (data) and .ctl (control) files. You can also have .idx files (for indices). In most environments I've been in, these are located in /u01, /u02, /u03, and on, for however many /u0X's your DBAs had created.

On the other hand, many Oracle installations don't use filesystem files, they use raw disk and ASM storage. If this is the case, you won't ever find any .mdf file analogues. If you look at a process listing when the database is up and you see oracle processes with the string "ASM" in the process name, stop looking for disk files because they're not there.

share|improve this answer
thanks. that explains it. – Bahamut May 21 '13 at 1:26

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.