5 Replies Latest reply: Oct 14, 2012 10:24 PM by Hemant K Chitale RSS

    Clone a Database

    scottjhn
      Machine One:
      Oracle11g r2 on SUSE Linux 11 standalone server. Created a database db1 on a file system. Database files are backed up in FULL to the hard drive such as /u01/oradata/backup.

      Machine Two:
      Oracle 11g r2 on SUSE Linux 11 standalone server.

      Now, I want to clone the Machine One's backup to Machine Two so that I can use this machine as a testing server. All will be brought over including the users.

      I first did the full backup to /u01/oradata/backup. How can I restore it on Machine Two?

      Would you show me the detailed steps to complete this task? via dbconsole is preferred, other ways ok, too.


      Thanks
        • 1. Re: Clone a Database
          mseberg
          Hello;

          Since you are using Oracle 11 you can use Active duplicate : ( Complete step by step )

          http://www.visi.com/~mseberg/rman/diff_database_duplicating.html

          I'll check my notes for another method.

          I also have this which you would have to change to use with remote, but most of it still applys :

          http://www.visi.com/~mseberg/rman/create_a_duplicate_database_on_the_same_host.html


          Best Regards

          mseberg

          Edited by: mseberg on Oct 13, 2012 12:06 PM
          • 2. Re: Clone a Database
            Shivananda Rao
            Hi,

            You can refer this document http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm which explains you two methods of duplication.

            You can go with the "active database duplication" which does not require you to take the backup of database on machine 1, but since you have already taken it, you can go with "backup based duplication". Both these methods are explained in detail in the document I mentioned above.
            • 3. Re: Clone a Database
              840254
              Hi bro,i have seen this issue before , i have full backup file and i want to clone to another server , but i still not success
              can you give me a solution ?


              Thank,
              Trung Hieu
              • 4. Re: Clone a Database
                asifkabirdba
                http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1008564

                http://www.akadia.com/services/ora_duplicate_database_rman.html



                Regards
                Asif Kabir
                • 5. Re: Clone a Database
                  Hemant K Chitale
                  To copy the backup from Machine 1 to Machine 2, you could either use

                  a. Tape Backups -- have the system administrator copy the folder from Machine 1 to tape and then restore to Machine 2
                  OR
                  b. FTP or SFTP -- have the system administrator enable the FTP services on Machine 2 so that Machine 1 can use the FTP or SFTP client to copy the files across.

                  In either case, you need to have the filesystem on Machine 2 created first. The system administrator can create the file system.



                  Hemant K Chitale