rman备份

1.rman备份整个数据库

C:\Documents and Settings\una>rman target sys/sysdba@demo1 nocatalog

RMAN> backup database format '/u01/rmanbackup/md_%U';

 

2.删除rman备份

RMAN> delete backupset 1,2;

 

3.备份数据库，备份片最大100M，生成3个备份集

RMAN> run {
2>     allocate channel d1 device type disk maxpiecesize=100M;
3>     backup database filesperset 3;
4> }

 

4.查看数据库状况

RMAN> report schema;

 

5.备份数据文件

RMAN> backup datafile 4 format '/u01/rmanbackup/ubackup_%U'; ----备份4号数据文件

RMAN> backup datafile '/u01/app/oracle/oradata/demo1/users01.dbf' format '/u01/rmanbackup/df_%U';

 

6.备份表空间

RMAN> backup tablespace users,system format '/u01/rmanbackup/ts_%U';

 

7.备份控制文件

RMAN> backup current controlfile;

RMAN> backup datafile 4 include current controlfile;

 

8.备份spfile文件

RMAN> backup spfile format '/u01/rmanbackup/sp_%U';

 

9.备份归档文件

RMAN> backup archivelog all format '/u01/rmanbackup/ac_%U' delete all input;

RMAN> backup archivelog sequence between 99 and 199 thread 1 delete input;

RMAN> backup archivelog from time "sysdate-15" until time "sysdate-7";

RMAN> backup database plus archivelog format '/u01/rmanbackup/ac_%U';