unix环境下nbu下oracle备份脚本

《unix环境下nbu下oracle备份脚本》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、全选，复制到一个文本文件。更改后缀名为.bat(如ora_bk.bat)，放到客户端路径下（d:orascriptora_bk.bat）。更改下面红色部分。删除上面中文@REM$Header:hot_database_backup.cmd,v1.32005/11/2819:01:53$@REMbcpyrght@REM***************************************************************************@REM*$VRTScprght:Copyright1993-2007SymantecCorporation,AllRights

2、Reserved$*@REM***************************************************************************@REMecpyrght@REM@REM---------------------------------------------------------------------------@REMhot_database_backup.cmd@REM---------------------------------------------------------------------------@REMThissc

3、riptusesRecoveryManagertotakeahot(inconsistent)database@REMbackup.Ahotbackupisinconsistentbecauseportionsofthedatabaseare@REMbeingmodifiedandwrittentothediskwhilethebackupisprogressing.@REMYoumustrunyourdatabaseinARCHIVELOGmodetomakehotbackups.@REM@REMNOTEinformationforrunningproxybackupshasbeenincl

4、uded.These@REMinformationsectionsbeginwithacommentlineofPROXY@REM---------------------------------------------------------------------------@setlocalENABLEEXTENSIONS@REM---------------------------------------------------------------------------@REMNoneedtoechothecommands.@REM------------------------

5、---------------------------------------------------@echooff@REM---------------------------------------------------------------------------@REMPutoutputinthesamefilename,differentextension.@REM---------------------------------------------------------------------------@setRMAN_LOG_FILE="%~dpn0.out"@RE

6、M---------------------------------------------------------------------------@REMYoumaywanttodeletetheoutputfilesothatbackupinformationdoes@REMnotaccumulate.Ifnot,deletethefollowingcommand.@REM---------------------------------------------------------------------------@ifexist%RMAN_LOG_FILE%del%RMAN_L

7、OG_FILE%@REM---------------------------------------------------------------------------@REMReplaceH:oracleora81,below,withtheOraclehomepath.@REM------------------------------------------------------