如何利用scn增量備份實現Oracle資料庫增量恢複

資料庫版本

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

全備資料庫

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 current 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

建立測試資料庫驗證恢複標準

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(*)