Recovery from full and incre backups

[Former Member]

Hi All,

We are performing database recovery from the 10 days back full backup file using the below command:

brrestore -d rman_util -b xxxxxx.fnr -m full -c force

AND we are having 9 days incremental backups, please let me know what steps I need to perform further to bring database up and SAP.

Regards,

Karthik.

[Former Member]

Hi,

Incremental backup should be restored in sequence after restoring the full backup.

For example.

If your backup was done as follows:

Full Backup     ------- day 1
Incr. Backup 1 ------ day 2
Incr. Backup 2 ------ day 3
Incr. Backup 3 ------ day 4
Incr. Backup 4 ------ day 5
Incr. Backup 5 ------ day 6

You would restore it as:

Full Backup     ------- day 1
Incr. Backup 1 ------ day 2
Incr. Backup 2 ------ day 3
Incr. Backup 3 ------ day 4
Incr. Backup 4 ------ day 5
Incr. Backup 5 ------ day 6
<Till last incremental backup...>

Hope, it is clear now...

Regards.

Rajesh Narkhede