How to implement incremental recovery of Oracle database with SCN incremental backup

Database version

Sql> select * from V$version;

BANNER

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

Oracle Database 11g Enterprise Edition release 11.2.0.3.0-production

Pl/sql Release 11.2.0.3.0-production

CORE 11.2.0.3.0 Production

TNS for Linux:version 11.2.0.3.0-production

Nlsrtl Version 11.2.0.3.0-production

Fully-prepared database

Rman> Backup as compressed backupset database format '/u01/oracle/oradata/tmp/ora11g_0_%u ';

Starting backup at 18-apr-12

Using channel Ora_disk_1

Channel ora_disk_1:starting compressed full datafile backup set

Channel ora_disk_1:specifying DataFile (s) in backup set

Input datafile file number=00001 name=/u01/oracle/oradata/ora11g/system01.dbf

Input datafile file number=00002 name=/u01/oracle/oradata/ora11g/sysaux01.dbf

Input datafile file number=00003 name=/u01/oracle/oradata/ora11g/undotbs01.dbf

Input datafile file number=00004 name=/u01/oracle/oradata/ora11g/users01.dbf

Input datafile file number=00006 name=/u01/oracle/oradata/ora11g/xifenfei02.dbf

Channel ora_disk_1:starting piece 1 at 18-apr-12

Channel ora_disk_1:finished piece 1 at 18-apr-12

Piece Handle=/u01/oracle/oradata/tmp/ora11g_0_07n8p916_1_1 tag=tag20120418t234958 comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:01:15

Channel ora_disk_1:starting compressed full datafile backup set

Channel ora_disk_1:specifying DataFile (s) in backup set

Including control file in backup set

Including current SPFILE in backup set

Channel ora_disk_1:starting piece 1 at 18-apr-12

Channel ora_disk_1:finished piece 1 at 18-apr-12

Piece Handle=/u01/oracle/oradata/tmp/ora11g_0_08n8p93h_1_1 tag=tag20120418t234958 comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:00:01

Finished backup at 18-apr-12

To create a test database validation recovery standard

Sql> Conn Chf/xifenfei

Connected.

sql> drop table Xifenfei purge;

Table dropped.

Sql> CREATE TABLE Xifenfei as

2 Select * from Dba_objects;

Table created.

sql> INSERT INTO Xifenfei

2 Select * from Dba_objects;

74534 rows created.

Sql>/

74534 rows created.

Sql>/

74534 rows created.

Sql> commit;

Commit complete.

Sql> Select COUNT (*) from Xifenfei;

COUNT (*)