8 Replies Latest reply: Feb 4, 2013 5:13 AM by Sebastian Solbach -Dba Community-Oracle RSS

    Restore and recovery full database.

    lm*422407*sh
      In one of the database, ard 25 datafiles got corrputed including system and undo and sysaux datafiles. But we have control file and on line redolog files.

      We have full back up and incremental back up taken recently.

      We have connected the database to rman and


      We gave the following command.

      RESTORE DATABASE.

      do we need to open the database with reset logs after recover database.
        • 1. Re: Restore and recovery full database.
          Mihael
          In one of the database, ard 25 datafiles got corrputed including system and undo and sysaux datafiles. But we have control file and on line redolog files.

          We have full back up and incremental back up taken recently.

          We have connected the database to rman and


          We gave the following command.

          RESTORE DATABASE.

          do we need to open the database with reset logs after recover database.
          No, if the control file is current, not backup.
          • 2. Re: Restore and recovery full database.
            P.Forstmann
            If you can do a complete recovery with all needed archived redo logs you can open database without resetlogs option.

            If you cannot do a complete recovery (if you are missing needed archived redo logs) you must open database with resetlogs option.
            • 3. Re: Restore and recovery full database.
              988681
              Thank you . I need another clarification.
              We have both level 0 and level 1 backup coompleted. we have both the backups.
              As of now restore is in progress.
              Is it restoring from level 0 or level 1.
              If it is level 0 .. is it something we need to restore the level 1 backup also. Can you clarify it.
              • 4. Re: Restore and recovery full database.
                lm*422407*sh
                We have both level 0 and level 1 backup coompleted. we have both the backups.
                As of now restore is in progress.
                Is it restoring from level 0 or level 1.
                If it is level 0 .. is it something we need to restore the level 1 backup also.
                or
                Recover database command will update the datafile from incremebtal backup
                will take care of it.

                Can you clarify it.
                • 5. Re: Restore and recovery full database.
                  P.Forstmann
                  http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmquick.htm#autoId7 says
                  >
                  When restoring incremental backups, RMAN uses the level 0 backup as the starting point, then updates changed blocks based on level 1 backups where possible to avoid reapplying changes from redo one at a time. Recovering with incremental backups requires no additional effort on your part. If incremental backups are available, then RMAN uses them during recovery.
                  • 6. Re: Restore and recovery full database.
                    lm*422407*sh
                    what i am doing is ..

                    RESTORE DATABASE

                    I AM GOING TO DO

                    RECOVER DATABASE
                    ALTER DATABASE OPEN.

                    wiil it work..

                    Still restore is inprogress...
                    • 7. Re: Restore and recovery full database.
                      Mihael
                      what i am doing is ..

                      RESTORE DATABASE

                      I AM GOING TO DO

                      RECOVER DATABASE
                      ALTER DATABASE OPEN.

                      wiil it work..

                      Still restore is inprogress...
                      Yes, it will work, if you have current control file, archivelogs made since last backup and online logs.
                      • 8. Re: Restore and recovery full database.
                        Sebastian Solbach -Dba Community-Oracle
                        Hi,

                        Hopefully you DB is up and running now...

                        I just wanted to point out something to all, who do not frequently do recovery and are like you a little unsure what the best recovery strategy is:
                        Oracle 11.2 database introduced the recovery advisor, which will help you find the optimal recovery strategy, and will also tell you if you will suffer data loss or a complete recovery is possible:

                        http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmrepai.htm

                        Regards
                        Sebastian