This discussion is archived
8 Replies Latest reply: Feb 4, 2013 3:13 AM by Sebastian Solbach (DBA Community) RSS

Restore and recovery full database.

lm*422407*sh Newbie
Currently Being Moderated
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 Pro
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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) Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points