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

    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
    Posts
    796
    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:

    http://www.dbforums.com/showthread.php?t=1031644
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

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

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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 http://tahiti.oracle.com.

    A siimple export can be done this way:
    Code:
    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
  •