Results 1 to 8 of 8

Thread: DBF files

  1. #1
    Join Date
    Jun 2011
    Posts
    6

    Question Unanswered: DBF files

    I would like to know what is file extension .dbf in Oracle. Is it recommended to backup this file via backup utility NetBackup? Any advise is appreciated!!!!

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Looks like these are datafiles. If you run a database that you wouldn't want to lose, I suppose you'd want to backup these files (among the others). Note that there are also other Oracle database files that should be backed up (such as redo log and control files).

    Perhaps you'd rather do that (database backup, I mean) using RMAN (Recovery Manager, an Oracle utility that can back up, restore, and recover database files).

  3. #3
    Join Date
    Jun 2011
    Posts
    6

    Question Flat backup

    Is backing up these files like a flat backup is recommended?
    Can the Database be recovered if i take a flat file backup of these files?
    Is there any other recommendation or best practices for backing up these files?

    Please advise me on this!!!

  4. #4
    Join Date
    Nov 2006
    Posts
    82
    Like Littlefoot said the best tool for backup is RMAN use that.

  5. #5
    Join Date
    Jun 2011
    Posts
    6

    Talking

    Thank You so Very Much!!!

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    And you should be running your database in archivelog mode.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Jun 2011
    Posts
    6
    Hi Bill,

    I'm a noob in Database, as im a backup administrator. Can you please explain what is archivelog mode?

    Thank you!!!

  8. #8
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •