RMAN Incremental Backup & Recovery

In this article we will be looking at RMAN incremental backup & how to perform database recovery using incremental backup.

• Take RMAN Incremental Backup

• Simulate Failure

• Start Database Recovery

Take RMAN Incremental Backup

Connect to the target DB and catalog. Take level 0 backup

RMAN> backup incremental level 0 database plus archivelog;

Once backup is completed, check backup tag via below command

RMAN> list backup of database summary;

TAG20170115T113749                     -–> L0 Backup tag

Create New User & Table

SQL> create user ogr identified by ogr;
SQL> grant connect, resource, create session to ogr;
SQL> conn ogr/ogr
SQL> create table test(serial number(2),name varchar2(5));
SQL> insert into test values(1,'one');
SQL> insert into test values(2,'Two');
SQL> insert into test values(3,'Three');
SQL> insert into test values(4,'Four');
SQL> commit;

Trigger DB L1 Backup

RMAN> backup incremental level 1 database plus archivelog;

Once backup is completed, check backup tag via below command

RMAN> list backup of database summary;

TAG20170115T114127                     -–> Level 1 Backup tag

Simulate Failure

Delete all the datafiles from server

SQL> select name from v$datafile;

rm -rf <DF locations>

Start Database Recovery

Kill the DB instance, if running. You can do shut abort or kill pmon at OS level

Start the DB instance and take it to Mount stage. Connect to RMAN and issue below command

run
{
RESTORE DATABASE from tag TAG20170115T113749;
RECOVER DATABASE from tag TAG20170115T114127;
RECOVER DATABASE;
sql 'ALTER DATABASE OPEN';
}