waterye

RMAN維護(hù)命令

使用RMAN進(jìn)行備份和恢復(fù)的常用命令

連接到目標(biāo)數(shù)據(jù)庫(不用恢復(fù)目錄數(shù)據(jù)庫)

rman target / nocatalog

顯示rman配置

RMAN> show all;

報告目標(biāo)數(shù)據(jù)庫的物理結(jié)構(gòu)

RMAN> report schema;

報告陳舊備份

RMAN> report obsolete;

報告不可恢復(fù)的數(shù)據(jù)文件

RMAN> report unrecoverable;

列出備份信息

RMAN> list backup;

RMAN> list backup of database;

RMAN> list backup of tablespace table_name;

RMAN> list backup of controlfile;

RMAN> list backup of spfile;

RMAN> list backupset id;

核對備份

RMAN> crosscheck backup;

RMAN> crosscheck backup of database;

RMAN> crosscheck backup of tablespace system;

RMAN> crosscheck backup of controlfile;

RMAN> crosscheck backup of spfile;

刪除備份

RMAN> delete obsolete; -- 刪除陳舊備份

RMAN> delete expired backup;

RMAN> delete backupset id;

RMAN> delete backup; -- 刪除所有備份

改變備份集的狀態(tài)

RMAN> change backupset id unavailable; -- available

改為長期備份

RMAN> change backupset id keep forever logs;

RMAN> change backupset id keep until time 'sysdate+60' logs;

RMAN> change backupset id nokeep;

posted on 2005-10-20 21:13 waterye 閱讀(954) 評論(0) 編輯收藏所屬分類: oracle


只有注冊用戶登錄后才能發(fā)表評論。




網(wǎng)站導(dǎo)航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關(guān)文章: DBMS_JOB Partitioned Tables 試用Oracle Sql Developer pl/sql developer 7 Cursor FOR Loop Use Dynamic SQL 使用utl_file包進(jìn)行io操作通過Database Links訪問Remote Database 使用DBMS_SCHEDULER定時執(zhí)行任務(wù) PL/SQL中顯示DML操作結(jié)果