NetBackupForOracle配置指导手册脚本.docx
《NetBackupForOracle配置指导手册脚本.docx》由会员分享,可在线阅读,更多相关《NetBackupForOracle配置指导手册脚本.docx(28页珍藏版)》请在冰豆网上搜索。
NetBackupForOracle配置指导手册脚本
NetBackupForOracle_Win安装配置指南
修订记录
日期修订版本修改描述作者
一、ClientAgent安装3
1.1主机名解释3
1.2安装过程3
二、编辑备份脚本3
2.1检查oracle归档状态3
2.2获取oracle相关变量4
2.3修改oracle备份脚本5
三、oracle备份12
3.1创建oracle备份策略12
3.2检查备份作业13
四、oracle恢复22
4.1恢复控制文件22
4.2恢复数据文件23
一、ClientAgent安装
1.1主机名解释
1)在oracle客户端编辑c:
\windows\system32\drivers\etc\hosts文件,添加备份服务器ip及
主机名条目
2)确保ping通备份服务器
1.2安装过程
3)安装过程略
二、编辑备份脚本
2.1检查oracle归档状态
1)使用netbackupfororacle进行rman热备份,必须使数据库处于归档模式SQL>alterdatabaseopen;
数据库已更改。
SQL>archiveloglist;
数据库日志模式存档模式
自动存档启用
存档终点
USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列
1
下一个存档日志序列
3
当前日志序列
3
SQL>
2)如果没启用归档则让DBA开启归档,参照以下步骤
SQL>archiveloglist;
数据库日志模式非存档模式
自动存档禁用
存档终点
USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列
1
当前日志序列
3
SQL>shutdownimmediate
数据库已经关闭。
已经卸载数据库。
ORACLE例程已经关闭。
SQL>startupmount;
ORACLE例程已经启动。
TotalSystemGlobalArea348127232bytes
FixedSize
2004200bytes
VariableSize
109054744bytes
DatabaseBuffers
234881024bytes
RedoBuffers
2187264bytes
数据库装载完毕。
SQL>alterdatabasearchivelog;
数据库已更改。
SQL>alterdatabaseopen;
数据库已更改。
SQL>archiveloglist;
数据库日志模式存档模式
自动存档启用
存档终点
USE_DB_RECOVERY_FILE_DEST
最早的联机日志序列
1
下一个存档日志序列
3
当前日志序列
3
SQL>
2.2获取oracle相关变量
1)打开注册表,导航到HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->SYSTEM->OracleDB⋯
2)分别双击ORACLE_HOME\ORACLE_SID,记录ORACLE_HOME及ORACLE_SID
2.3修改oracle备份脚本
1)在oracle客户端找到备份脚本模版,然后修改
路径如下
C:
\ProgramFiles\Veritas\NetBackup\DbExt\Oracle\Samples\rman
备份脚本
hot_database_backup.cmd
2)修改以下条目为合适的值
@setORACLE_HOME=E:
\oracle\product\10.2.0\db_1
@setORACLE_SID=orcl
@setTARGET_CONNECT_STR=/
该备份脚本同时备份databasedatafile、归档日志、控制文件
另外ARCHIVELOGALLDELETEINPUT表示备份完归档后即删除之,如果不需要删除则去掉
deleteinput;
@REM$Header:
hot_database_backup.cmd,v1.32005/11/2819:
01:
53$
@REMbcpyrght
@REM
***************************************************************************
@REM*$VRTScprght:
Copyright1993-2007SymantecCorporation,AllRightsReserved$*
@REM
***************************************************************************
@REMecpyrght
@REM
@REM---------------------------------------------------------------------------
@REMhot_database_backup.cmd
@REM---------------------------------------------------------------------------
@REMThisscriptusesRecoveryManagertotakeahot(inconsistent)database@REMbackup.Ahotbackupisinconsistentbecauseportionsofthedatabaseare@REMbeingmodifiedandwrittentothediskwhilethebackupisprogressing.@REMYoumustrunyourdatabaseinARCHIVELOGmodetomakehotbackups.@REM
@REMNOTEinformationforrunningproxybackupshasbeenincluded.These@REMinformationsectionsbeginwithacommentlineofPROXY
@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\ora81,below,withtheOraclehomepath.
@REM---------------------------------------------------------------------------
@setORACLE_HOME=d:
\orant
@REM---------------------------------------------------------------------------
@REMReplaceora81,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---------------------------------------------------------------------------
@REMPROXY
@REMForaPROXYbackup,uncommentthelinebelowandreplacethevalue.
@REM
@REMNB_ORA_PC_STREAMS-specifiesthenumberofparallelbackupstreams
@REMtobestarted.
@REM---------------------------------------------------------------------------
@REM@setNB_ORA_PC_STREAMS=3
@REM---------------------------------------------------------------------------
@REMLogthestartofthisscripts.
@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%
@echo
RMAN
:
%RMAN%
>>%RMAN_LOG_FILE%
@echo
NLS_LANG
:
%NLS_LANG%
>>%RMAN_LOG_FILE%
@echo
ORACLE_HOME:
%ORACLE_HOME%
>>%RMAN_LOG_FILE%
@echo
ORACLE_SID:
%ORACLE_SID%
>>%RMAN_LOG_FILE%
@echo
NLS_DATE_FORMAT:
%NLS_DATE_FORMAT%>>%RMAN_LOG_FILE%
@echo
RMAN_LOG_FILE:
%RMAN_LOG_FILE%
>>%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMPROXY
@REMForaPROXYbackup,uncommentthelinebelow.
@REM---------------------------------------------------------------------------
@REM
@echo
NB_ORA_PC_STREAMS:
%NB_ORA_PC_STREAMS%>>%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMPrintoutenvironmentvariablessetinbphdb.
@REM---------------------------------------------------------------------------
@echo
NB_ORA_SERV:
%NB_ORA_SERV%
>>%RMAN_LOG_FILE%
@echo
NB_ORA_FULL:
%NB_ORA_FULL%
>>%RMAN_LOG_FILE%
@echo
NB_ORA_INCR:
%NB_ORA_INCR%
>>%RMAN_LOG_FILE%
@echo
NB_ORA_CINC:
%NB_ORA_CINC%
>>%RMAN_LOG_FILE%
@echo
NB_ORA_CLASS:
%NB_ORA_CLASS%
>>%RMAN_LOG_FILE%
@REM---------------------------------------------------------------------------
@REMWeassumethatthedatabaseisproperlyopened.Ifdesired,thiswould@REMbetheplacetoverifythat.
@REM---------------------------------------------------------------------------
NOTEWHENUSINGTNSALIAS:
WhenconnectingtoadatabaseusingaTNSalias,youmustuseasendcommandoraparmsoperandtospecifyenvironmentvariables.Inotherwords,whenaccessingadatabasethroughalistener,theenvironmentvariablessetatthesystemlevelarenotvisiblewhenRMANisrunning.Formoreinformationontheenvironmentvariables,pleaserefertotheNetBackupforOracleAdmin.Guide.
@REM---------------------------------------------------------------------------
@REMIfthisscriptisexecutedfromaNetBackupschedule,NetBackup@REMsetsanNB_ORAenvironmentvariablebasedonthescheduletype.
@REMForexample,when:
@REMscheduletypeis
@REM----------------
@REMAutomaticFull
@REMAutomaticDifferentialIncremental
@REMAutomaticCumulativeIncremental
BACKUP_TYPEis
--------------
INCREMENTALLEVEL=0
INCREMENTALLEVEL=1
INCREMENTALLEVEL=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=INCREME