RMAN Incremental Backup

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

 Table created.

 

 RMAN> run

 {

allocate channel c1 type disk;

allocate channel c2 type disk;

backup incremental level 0 tag=sat database;

}

 

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

 Table created.

 

RMAN> run

 {

 allocate channel c1 type disk;

 allocate channel c2 type disk;

 backup incremental level 1 tag=sun database;

 }

 

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

 Table created.

 

RMAN> run

 {

 allocate channel c1 type disk;

 allocate channel c2 type disk;

 backup incremental level 2 tag=mon database;

 }

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

 

Delete TEST01.DBF

 

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'

 

 RMAN> run

 {

 allocate channel c1 type disk;

 allocate channel c2 type disk;

 restore database;

 recover database;

 alter database open;

 }

 

SQL> desc sat;

 Name                                      Null?    Type

 ----------------------------------------- -------- -----------------

  ID                                                 NUMBER

 

SQL> desc sun;

 Name                                      Null?    Type

 ----------------------------------------- -------- -----------------

  ID                                                 NUMBER

 

SQL> desc mon;

 Name                                      Null?    Type

 ----------------------------------------- -------- -----------------

  ID                                                 NUMBER

 

Comments