RMAN的基本命令

  
  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

其他资讯

Copyright © 2007-2020 广东宝晨空调科技有限公司 All Rights Reserved 粤ICP备2022107769号
友情链接: 成都网站建设公司 高端定制网站设计 商城网站建设 外贸网站设计方案 成都响应式网站建设公司 成都网站设计公司 响应式网站设计方案 上市集团网站建设 重庆网站制作 重庆手机网站建设 手机网站建设 成都网站制作 定制网站建设 高端网站设计 成都网站设计 成都网站建设公司 成都网站制作 梓潼网站设计 成都企业网站建设 响应式网站设计 成都网站制作 成都网站建设