分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
31.Oracle深度学习笔记——RMAN备份常用命令
欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/50830867
连接到目标数据库
(不使用恢复目录数据库)
$rman target / nocatalog
显示rman配置
RMAN> show all;
报告目标数据库的物理结构
REPORT
RMAN> report schema;
报告陈旧备份
RMAN> report obsolete;
报告不可恢复的数据文件
RMAN> report unrecoverable;
RMAN>report need backup;
RMAN> report need backup days=1;
RMAN> report need backup incremental=3;
说明:需要多少个增量备份文件才能恢复的数据文件。
RMAN> report need backup redundancy=2;
说明:报告冗余文件小于2次的数据文件
RMAN> report need backup recovery window of 2 days;
报告出恢复需要2天的归档日志的数据文件。
备份脚本
run{
allocate channel c1 type disk format '/home/oracle/rmanbk/%d_%I_%s_%p_%T.bkp';
allocate channel c2 type disk format '/home/oracle/rmanbk/%d_%I_%s_%p_%T.bkp';
backup
(datafile 5 channel c1)
(datafile 6 channel c2);
release channel c1;
release channel c2;
}
列出备份信息
RMAN> list backup;
RMAN> list backup of database;
RMAN> list backup of tablespace table_name;
RMAN> list backup of controlfile;
RMAN> list backup of spfile;
RMAN> list backupset id;