RMAN常用命令
RMAN是Oracle資料庫備份管理中必須用到的管理工具。它的操作方式有很多種,我整理了一些常用的操作命令,彙總起來,以方便工作。
(miki西遊 @mikixiyou 文件,原文連結: http://mikixiyou.iteye.com/blog/1560754 )
1 、備份資料庫操作命令
簡潔版
backup database plus archivelog format '/backup/rman/xx_%U.%T';
正規版
run {
allocate channel t1 type disk;
backup database format '/backup/rman/xx_%U.%T';
backup archivelog all delete input format '/backup/rman/xx_%U.%T';
sql 'alter system archive log current';
backup current controlfile format '/backup/rman/xx_%U.%T';
release channel t1;
}
加強版
run
{
delete noprompt obsolete;
allocate channel ch01 type disk rate 40M;
backup database filesperset 3 format '/backup/servdb_rman/db_%U.%T';
sql 'alter system archive log current';
backup archivelog like '+%' filesperset 20 format '/backup/servdb_rman/archivelog_%U.%T';
delete noprompt archivelog until time 'sysdate -1';
backup current controlfile format '/backup/servdb_rman/ctl_%U.%T' ;
release channel ch01;
}
2 、歸檔日誌單獨備份操作命令
不刪除歸檔日誌檔案
run {
allocate channel t1 type disk;
backup archivelog all format '/backup/servdb_rman/archivelog_%U.%T';
release channel t1;
}
刪除歸檔日誌檔案
run {
allocate channel t1 type disk;
backup archivelog all delete input format '/backup/servdb_rman/archivelog_%U.%T';
release channel t1;
}
不備份已經備份過一次的歸檔日誌檔案
run {
allocate channel t1 type disk;
backup archivelog all not backed up 1 times format '/backup/servdb_rman/archivelog_%U.%T';
release channel t1;
}
3 、還原和恢復資料庫操作命令
完全恢復
startup nomount;
run {
allocate channel t1 type disk;
restore controlfile;
restore archivelog all;
alter database mount;
restore database;
recover database;
release channel t1;
}
sql 'alter database open resetlogs';
不完全恢復,至某個時間點
startup nomount;
run {
set until time ="to_date('2012-06-14 00:00:00','yyyy-mm-dd hh24:mi:ss')";
allocate channel t1 type disk;
restore controlfile;
restore archivelog all;
alter database mount;
restore database;
recover database;
release channel t1;
}
sql 'alter database open resetlogs';
RAC 環境中還原某幾個歸檔日誌檔案
run
{
allocate channel t1 type disk;
restore archivelog from logseq 5023 thread 1 until logseq 5036 thread 1;
releaase channel t1;
}
單例項環境中還原某幾個歸檔日誌檔案
run
{
allocate channel t1 type disk;
restore archivelog from logseq 5023 until logseq 5036;
releaase channel t1;
}
4 、註冊備份集到 CATALOG 操作命令
catalog start with '/backup/xxx.xxx';
5 、其他管理命令
list backupset;
list backup of database;
list backup of archivelog all;
report obsolete;
report obsolete redundancy = 2;
delete obsolete;
restore database validate;
report unrecoverable;
report schema;
crosscheck backup;
delete expired backup;
rman target sys/*****@ora10 catalog rman/rman@dbarep
allocate channel for maintenance device type disk;
delete obsolete redundancy = 4 device type disk;
delete obsolete redundancy = 2 device type disk;
delete noprompt archivelog until time "sysdate-5"
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25462274/viewspace-2136759/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RMAN】Oracle rman 常用命令參考Oracle
- 【RMAN】RMAN備份至ASMASM
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- 【RMAN】RMAN的備份保留策略
- ORACLE rman與RMAN-00054&ORA-09945Oracle
- RMAN(轉)
- RMAN恢復之RMAN-06555處理
- RMAN-06207和RMAN-06208的處理
- 【RMAN】在備庫執行rman備份時報錯RMAN-06820 ORA-17629
- RMAN增量恢復
- RMAN備份概述
- oracle手工建庫後rman無法啟用(RMAN-04015)Oracle
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- 【RMAN】Oracle11g透過rman升級到12cOracle
- RMAN備份進度
- rman 備份指令碼指令碼
- RMAN中的通道分配
- RMAN的備份原理
- RMAN修復壞塊
- RMAN-06214: Datafile Copy
- [20191122]RMAN-03999.txt
- RMAN Duplicate RAC to Single Instance
- RMAN恢復實踐
- 資料遷移的時候出現RMAN-03002,RMAN-06026
- 【RMAN】Oracle12c以後rman 備份恢復命令參考Oracle
- 【RMAN】在多租戶環境下的RMAN備份及恢復
- rman 增量備份恢復
- RMAN命令LIST操作總結
- Oracle RMAN恢復測試Oracle
- Oracle RMAN備份實戰Oracle
- Oracle OCP(60):RMAN 備份Oracle
- [20190517]rman tape compressed.txt
- RMAN之環境配置(一)
- RMAN備份恢復技巧
- 【rman備份策略】實驗
- rman duplicate操作手冊
- RMAN刪除歸檔日誌出現RMAN-0813錯誤的處理
- Oracle9i RMAN 的優缺點及RMAN 備份及恢復步驟Oracle
- 【RMAN】Oracle使用rman將11.2.0.4資料庫遷移至Oracle12c命令參考Oracle資料庫