This discussion is archived
6 Replies Latest reply: Feb 26, 2013 7:37 AM by clcarter RSS

how to take a backup manually in oracle 11g express edition?

tanvir ahmed Newbie
Currently Being Moderated
how to take a backup manually in oracle 11g express edition? i want to take backup of a database and want to restore later on on a different computer .
  • 1. Re: how to take a backup manually in oracle 11g express edition?
    asahide Expert
    Currently Being Moderated
    Hi,

    Stop database, and copy all files to another machine.

    Regards,
  • 2. Re: how to take a backup manually in oracle 11g express edition?
    tanvir ahmed Newbie
    Currently Being Moderated
    SIR,

    I am newbie in oracle database pls explain in some more detail.

    I have same database 11g express edition on two computers at two different locations and want to run same database by taking backup from one compuer and restoring on other computer.

    Regards
  • 3. Re: how to take a backup manually in oracle 11g express edition?
    Aman.... Oracle ACE
    Currently Being Moderated
    tanvir ahmed wrote:
    SIR,

    I am newbie in oracle database pls explain in some more detail.

    I have same database 11g express edition on two computers at two different locations and want to run same database by taking backup from one compuer and restoring on other computer.
    I don't use XE but I think it should be supporting export and import binaries which should be able to do what you are looking for.

    Aman....
  • 4. Re: how to take a backup manually in oracle 11g express edition?
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    I think aman suggestion is the best export database copy the dmp and import . also check the below link :
    http://stackoverflow.com/questions/4883174/taking-backup-of-database-in-oracle-10g-express-edition
  • 5. Re: how to take a backup manually in oracle 11g express edition?
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl see if the documentation can help

    http://docs.oracle.com/cd/E17781_01/server.112/e18804/backrest.htm#i1004902

    HTH
    Srini
  • 6. Re: how to take a backup manually in oracle 11g express edition?
    clcarter Expert
    Currently Being Moderated
    Stop database, and copy all files to another machine.
    That sounds to me to be the closest answer to the question posted. And perhaps the easiest solution.

    Install XE on the "another machine", shut it down. Shutdown the source database. Copy the datafiles to the new host. Startup your "new" database, it will be an exact clone of the original.

    To find out what files need to be copied, as system (or sysdba) run:
    select name from v$datafile;
    ... file1, file2 ...
    show parameter control
    ... control_files ... file1 ... 
    alter database backup controlfile to trace [reset logs];
    ...  
    show parameter diag;
    ... diagnostic_dest ... <drive:>|/diag_path
    To do a proper database clone its better to recreate the controlfile and reset the archive sequence number- leave out the controlfile copy part. In the diag_path location find the trace file under diag/rdbms/$ORACLE_SID/<db_name>/trace it should be the latest ora*.trc file.

    The trace file has the commands to recreate the controlfile, which includes the datafiles and putting the tempfile back in place. If the datafiles are in a different location, i.e. in Windows going to a different drive, or you want do put datafiles in a different folder location, the create controlfile statement is the easiest time to get the file directories right.

    If you add the "reset logs" qualifier (don't use the brackets!) you'll get just the reset logs version of the create controlfile statement, otherwise you'll get both NORESETLOGS and RESETLOGS versions of a create controlfile statement, run one or the other. Not both. Not the entire trace file, just the create controlfile, alter database open [reset logs], alter tablespace temp add tempfile ... bits. No recovery is needed for a database that is shutdown when datafiles get copied to a new location/host.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points