6 Replies Latest reply: Apr 9, 2011 9:55 AM by Hemant K Chitale RSS

    Restore cold backup and RMAN backup

    848715
      Hi,
      I have cold backup as well as RMAN backup. But i don't know how to restore the backup.
      Please anybody send, steps or links for restoring both backups.


      Regs,
      Brijesh
        • 1. Re: Restore cold backup and RMAN backup
          Hemant K Chitale
          The "script" would depend on how the backup was done.

          A cold backup should be a backup of controlfiles and datafiles.
          Was it done using RMAN ? Or done using an OS command (e.g. "cp" or "tar" or "cpio") ?
          A non-RMAN cold backup can be restored with the same command that was used to create the backup. If the backup did not include the Online Redo Log files, you need to simulate a dummy recovery from the SQL command line (RECOVER DATABASE UNTIL CANCEL ; then CANCEL) and ALTER DATABASE OPEN RESETLOGS.
          If the backup was done using RMAN, you need to
          1. RESTORE CONTROLFILE FROM '/location_of_backuppiece'
          2. ALTER DATABASE MOUNT
          3. RESTORE DATABASE
          4. ALTER DATABASE OPEN


          Hemant K Chitale
          • 2. Re: Restore cold backup and RMAN backup
            848715
            Dear Hament,

            I am fresher in DBA field.Colud u please little bit eloberate the answer or if u have some links please send me.


            Regs,
            Brijesh
            • 3. Re: Restore cold backup and RMAN backup
              Hemant K Chitale
              See
              http://hemantoracledba.blogspot.com/2007/05/recovery-in-cold-backup.html
              http://www.freelists.org/post/oracle-l/Controlfile-Recovery-Requires-RESETLOGS,2
              http://hemantoracledba.blogspot.com/2007/05/rollforward-from-cold-backup.html
              http://hemantoracledba.blogspot.com/2008/05/rman-cold-consistent-backup-and-restore.html


              Hemant K Chitale
              • 4. Re: Restore cold backup and RMAN backup
                848715
                Hi,

                Thnx for your reply.

                I am new in this field so i have a lots of doubt.



                1) I have a cold backup, taken by last weak. How can we create database by use of this cold backup.

                After install Oracle, please can you send me step by step procedure from begning.

                2) If I have RMAN backup then how we can create.


                I would be very thankfull.

                Regs,
                Brijesh
                • 5. Re: Restore cold backup and RMAN backup
                  DBA_1976
                  Do you want to restore the same database? or do you want to create another standby database?

                  Do you want to create the standby in same server? or do you want to create a standby in different server? Try this. Mr.Kamran have lots of video tutorials on RMAN backup and recovery and duplicate.

                  http://kamranagayev.wordpress.com/oracle-video-tutorials/


                  http://kamranagayev.wordpress.com/2010/06/25/rman-video-tutorial-series-creating-duplicate-and-standby-database-using-rman/
                  • 6. Re: Restore cold backup and RMAN backup
                    Hemant K Chitale
                    See
                    http://hemantoracledba.blogspot.com/2007/05/recovery-in-cold-backup.html
                    http://hemantoracledba.blogspot.com/2007/05/rollforward-from-cold-backup.html
                    http://hemantoracledba.blogspot.com/2008/05/rman-cold-consistent-backup-and-restore.html


                    Hemant K Chitale