rman

1.指定日志位置
rman target / log 路径

2.执行SQL

sql '';

3.备份全库
backup database；

4.批处理
run{
}

5.运行脚本

1）rman target / @db_db.rman
2) rman target / cmdfile=
3) rman> @
4)run{ execute script ... }

6.指定备份集的位置

backup database format ''

7.查看备份
list backup of database
list backup of tablespace users
list backup of datafile 3,4
list backup of controlfile

8.删除备份集
delete backupset 10;
noprompt

9.备份表空间
backup tablespace users；

10.备份数据文件
1）.查看数据文件位置
select file_id,file_name from dba_data_files;
2）.备份
backup datafile '+DATA/sztech1/datafile/users.259.825260173';

11.备份控制文件
backup current controlfile;
include current controlfile
configure controlfile autobackup on ;

12.备份归档日志文件
backup archivelog all;
backup current controlfile plus archivelog；
backup current controlfile plus archivelog delete all input;

13.备份参数文件
backup spfile;

14.备份备份集
backup backupset all;
backup backupset n;

ITPub博客

rman备份，基础操作