restore of incremental backup

[Former Member]

Hello

We have problem with restore of incremental backup(of corse with RMAN).

Is there any short guide with screenshot.

Namely we have problem when restoring (re Restore and Recovery-> complete database recovery->..Backup Utility->Detail liog@ summary log)file then we choose all between last incremental and last full backup,

We tried to restore init<sid>.ora, init<sid>.sap, spfile<sid>.ora, init<sid>. utl, back<SID>and log, space<SID>.log(which all were on disk already)

again we restored Detail liog@ summary log and control file as well as archive log(we also restored Profile and log files of of backup BRARCJHIVE and BRBACKUP.

When opting then point in time recovery with last seq not long after last incremental backup.

After restored we had problem openning database (like the last archive log which is not backed uped is missing). evevn resetlog did not function...

So is there any step by step guide for recovery and restore of incremental backup(and archive log files afterwards)

Thank you a lot in advance

[volker_borowski2]

Hi,

first of all: You need a binary controlfile containing the cataloged rman backup to restore an rman run.

second of all: If the INCR backup had been taken online, you need all the online logs that have been written

during this incr backup at minimum and any additional ones to carry on further.

In general a brrecover run should do all the steps required for a desaster recovery.

But in case you like to go manual:

We do util_file - Full backups and rman_util - INCR backups and util_file Redolog Backups

Given that backint works already again and you have restored all the protocoll files, you do

brrestore -m 0 -b xxxxxxxx.inr (restore control file from incr backup run)

brrestore -m all -b yyyyyyyy.fnf (restore DB from full backup without controlfile (ALL, not FULL))

"startup mount" the DB (to be able to use RMAN

brrestore -b xxxxxxxx.inr (apply the incr backup)

brrestore -a xx-yy (restore required redologs)

"recover database using backup controlfile until ..." (apply required redologs)

"open restlogs"

You will only require NO redologs after the INCR rman restore, when the INCR backup had been taken OFFLINE !!!

Hope this helps

Volker

[Former Member]

see if following link helps you.

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/97a4f439-0d01-0010-d488-d29b45e2f5ab?quicklink=index&overridelayout=true]