instance和media损坏恢复-RMAN（二）

13.列出所备份内容

 rman>list backup

 

14.备份数据库

RMAN> backup database format 'e:/oracle/bak/md_%U';

 RMAN > backup database plus archivelog format 'e:/oracle/bak/md_%U';

 

15.备份数据文件

 1、显示文件大小及编号（或在v$datafile）

  RMAN> report schema;

 

2、RMAN> backup datafile 4,5 format 'e:/oracle/bak/md_%U';

    或

    RMAN > back datafile '/opt/oradata/orcl/user.dbf' ,'/opt/oradata/orcl/example.dbf' format 'e:/oracle/bak/md_%U';

 

16.备份表空间

 RMAN > back tablespace users,example format 'e:/oracle/bak/md_%U';

17.备份控制文件

 RMAN > back current controlfile;

或

 RMAN > back datafile 5 include current controlfile;

或

 RMAN > sql "alter database backup controlfile to ''/tmp/orcl/xxx.bin''";

 

17.备份归档文件

 RMAN > backup archivelog all format  'e:/oracle/bak/md_%U' delete all input(删除归档文件);

或

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

 

18.并发备份

 RMAN > run {

  allocate channel c1 type disk;

  allocate channel c2 type disk;

  allocate channel c3 type disk;

  backup incremental level  = 0

  format '/u01/backup/P_%U'

 (datafile 1 channel c1 tag='sys')

 (datafile 3 channel c2 tag='aux')

 (datafile 2,4,5 channel c3 tag = 'other');

sql 'alter system archive log current'; 

}

或

RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;

 

19.备份多份

 RMAN > backup copies 2 datafile 5 format '/u01/b1/d_%U','/u01/b2/d_%U';

 

20.镜像备份

RMAN > copy datafile 5 to '/u01/b1/orcl.dbf' tag='example';

RMAN > list copy