6 Replies Latest reply: Feb 26, 2013 9:37 AM by clcarter RSS

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

    tanvir ahmed
      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
          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
            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....
              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
                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
                  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
                    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.