RMAN备份（九）

1.备份完整数据库

  backup database;

 

2.0级备份

 backup incremental level=0 database;

 

3.1级备份

backup incremental level=1 database;

 

4.备份archivelog

 backup database plus archivelog delete input

 

5.备份表空间

 backup tablespace users

 

6.备份控制文件

 backup current controfile

 backup database include current controfile

 

7. 查看表空间

  report schema

 

8.镜像备份

 copy datafile 5 to '/u01/rmanbak/tbs01bak/tbs01bak.dbf

 

9.查看镜像备份

 list copy;

 

10.批命令

run{

allocate channel cha1 type disk;

backup

format "/u01/rmanbak/full_%t"

tag full-backup

database;

release channel cha1;

}

 

11.备份规划

第一步：写脚本

 bakl0

run{

allocate channecl c1 type disk;

backup incremental level 0

format "/u01/rmanbak/inc0_%u_%T"

tag monday_inc0

database;

release channel c1;

}

 

bakl1

run{

allocate channecl c1 type disk;

backup incremental level 1

format "/u01/rmanbak/inc1_%u_%T"

tag monday_inc1

database;

release channel c1;

}

 

bakl2

run{

allocate channecl c1 type disk;

backup incremental level 2

format "/u01/rmanbak/inc2_%u_%T"

tag monday_inc2

database;

release channel c1;

}

 

2.设置crontab

crontab -e -u oracle

45 23 * * 0 rman target / msglog=bakl0.log cmdfile=bakl0

45 23 * * 1 rman target / msglog=bakl2.log cmdfile=bakl2

45 23 * * 2 rman target / msglog=bakl2.log cmdfile=bakl2

45 23 * * 3 rman target / msglog=bakl1.log cmdfile=bakl1

45 23 * * 4 rman target / msglog=bakl2.log cmdfile=bakl2

45 23 * * 5 rman target / msglog=bakl2.log cmdfile=bakl2

45 23 * * 6 rman target / msglog=bakl2.log cmdfile=bakl2

 

3.重启crontab

service crond restart