NBU NetBackup 备份Oracle策略配置.docx
《NBU NetBackup 备份Oracle策略配置.docx》由会员分享，可在线阅读，更多相关《NBU NetBackup 备份Oracle策略配置.docx（19页珍藏版）》请在冰点文库上搜索。
NBUNetBackup备份Oracle策略配置
AIX+Oracle
创建备份策略
注意：
一台主机的全量备份和增量备份应创建2个备份策略。
1.打开NetBackup控制台，选择策略类型和存储位置。
配置策略名称时，必须与/usr/openv/netbackup/script目录下的Oracle备份脚本中NB_ORA_POLICY参数的取值一样。
RUN{
ALLOCATECHANNELch00TYPE'SBT_TAPE';
ALLOCATECHANNELch01TYPE'SBT_TAPE';
SEND'NB_ORA_POLICY=ORACLE_TEST1_80_DB,NB_ORA_SERV=yiling-appliance,NB_ORA_CLIENT=test1';
BACKUP
$BACKUP_TYPE
2.配置备份策略属性。
3.配置备份周期及频率（全量备份1周1次，增量备份1周6次）。
全量备份：
增量备份：
4.配置备份客户端。
注意：
以上界面中的clientname，是指客户端的主机名，必须已在192.168.8.170上的/etc/hosts文件中配置。
5.选择备份脚本。
执行备份策略
手工执行备份策略，验证策略是否配置成功。
在AllPolicies下选中ORACLE_TEST1_80_DB，右键选择ManualBackup，并在ActivityMonitor中查看状态。
当启动job全部为Done时，表明备份成功。
WINS+Oracle
基本配置
在172.16.140.25（主机名XIONGMIAOMIAO）上安装Oracle11gR2的服务端。
1.在C:
\Windows\System32\drivers\etc\hosts文件中配置NBU服务端的IP及主机名。
192.168.8.170yiling-appliance
2.更改oracle的归档模式。
SQL>archiveloglist;
数据库日志模式非存档模式
自动存档禁用
存档终点USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列10
当前日志序列12
SQL>shutdownimmediate;
数据库已经关闭。
已经卸载数据库。
ORACLE例程已经关闭。
SQL>startupmount;
ORACLE例程已经启动。
TotalSystemGlobalArea945786880bytes
FixedSize1375368bytes
VariableSize327156600bytes
DatabaseBuffers612368384bytes
RedoBuffers4886528bytes
数据库装载完毕。
SQL>alterdatabasearchivelog;
数据库已更改。
SQL>shutdownimmediate;
ORA-01109:
数据库未打开
已经卸载数据库。
ORACLE例程已经关闭。
SQL>startup;
ORACLE例程已经启动。
TotalSystemGlobalArea945786880bytes
FixedSize1375368bytes
VariableSize327156600bytes
DatabaseBuffers612368384bytes
RedoBuffers4886528bytes
数据库装载完毕。
数据库已经打开。
SQL>archiveloglist;
数据库日志模式存档模式
自动存档启用
存档终点USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列10
下一个存档日志序列12
当前日志序列12
SQL>showparameterdb_recovery;
NAMETYPEVALUE
-----------------------------------------------------------------------------
db_recovery_file_deststringF:
\orcl\flash_recovery_area
db_recovery_file_dest_sizebiginteger3852M
创建备份脚本
修改oracle的备份脚本。
从C:
\ProgramFiles\Veritas\NetBackup\DbExt\Oracle\Samples\rman目录下拷贝出hot_database_backup.cmd，放到C:
\ProgramFiles\Veritas\NetBackup\scripts目录下。
并根据实际情况修改脚本（如蓝色部分所示）。
@REM$Header:
hot_database_backup.cmd,v1.42010/08/0417:
55:
57$
@REMbcpyrght
@REM***************************************************************************
@REM*$VRTScprght:
Copyright2013SymantecCorporation,AllRightsReserved$*
@REM***************************************************************************
@REMecpyrght
@REM
@REM---------------------------------------------------------------------------
@REMhot_database_backup.cmd
@REM---------------------------------------------------------------------------
@REMThisscriptusesRecoveryManagertotakeahot（inconsistent）database
@REMbackup.Ahotbackupisinconsistentbecauseportionsofthedatabaseare
@REMbeingmodifiedandwrittentothediskwhilethebackupisprogressing.
@REMYoumustrunyourdatabaseinARCHIVELOGmodetomakehotbackups.
@REM---------------------------------------------------------------------------
@setlocalENABLEEXTENSIONS
@REM---------------------------------------------------------------------------
@REMNoneedtoechothecommands.
@REM---------------------------------------------------------------------------
@echooff
@REM---------------------------------------------------------------------------
@REMPutoutputinthesamefilename,differentextension.
@REM---------------------------------------------------------------------------
@setRMAN_LOG_FILE="%~dpn0.out"
@REM---------------------------------------------------------------------------
@REMYoumaywanttodeletetheoutputfilesothatbackupinformationdoes
@REMnotaccumulate.Ifnot,deletethefollowingcommand.
@REM---------------------------------------------------------------------------
@ifexist%RMAN_LOG_FILE%del%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMReplaceH:
\oracle\ora102,below,withtheOraclehomepath.
@REM---------------------------------------------------------------------------
@setORACLE_HOME=F:
\orcl\product\11.2.0\dbhome_1
@REM---------------------------------------------------------------------------
@REMReplaceora102,below,withtheOracleSID.
@REM---------------------------------------------------------------------------
@setORACLE_SID=orcl
@REM---------------------------------------------------------------------------
@REMReplacesys/manager,below,withthetargetconnectstring.
@REM---------------------------------------------------------------------------
@setTARGET_CONNECT_STR=/
@REM---------------------------------------------------------------------------
@REMSettheOracleRecoveryManager.
@REM---------------------------------------------------------------------------
@setRMAN=%ORACLE_HOME%\bin\rman.exe
@REM---------------------------------------------------------------------------
@REMLogthestartofthisscript.
@REM---------------------------------------------------------------------------
@for/F"tokens=1*"%%pin（'date/T'）do@setDATE=%%p%%q
@for/F%%pin（'time/T'）do@setDATE=%DATE%%%p
@echo====startedon%DATE%====>>%RMAN_LOG_FILE%
@echoScriptname:
%0>>%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMSeveralRMANcommandsusetimeparametersthatrequireNLS_LANGand
@REMNLS_DATE_FORMATtobeset.Thisexampleusesthestandarddateformat.
@REMReplacebelowwiththedesiredlanguagevalues.
@REM---------------------------------------------------------------------------
@setNLS_LANG=american
@setNLS_DATE_FORMAT=YYYY-MM-DD:
hh24:
mi:
ss
@REM---------------------------------------------------------------------------
@REMPrintoutenvironmentvariablessetinthisscript.
@REM---------------------------------------------------------------------------
@echo#>>%RMAN_LOG_FILE%
@echoRMAN:
%RMAN%>>%RMAN_LOG_FILE%
@echoNLS_LANG:
%NLS_LANG%>>%RMAN_LOG_FILE%
@echoORACLE_HOME:
%ORACLE_HOME%>>%RMAN_LOG_FILE%
@echoORACLE_SID:
%ORACLE_SID%>>%RMAN_LOG_FILE%
@echoNLS_DATE_FORMAT:
%NLS_DATE_FORMAT%>>%RMAN_LOG_FILE%
@echoRMAN_LOG_FILE:
%RMAN_LOG_FILE%>>%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMPrintoutenvironmentvariablessetinbphdb.
@REM---------------------------------------------------------------------------
@echoNB_ORA_SERV:
%NB_ORA_SERV%>>%RMAN_LOG_FILE%
@echoNB_ORA_FULL:
%NB_ORA_FULL%>>%RMAN_LOG_FILE%
@echoNB_ORA_INCR:
%NB_ORA_INCR%>>%RMAN_LOG_FILE%
@echoNB_ORA_CINC:
%NB_ORA_CINC%>>%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMWeassumethatthedatabaseisproperlyopened.Ifdesired,thiswould
@REMbetheplacetoverifythat.
@REM---------------------------------------------------------------------------
@REM---------------------------------------------------------------------------
@REMIfthisscriptisexecutedfromaNetBackupschedule,NetBackup
@REMsetsanNB_ORAenvironmentvariablebasedonthescheduletype.
@REMForexample,when:
@REMscheduletypeisBACKUP_TYPEis
@REM------------------------------
@REMAutomaticFullINCREMENTALLEVEL=0
@REMAutomaticDifferentialIncrementalINCREMENTALLEVEL=1
@REMAutomaticCumulativeIncrementalINCREMENTALLEVEL=1CUMULATIVE
@REM
@REMForuserinitiatedbackups,BACKUP_TYPEdefaultstoincremental
@REMlevel0（Full）.Tochangethedefaultforauserinitiated
@REMbackuptoincrementalorincrementatlcumulative,uncomment
@REMoneofthefollowingtwolines.
@REM@setBACKUP_TYPE="INCREMENTALLEVEL=1"
@REM@setBACKUP_TYPE="INCREMENTALLEVEL=1CUMULATIVE"
@REM
@REMNotethatweuseincrementallevel0tospecifyfullbackups.
@REMThatisbecause,althoughtheyareidenticalincontent,only
@REMtheincrementallevel0backupcanhaveincrementalbackupsof
@REMlevel>0appliedtoit.
@REM---------------------------------------------------------------------------
@REM---------------------------------------------------------------------------
@REMWhatkindofbackupwillweperform.
@REM---------------------------------------------------------------------------
@if"%NB_ORA_FULL%"EQU"1"@setBACKUP_TYPE=INCREMENTALLevel=0
@if"%NB_ORA_INCR%"EQU"1"@setBACKUP_TYPE=INCREMENTALLevel=1
@if"%NB_ORA_CINC%"EQU"1"@setBACKUP_TYPE=INCREMENTALLevel=1CUMULATIVE
@ifNOTDEFINEDBACKUP_TYPE@setBACKUP_TYPE=INCREMENTALLevel=0
@REM---------------------------------------------------------------------------
@REMCallRecoveryManagertoinitiatethebackup.Thisexampledoesnotusea
@REMRecoveryCatalog.Ifyouchoosetouseone,removetheoption,nocatalog,
@REMfromthermancommandlinebelowandadda
@REM'catalog/@'statement.
@REM
@REMNOTEWHENUSINGNETSERVICENAME:
Whenconnectingtoadatabase
@REMusinganetservicename,youmustuseasendcommandoraparmsoperandto
@REMspecifyenvironmentvariables.Inotherwords,whenaccessingadatabase
@REMthroughalistener,theenvironmentvariablessetatthesystemlevelarenot
@REMvisiblewhenRMANisrunning.Formoreinformationontheenvironment
@REMvariables,pleaserefertotheNetBackupforOracleAdmin.Guide.
@REM
@REMIfyouaregettinganerrorthattheinputlineistoolong,youwillneed
@REMtoputtheRMANrunblockinaseparatefile.Thenusethe"cmdfile"
@REMoptionofRMAN.Formoreinformationonthe"cmdfile"optionsplease
@REMrefertotheRMANdocumentation.
@REM---------------------------------------------------------------------------
@（
echoRUN{
echoALLOCATECHANNELch00TYPE'SBT_TAPE';
echoALLOCATECHANNELch01TYPE'SBT_TAPE';
echoSEND'NB_ORA_POL
升级会员 