oracle数据库，熟悉rman命令创建备份

1. 设置并行度， 并行度大于表空间文件数量(dba_data_files)

CONFIGURE DEVICE TYPE DISK PARALLELISM 12 BACKUP TYPE TO BACKUPSET; 

1. 配置恢复窗口保留时间，比如需要恢复一周以内的数据

CONFIGURE RETENTION POLICY TO recovery window of 7 days;

1. 备份数据库

 backup as copy tag '1D_WHOLE_INCR0' incremental level 0 database;

1. 备份归档日志

backup tag '2D_arch' archivelog all not backed up delete all input;

1. 查看备份

List backup

List copy

1. 增量备份

backup tag '3D_WHOLE_INCR1' incremental level 1 database;

1. show parameter control_file_record_keep_time  #
2. 将1级备份合并到0集备份

recover copy of database  with tag '1D_WHOLE_INCR0'

1. crosscheck datafilecopy all  
2. 备份控制文件： SQL>alter database backup controlfile to trace as ‘/home/oracle/backup/c01orcl/control.sql’

• 备份

• 0级备份

RMAN> run {

2> allocate channel  "ch1" device type disk format

3> "/home/oracle/backup/c01orcl/%U";

4> backup as copy tag 'base01' incremental level 0 database;

5> }

• 1级备份

RMAN> run {

2> allocate channel  "ch1" device type disk format

3> "/home/oracle/backup/c01orcl/%U";

4> backup tag 'incr_update_1' incremental level 1 database;

5> }

• 合并备份

RMAN> run {

2> allocate channel "ch1" device type disk format

3> "/home/oracle/backup/c01orcl/%U";

4> recover copy of database with tag "BASE01";

5> }