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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rman backup script(引用)
- RMAN Backup Shell Script Example (Doc ID 137181.1)
- Oracle 學習(Rman Backup)Oracle
- Cold backup script
- Oracle 11g RMAN備份-RMAN的backup database plus archivelog命令背後的操作OracleDatabaseHive
- Cold Database backup scriptDatabase
- zt:Different type of RMAN backup compression in 11G
- Rman backup standby databaseDatabase
- DP rman backup scripts
- rman 0.1.2 備份 script
- Oracle 11g Rman Active database duplicateOracleDatabase
- oracle rman backup命令檢查資料庫錯誤Oracle資料庫
- rman backup database force 功能Database
- Oracle Rman 命令詳解(List report backup configure)Oracle
- Oracle OCP 1Z0 053 Q600(RMAN BACKUP)Oracle
- Oracle OCP 1Z0 053 Q703(Rman Backup)Oracle
- Oracle 11g RMAN備份-基本操作Oracle
- Oracle 11g RMAN 異機恢復Oracle
- oracle scriptOracle
- V$RMAN_BACKUP_JOB_DETAILSAI
- RMAN cumulative and differential incremental backupREM
- Oracle OCP 1Z0 053 Q342(RMAN BACKUP DURATION)Oracle
- oracle10g_rman_backup recovery area_相關備紀Oracle
- Oracle 11g RMAN的常規維護Oracle
- Oracle 11g RMAN備份-增量備份Oracle
- Oracle 11g RMAN虛擬私有目錄Oracle
- 【RMAN】Run Allocate Channel For Maintenance From Script FailsAINaN
- How to use rman backup a noarchivelog databaseHiveDatabase
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST
- [Oracle Script] LockOracle
- Oracle Database ScriptOracleDatabase
- Oracle OCP 1Z0 053 Q505(RMAN DATAFILE BACKUP COPIES)Oracle
- Oracle OCP 1Z0 053 Q338(RMAN Expired Backup)Oracle
- Oracle OCP 1Z0 053 Q688(RMAN Backup Compression)Oracle
- Oracle OCP 1Z0-053 Q630(RMAN Backup Encryption)Oracle
- Oracle 11g RMAN備份-備份標籤Oracle
- Oracle 11g RMAN multiplexing 備份指令碼Oracle指令碼
- 通過 rman duplicate 配置Oracle 11g Active DataguardOracle