RMAN Incremental Backup

We are aware RMAN plays an important role in backup strategies  Today we are going to have a look “RMAN Incremental Backup”.

Let’s have look on the steps.

Create table for testing purpose

SQL> create table sat(id number) tablespace test;

Table created.

Create a incremental backup with tag option

RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 0 tag=sat database;
}

Create another table

SQL> create table sun(id number) tablespace test;

Table created.

Create a incremental backup for next run

RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 1 tag=sun database;
}

Create another table

SQL> create table mon(id number) tablespace test;

Table created.

Create a incremental backup for next run

RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 2 tag=mon database;
}

Shutdown the database and delete tablespace

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.


Delete TEST01.DBF

Try to start database

SQL> startup;
ORACLE instance started.
Total System Global Area  167772160 bytes
Fixed Size                  1247876 bytes
Variable Size              79693180 bytes
Database Buffers           79691776 bytes
Redo Buffers                7139328 bytes
Database mounted.

ORA-01157: cannot identify/lock data file 5 - see DBWR trace file

ORA-01110: data file 5: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\TEST01.DBF'

Recover the table

RMAN> run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
restore database;
recover database;
alter database open;
}

Thought of the day 

Life is 10% what happens to you and 90% how you react to it. By Charles R. Swindoll

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp