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号
友情链接: 宜宾网站设计 成都网站设计制作公司 企业网站建设公司 成都网站建设 成都网站制作 成都定制网站建设 成都网站建设 成都网站设计 网站设计 四川成都网站设计 成都网站建设 定制级高端网站建设 营销型网站建设 高端网站设计推广 成都网站设计公司 成都网站建设 网站制作报价 高端网站设计 重庆网站建设 网站制作 高端网站设计 网站建设方案