oracle rman
run {
allocate channel ch1 device type disk maxpiecesize=10g;
sql 'alter system archive log current';
change archivelog all crosscheck;
change backup crosscheck;
backup full database tag=DB
format '/backup/rman/%d_db_%t_%s_%p' plus archivelog format '/bakcup/rman/%d_arch_%t_%s_%p' delete all input;
backup current controlfile
format '/backup/rman/%d_ctlfile_%t_%s_%p';
release channel ch1;
}
allocate channel ch1 device type disk maxpiecesize=10g;
sql 'alter system archive log current';
change archivelog all crosscheck;
change backup crosscheck;
backup full database tag=DB
format '/backup/rman/%d_db_%t_%s_%p' plus archivelog format '/bakcup/rman/%d_arch_%t_%s_%p' delete all input;
backup current controlfile
format '/backup/rman/%d_ctlfile_%t_%s_%p';
release channel ch1;
}
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/235507/viewspace-714057/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORACLE rman與RMAN-00054&ORA-09945Oracle
- 【RMAN】Oracle rman 常用命令參考Oracle
- Oracle RMAN恢復測試Oracle
- Oracle RMAN備份實戰Oracle
- Oracle OCP(60):RMAN 備份Oracle
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- 【RMAN】Oracle使用rman將11.2.0.4資料庫遷移至Oracle12c命令參考Oracle資料庫
- oracle手工建庫後rman無法啟用(RMAN-04015)Oracle
- Oracle rman duplicate遷移測試Oracle
- Oracle RMAN 表空間恢復Oracle
- 【RMAN】Oracle11g透過rman升級到12cOracle
- Oracle 12c RMAN全攻略Oracle
- 分享Oracle Rman的備份指令碼Oracle指令碼
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- oracle 12c rman備份pdbOracle
- 【RMAN】Oracle12c以後rman 備份恢復命令參考Oracle
- oracle10g RMAN增量備份策略Oracle
- ORACLE DG從庫 Rman備份恢復Oracle
- Oracle RMAN備份以及壓縮原理分析Oracle
- oracle rman 刪除過期的歸檔Oracle
- Oracle 備份恢復篇之RMAN catalogOracle
- 揭秘ORACLE備份之----RMAN之五(CATALOG)Oracle
- Oracle 12c系列(八)|RMAN (FROM SERVICE)Oracle
- 【Oracle19c】Oracle19c rman使用簡單測試Oracle
- Oracle ADG環境下的RMAN備份策略Oracle
- Windows Server 2019 Oracle 19c RMAN Back DetailsWindowsServerOracleAI
- Oracle使用RMAN從Windows遷移資料到LinuxOracleWindowsLinux
- Oracle Rman多通道故障轉移問題分析Oracle
- Oracle 12C新特性-RMAN恢復表Oracle
- Oracle RMAN 連線資料庫認證方法Oracle資料庫
- rman oracle11g_單機實用配置Oracle
- oracle資料庫使用rman備份指令碼Oracle資料庫指令碼
- Oracle 12C RMAN Cross-Platform Transport of PDBsOracleROSPlatform
- Oracle9i RMAN 的優缺點及RMAN 備份及恢復步驟Oracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- Oracle Rman Catalog的建立方法和備份原理Oracle
- Oracle案例03——RMAN-06091: no channel allocated for maintenance (of an appropriate type)OracleAINaNAPP
- Oracle 12c RMAN Cross-Platform Transport of a Closed PDBOracleROSPlatform