oracle 11g rman backup script

maojinyu發表於2011-03-08
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@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1046975/,如需轉載,請註明出處,否則將追究法律責任。

相關文章