rman备份

来源：互联网发布：js 计算时间间隔毫秒编辑：程序博客网时间：2024/05/01 18:20

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';