oracle备份核心原理,Oracle RMAN 映像备份（Image copies）基本原理与方案

2、做一些操作，比如创建一个表

SQL> create table rmantest1 as select * from rmantest;

Table created.

SQL> commit;

Commit complete.

SQL> select count(*) from rmantest1;

COUNT(*)

----------

2209792

3、level 1

RMAN>

RMAN> run {

ALLOCATE CHANNEL "ch1" DEVICE TYPE DISK FORMAT "/u04/%U";

BACKUP TAG 'incr_update'

INCREMENTAL LEVEL 1

DATABASE;

}

2> 3> 4> 5> 6>

allocated channel: ch1

channel ch1: SID=37 device type=DISK

Starting backup at 05-SEP-13

channel ch1: starting incremental level 1 datafile backup set

channel ch1: specifying datafile(s) in backup set

input datafile file number=00001 name=/u01/app/oralce/oradata/orcl/system01.dbf

input datafile file number=00002 name=/u01/app/oralce/oradata/orcl/sysaux01.dbf

input datafile file number=00005 name=/u01/app/oralce/oradata/orcl/example01.dbf

input datafile file number=00004 name=/u01/app/oralce/oradata/orcl/users01.dbf

input datafile file number=00003 name=/u01/app/oralce/oradata/orcl/undotbs01.dbf

channel ch1: starting piece 1 at 05-SEP-13

channel ch1: finished piece 1 at 05-SEP-13

piece handle=/u04/0loj3khg_1_1 tag=INCR_UPDATE comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:15

Finished backup at 05-SEP-13

Starting Control File and SPFILE Autobackup at 05-SEP-13

piece handle=/u01/app/Oracle/product/11.2.0/dbhome_1/dbs/c-1349053318-20130905-03 comment=NONE

Finished Control File and SPFILE Autobackup at 05-SEP-13

released channel: ch1

4、update image copy with incremental level 1

RMAN> run {

ALLOCATE CHANNEL "ch1" DEVICE TYPE DISK FORMAT "/u04/%U";

RECOVER COPY OF DATABASE WITH TAG 'BASE01';

}

2> 3> 4>

using target database control file instead of recovery catalog

allocated channel: ch1

channel ch1: SID=32 device type=DISK

Starting recover at 05-SEP-13

channel ch1: starting incremental datafile backup set restore

channel ch1: specifying datafile copies to recover

recovering datafile copy file number=00001 name=/u04/data_D-ORCL_I-1349053318_TS-SYSTEM_FNO-1_0coj3jug

recovering datafile copy file number=00002 name=/u04/data_D-ORCL_I-1349053318_TS-SYSAUX_FNO-2_0doj3jv9

recovering datafile copy file number=00003 name=/u04/data_D-ORCL_I-1349053318_TS-UNDOTBS1_FNO-3_0goj3k0l

recovering datafile copy file number=00004 name=/u04/data_D-ORCL_I-1349053318_TS-USERS_FNO-4_0foj3k0h

recovering datafile copy file number=00005 name=/u04/data_D-ORCL_I-1349053318_TS-EXAMPLE_FNO-5_0eoj3k02

channel ch1: reading from backup piece /u04/0loj3khg_1_1

channel ch1: piece handle=/u04/0loj3khg_1_1 tag=INCR_UPDATE

channel ch1: restored backup piece 1

channel ch1: restore complete, elapsed time: 00:00:15

Finished recover at 05-SEP-13

Starting Control File and SPFILE Autobackup at 05-SEP-13

piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/c-1349053318-20130905-04 comment=NONE

Finished Control File and SPFILE Autobackup at 05-SEP-13

released channel: ch1