连接到catalog

rman target / catalog rman/rman@192.168.221.202:1521/catalog

创建备份集

RMAN> backup as backupset format '/rman_bak/sysaux20140303.bak' tablespace sysaux;

Starting backup at 03-MAR-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00002 name=/home/oracle/app/oracle/oradata/sap/sysaux01.dbf

channel ORA_DISK_1: starting piece 1 at 03-MAR-14

channel ORA_DISK_1: finished piece 1 at 03-MAR-14

piece handle=/rman_bak/sysaux20140303.bak tag=TAG20140303T051813 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35

Finished backup at 03-MAR-14

创建压缩备份集

RMAN> backup as compressed backupset format '/rman_bak/sysaux_compressed_20140303.bak' tablespace sysaux;

Starting backup at 03-MAR-14

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=00002 name=/home/oracle/app/oracle/oradata/sap/sysaux01.dbf

channel ORA_DISK_1: starting piece 1 at 03-MAR-14

channel ORA_DISK_1: finished piece 1 at 03-MAR-14

piece handle=/rman_bak/sysaux_compressed_20140303.bak tag=TAG20140303T052219 comment=NONE

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

Finished backup at 03-MAR-14

创建映像副本

RMAN> backup incremental level 0

2> as copy

3> tablespace sysaux;

Starting backup at 03-MAR-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00002 name=/home/oracle/app/oracle/oradata/sap/sysaux01.dbf

output file name=/home/oracle/app/oracle/flash_recovery_area/SAP/datafile/o1_mf_sysaux_9k90s7hg_.dbf tag=TAG20140303T052703 RECID=2 STAMP=841210039

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25

Finished backup at 03-MAR-14

发起备份

RMAN> backup database;

发起压缩备份

RMAN> backup as compressed backupset database;

显示备份

list backup

删掉过期备份

RMAN> delete obsolete;