9 Replies Latest reply: Apr 14, 2012 12:59 PM by 606331 RSS

    how to recovery database by using hot backup

    606331
      Hi All,

      Db:oracle 9i
      os:solaris

      I have taken a database backup as hot backup.i woud like to clone the database to another server by using hot bkp , for that i have restored hot bkp,created init.ora,controlfiles required dir.
      backup taken at 11:30 to 12:00PM
      10 archfile are genrated by that time.
      is it 10 arch files is enough for recovery or any additional files required?
      how to know from which arch logfiles are needs for recovey.
      can anyone help me out.

      thanks,
      dbc.

      Edited by: dbc001 on Apr 14, 2012 8:38 AM
        • 1. Re: how to recovery database by using hot backup
          sb92075
          dbc001 wrote:
          Hi All,

          Db:oracle 9i
          os:solaris

          I have taken a database backup as hot backup.i woud like to clone the database to another server by using hot bkp , for that i have restored hot bkp,created init.ora,controlfiles required dir.
          backup taken at 11:30 to 12:00PM
          10 archfile are genrated by that time.
          is it 10 arch files is enough for recovery or any additional files required?
          how to know from which arch logfiles are needs for recovey.
          can anyone help me out.
          You will be prompted if Oracle can not locate the needed files
          • 2. Re: how to recovery database by using hot backup
            imran khan
            Best option is to used RMAN utility for performeing cloning or taking backups . RMAN has enormous features . Use that utility.

            As far as your question is concerned , yes you need only ten archive logs for recovery , perform the following :


            sql> ALTER DATABASER RECOVER AUTOMATIC USING BACKUP CONTROLFILE UNTIL CANCEL;

            It applies all the required logs present in the control file.


            REgards,
            imran khan
            • 3. Re: how to recovery database by using hot backup
              606331
              Hi,

              thanks for your quick reply...

              backup details:
              15 datafiles...
              controlfile....is controlfile backup required?
              otherwise we can create "create controlfile cmd..."? ...

              how does oracle know the arch files location......

              thanks,
              dbc.

              Edited by: dbc001 on Apr 14, 2012 9:09 AM
              • 4. Re: how to recovery database by using hot backup
                sb92075
                dbc001 wrote:
                Hi,

                thanks for your quick reply...

                how come oracle knows the arch files location......
                Oracle knows/remembers where both REDO & ARCHIVED files reside when backup was taken.
                • 5. Re: how to recovery database by using hot backup
                  imran khan
                  The archive log information will be present in the control file and it also keep the information of absolute paths of datafiles & online redolog files as well. Please read the documentation of controlfiles from oracle.

                  http://docs.oracle.com/cd/B19306_01/server.102/b14231/control.htm




                  Regards,

                  imran khan
                  • 6. Re: how to recovery database by using hot backup
                    606331
                    thanks for ur quick reply...
                    i want to clone database by using fresh controfile....
                    am following below steps
                    1)restore of hot backup from prod
                    2)nessasary dir are created and init.ora file created as per the cloning
                    3)create controlfile.....
                    i have taken create controlfile from prod by using sql>alter database backup controlfile to trace as "..."

                    4)i would like to open the database like below ....
                    sql>recover database using BACKUP CONTROLFILE until cancel;

                    is it any controlfile backup prod is it required ?or from trace copy we can open database?

                    5)alter database open resetlogs;

                    plase correct me if am wrong...
                    • 7. Re: how to recovery database by using hot backup
                      Girish Sharma
                      I think below link will answer you :
                      http://www.shutdownabort.com/quickguides/clone_hot.php

                      Point No. 12
                      recover database using backup controlfile until cancel

                      When prompted to 'Specify log' enter 'auto'. Oracle will then apply all the available logs, and then error with ORA-00308. This is normal, it simply means that all available logs have been applied. Open the database with reset logs:

                      alter database open resetlogs;

                      ...
                      ...

                      But, I will suggest you to clone the database by RMAN which is more simpler and popular way though.

                      Regards
                      Girish Sharma
                      • 8. Re: how to recovery database by using hot backup
                        imran khan
                        your steps are correct and one thing you have to remember that when you are recovering with following line give the option as "auto" as stated by Girish :

                        SQL> ALTER DATABASE RECOVER AUTOMATIC USING BACKUP CONTROLFILE UNTIL CANCEL;


                        Note : Use RMAN which is very simplest method of cloning. It reduces your job . Try it once then you will realise it. you can get many sites for RMAN cloning.


                        Regards,

                        imran khan
                        • 9. Re: how to recovery database by using hot backup
                          606331
                          thanks Girish for ur quick reply...
                          i have opend the db sucessfully......

                          thanks,
                          DBC.