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博客 ” ,链接:http://blog.itpub.net/28889722/viewspace-1413154/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28889722/viewspace-1413154/