中文字幕av专区_日韩电影在线播放_精品国产精品久久一区免费式_av在线免费观看网站

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

RMAN的基本命令

發布時間:2020-04-09 17:00:28 來源:網絡 閱讀:545 作者:ElanAir 欄目:關系型數據庫
  
  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	


向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

大渡口区| 林甸县| 垣曲县| 平武县| 梅州市| 宁乡县| 涡阳县| 囊谦县| 青川县| 昌都县| 福鼎市| 玛曲县| 江口县| 景宁| 东平县| 华阴市| 东乌珠穆沁旗| 莱州市| 屯昌县| 唐山市| 成安县| 锡林郭勒盟| 商丘市| 泗水县| 镇江市| 兰西县| 长治市| 高邑县| 青川县| 星子县| 班玛县| 连城县| 历史| 河南省| 尼勒克县| 自贡市| 宜章县| 梅州市| 靖边县| 额尔古纳市| 丰都县|