1.list 显示命令
RMAN> list backup; --显示备份 # lists backup sets, p_w_picpath copies, and proxy copies
RMAN> list backupset; --显示备份集 # lists only backup sets and proxy copies
RMAN> list copy; --显示(镜像拷贝的备份) # lists only disk copies
RMAN> list backupset of tablespace newtbs;
-----------------------------------------------------------------------------------------------------------------
RMAN> show device type; --查看rman配置信息
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
RMAN> configure device type disk parallelism 1 backup type to copy; --修改默认属性
-----------------------------------------------------------------------------------------------------------------
2.report 报告命令
RMAN> report schema; --显示可备份的目标; 策略,
RMAN> report obsolete; --显示那些不再需要的备份文件;
3.delete 删除命令
RMAN> delete obsolete;
4.backup
RMAN> backup tablespace newtbs;
RMAN> backup datafile 10;
RMAN> backup database;
5.resotre 备份还原
RMAN> restore tablespace newtbs; --将数据文件 cp 到原来的地方并覆盖源文件
6.recover 修复
RMAN> recover tablespace newtbs; --跑日志,修复scn
本文标题:RMAN的基本命令
文章分享:
http://bzwzjz.com/article/peehii.html