Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008

    Unanswered: how can i backup my database?

    hi! i am a new oracle user. I have an little database and i need to backup it.(My teacher will look it.) can anyboy tell me the way of backup?

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    Andrewst spent a lot of time putting together a sticky called 'Guidance & Resources for Posters' precisely for people like you. Read the sticky, then if you get stuck on any of the technical apsects of backups come back & ask for help.

    Here's the link, as you can't seem to find it:
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    When you read the documentation pay particular attention to RMAN.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Although it is NOT and can NOT be used instead of a proper backup, I believe that - in such a case ("teacher wants to see what I've done so far") - export might do the job quite well.

    "A small database" is probably only one schema and it is quite simple to perform an export, put these several MB on USB memory stick, give it to the teacher, let him import my schema and do whatever he/she wants to.

    If that's acceptable, read something more about the original Export and Import utilities in Oracle 10g documentation; if you use another database version, check its documentation at

    A siimple export can be done this way:
    OS_prompt> EXP username/password FILE=my_export.dmp
    The result - if everything goes well - is export file of your schema.

    Once again: EXPORT IS NOT A BACKUP! Keep that in mind. Here is a link to the complete 10g documentation; if you are interested in backup, check Backup and Recovery manuals.

Posting Permissions

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