Skip to Main Content
  • Questions

  • HOW TO TAKE BACKUP OF A TABLE WHICH IS BELONGS TO DBF FILE. AND IS IT SAFE TO DO THAT FOR APPLICATION

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, bhargav.

Asked: August 20, 2016 - 7:46 am UTC

Last updated: August 22, 2016 - 10:28 am UTC

Version: oracle 11g

Viewed 1000+ times

You Asked

HELLO SIR,
my name is bhargav reddy from Bangalore,
actually i am a student, i want to know how to take backup of .DBF file which is belongs to live application, so please tell me the process to do that
and one more thing that is it safe to take backup of that data while doing the backup.
please give me some solution.
thank you.

and Connor said...

To backup a single table, use datapump, eg

https://oracle-base.com/articles/10g/oracle-data-pump-10g#TableExpImp

To backup a datafile, you would probably normally be doing more like backing up the database. For that you use RMAN, eg

rman target /
backup database;

but to use RMAN, I'd strongly suggest a good read of the backup/recovery docs

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/toc.htm


Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

thank you

bhargav reddy, August 22, 2016 - 5:53 am UTC

will you please tell me briefly about what is .DBF file?
Connor McDonald
August 22, 2016 - 10:28 am UTC

Whereas *within* the database, we talk about tables and users and the like, ultimately your data must sit on a physical disk somewhere. And those physical disks have file systems, and hence files.

A datafile (in your case, something.dbf) is simply a physical place where we store data.

The Concepts guide is a great read for all of this

http://docs.oracle.com/database/121/CNCPT/toc.htm


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.