list backup;      --顯示備份 # lists backup s..."/>
溫馨提示×

溫馨提示×

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

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

RMAN的基本命令

發(fā)布時間:2020-04-09 17:00:28 來源:網絡 閱讀:544 作者:ElanAir 欄目:關系型數(shù)據庫
  
  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; 			--將數(shù)據文件 cp 到原來的地方并覆蓋源文件

6.recover	修復
	RMAN> recover tablespace newtbs; 		    --跑日志,修復scn	


向AI問一下細節(jié)

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

AI