oracle 11g rman backup script
CONFIGURE CONTROLFILE AUTOBACKUP on;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 1G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 1G;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
SHOW ALL;
CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK BACKUP OF CONTROLFILE;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP DEVICE TYPE DISK COMPLETED BEFORE 'SYSDATE-5';
DELETE FORCE NOPROMPT EXPIRED BACKUP OF CONTROLFILE;
DELETE OBSOLETE DEVICE TYPE DISK;
BACKUP DEVICE TYPE DISK FORMAT 'E:OracleadminLIMSbackup%d_full_%U' DATABASE PLUS ARCHIVELOG;
BACKUP CURRENT CONTROLFILE FORMAT 'E:OracleadminLIMSbackup%d_ctl_%U';
BACKUP SPFILE FORMAT 'E:OracleadminLIMSbackup%d_spfile_%U';
# Back up the support files...
host 'xcopy /Y D:Oracleora102databasepwd*.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102databaseinit*.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102databasespfile*.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102networkadmintnsnames.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102networkadminlistener.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102networkadminsqlnet.ora E:OracleadminLIMSbackup';
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-5' BACKED UP 3 TIMES TO DISK;
# Validate the backup...
restore database validate;
# Display all available backup sets...
list backup;
exit;
[@more@]
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 1G;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK MAXPIECESIZE 1G;
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS;
SHOW ALL;
CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK BACKUP OF CONTROLFILE;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP DEVICE TYPE DISK COMPLETED BEFORE 'SYSDATE-5';
DELETE FORCE NOPROMPT EXPIRED BACKUP OF CONTROLFILE;
DELETE OBSOLETE DEVICE TYPE DISK;
BACKUP DEVICE TYPE DISK FORMAT 'E:OracleadminLIMSbackup%d_full_%U' DATABASE PLUS ARCHIVELOG;
BACKUP CURRENT CONTROLFILE FORMAT 'E:OracleadminLIMSbackup%d_ctl_%U';
BACKUP SPFILE FORMAT 'E:OracleadminLIMSbackup%d_spfile_%U';
# Back up the support files...
host 'xcopy /Y D:Oracleora102databasepwd*.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102databaseinit*.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102databasespfile*.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102networkadmintnsnames.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102networkadminlistener.ora E:OracleadminLIMSbackup';
host 'xcopy /Y D:Oracleora102networkadminsqlnet.ora E:OracleadminLIMSbackup';
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-5' BACKED UP 3 TIMES TO DISK;
# Validate the backup...
restore database validate;
# Display all available backup sets...
list backup;
exit;
[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1046975/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- Windows oracle 11g rman備份恢復到linux系統WindowsOracleLinux
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- RMAN-03009: failure of backup command on ORA_DISK_1 channelAI
- ORACLE rman與RMAN-00054&ORA-09945Oracle
- 【RMAN】Oracle rman 常用命令參考Oracle
- Oracle 11GR2 Duplicate from BackupOracle
- Oracle之11g DataGuardOracle
- Oracle RMAN恢復測試Oracle
- Oracle RMAN備份實戰Oracle
- Oracle OCP(60):RMAN 備份Oracle
- 【RMAN】Oracle使用rman將11.2.0.4資料庫遷移至Oracle12c命令參考Oracle資料庫
- oracle手工建庫後rman無法啟用(RMAN-04015)Oracle
- Oracle 11G 安裝文件Oracle
- benchmark 壓測Oracle 11gOracle
- sysbench壓測Oracle 11gOracle
- Oracle rman duplicate遷移測試Oracle
- Oracle RMAN 表空間恢復Oracle
- 【RMAN】Oracle11g透過rman升級到12cOracle
- 【SCRIPT】Oracle統計資訊相關SQLOracleSQL
- 【SCRIPT】Oracle表管理段管理常用語句Oracle
- Oracle 11G 安裝 bbed 工具Oracle
- oracle 11g data guard維護Oracle
- oracle 11g OEM在哪裡找到???Oracle
- oracle 11g 常用命令Oracle
- Oracle 11g RAC Silent Install For NFSOracleNFS
- Oracle 11g刪除庫重建Oracle
- Oracle 11G 修改scan_ipOracle
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- oracle 12c rman備份pdbOracle
- 分享Oracle Rman的備份指令碼Oracle指令碼
- Oracle 12c RMAN全攻略Oracle
- Oracle 11G RAC叢集安裝(3)——安裝OracleOracle
- Oracle Linux 6.7 靜預設安裝Oracle 11gOracleLinux
- 【RMAN】Oracle12c以後rman 備份恢復命令參考Oracle
- 【SCRIPT】Oracle日常巡檢指令碼通用版Oracle指令碼
- Oracle 11g RAC 監聽日常管理Oracle
- Oracle 11g 052題庫解析1Oracle