连接到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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27771627/viewspace-1247213/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27771627/viewspace-1247213/