Nocatalog 下的RMAN 增量备份 shell脚本(国外英语资料).docVIP

Nocatalog 下的RMAN 增量备份 shell脚本(国外英语资料) RMAN incremental backup shell scripts under Nocatalog Personal classification: RMAN incremental backup shell scripts under Nocatalog Before finishing the catalog under the perfect script, the last time a nocatalog script on the production of libraries, the results did not save on the laptop, want to use this time, again in a bit. Linux platform RMAN complete and incremental backup shell scripts /tianlesoftware/archive0/07/16/5740630.aspx Before executing the script, change several parameter values: 1. The DB parameters: Modify the save time for the control file from the default 7 days to 14 days SQL show the parameter control SQL alter system set control_file_record_keep_time = 14 scope = both 2. RMAN parameters: After open the automatic backup control file, open the database backup or data files (such as adding the data file) when there are changes will automatically backup control file and spfile. RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON; The RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; The backup strategy depends on your system Im doing a level-0-backup on Sunday. Thursday 1 backup, other level 2 backups. The backup script is as follows: # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # rman_incremental_backup.sh # # Created by Tianlesoftware # # # # 2011-1-25 # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # # #! / bin/KSH Export LANG = en_US ` BACKUP_DATE = ` date + % d RMAN_LOG_FILE = ${0}. Out TODAY = ` date ` USER = ` id | the cut - d ( - f2 | the cut - d) - ` f1 Echo -- -- -- -- -- -- -- $RMAN_LOG_FILE ORACLE_HOME = / u01 / app/oracle/product / 10.2.0 / db_1 Export ORACLE_HOME RMAN = $ORACLE_HOME/bin/RMAN Export RMAN ORACLE_SID = wouldn The export is ORACLE_USER = oracle Export ORACLE_USER Echo ORACLE_SID: $ORACLE_SID $RMAN_LOG_FILE