重庆分公司,新征程启航

为企业提供网站建设、域名注册、服务器等服务

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://cqcxhl.cn/article/peehii.html

其他资讯

在线咨询
服务热线
服务热线:028-86922220
TOP