nbu安装和oracle rman安装文档格式.docx
- 文档编号:17520467
- 上传时间:2022-12-07
- 格式:DOCX
- 页数:20
- 大小:24.69KB
nbu安装和oracle rman安装文档格式.docx
《nbu安装和oracle rman安装文档格式.docx》由会员分享,可在线阅读,更多相关《nbu安装和oracle rman安装文档格式.docx(20页珍藏版)》请在冰豆网上搜索。
exportMANMANPATH
安装client和agent
1、将介质放入光驱
在提示输入server名字时输入masterserver的名字。
2、修改/usr/openv/netbackup/bp.conf文件,在第一行的“SERVER=XXXXX”下面按照此格式增加其他mediaserver的名字,有几台mediaserver就增加几行。
3、把agent介质放入光驱
注意打上agent的补丁,我这次测试oracle9i时,发现不打agent补丁无法,备份保错。
注意需要执行一条命令建立RMAN和NBU之间的联系
#su–oracle
$install_path/netbackup/bin/oracle_link
二、配置RMAN
我此次数据库的一些参数,下面的描述都以这些参数为例子,以后可以根据不同参数修改命令和脚本。
ORACLE_HOME=/oracle/product/9.2.0
ORACLE_SID=db
ORACLE_USER=oracle
TARGET_CONNECT_STR=system/manager2
1.测试RMAN是否正常运行
$sqlplus‘/assysdba’
SQL>
startup;
ORACLEinstancestarted.
TotalSystemGlobalArea838860800bytes
FixedSize781424bytes
VariableSize221254544bytes
DatabaseBuffers616562688bytes
RedoBuffers262144bytes
Databasemounted.
Databaseopened.
exit
$rmannocatalog
RMAN>
connecttarget
connecttargetsystem/manager2@db
连接正常,不报错,表示RMAN正常运行。
这次由于客户oracle补丁打的有问题,RMAN一直不正常,可以在配置RMAN前先测试一下RMAN的状态。
2.配置RMANforNBU
创建一个instancevertias用来存放catalog库。
Instance名字可以随便起
$dbca用dbca工具创建
创建catalog库
/////////////我7.06以上做了但补丁未打//////////////////
$drtias
startup;
createtablespacercvcatdatafile‘/oradata/veritas/rcvcat01.dbf’size100Mextentmanagementlocalsegmentspacemanagementauto;
createuserrmanidentifiedbyrmandefaulttablespacercvcattemporarytablespacetempquotaunlimitedonrcvcat;
grantconnect,resorce,recovery_catalog_ownertorman;
//是resource
exit
$rmancatalogrman/rman
createcatalog;
注册备份数据库
$exportORACLE_SID=db(yourinstanceneedbackup)
$rmancatalogrman/rman@rmantarget///7.25这里报错,我想是@veritas
registerdatabase;
7.25为止
3.编写rmanforNBU备份脚本
脚本模版在installpath/netbackup/ext/db_ext/oracle/samples/rman目录下
有hot_database_backup.sh和hot_database_restore.sh
修改hot_database_backup.sh并把他放到你需要的目录下
下面是我这次的脚本内容:
#!
/bin/sh
#$Header:
hot_database_backup.sh,v1.22002/08/0623:
51:
42$
#
#bcpyrght
#***************************************************************************
#*$VRTScprght:
Copyright1993-2003VERITASSoftwareCorporation,AllRightsReserved$*
#ecpyrght
#---------------------------------------------------------------------------
#hot_database_backup.sh
#ThisscriptusesRecoveryManagertotakeahot(inconsistent)database
#backup.Ahotbackupisinconsistentbecauseportionsofthedatabaseare
#beingmodifiedandwrittentothediskwhilethebackupisprogressing.
#YoumustrunyourdatabaseinARCHIVELOGmodetomakehotbackups.Itis
#assumedthatthisscriptwillbeexecutedbyuserroot.InorderforRMAN
#toworkproperlyweswitchuser(su-)totheoracledbaaccountbefore
#execution.IfthisscriptrunsunderauseraccountthathasOracledba
#privilege,itwillbeexecutedusingthisuser'
saccount.
#Determinetheuserwhichisexecutingthisscript.
CUSER=`id|cut-d"
("
-f2|cut-d"
)"
-f1`
#Putoutputin<
thisfilename>
.out.Changeasdesired.
#Note:
outputdirectoryrequireswritepermission.
RMAN_LOG_FILE=${0}.out
#Youmaywanttodeletetheoutputfilesothatbackupinformationdoes
#notaccumulate.Ifnot,deletethefollowinglines.
if[-f"
$RMAN_LOG_FILE"
]
then
rm-f"
fi
#-----------------------------------------------------------------
#Initializethelogfile.
echo>
>
$RMAN_LOG_FILE
chmod666$RMAN_LOG_FILE
#Logthestartofthisscript.
echoScript$0>
echo====startedon`date`====>
#Replace/db/oracle/product/ora81,below,withtheOraclehomepath.
exportORACLE_HOME
#Replaceora81,below,withtheOracleSIDofthetargetdatabase.
exportORACLE_SID
#Replaceora81,below,withtheOracleDBAuserid(account).
#Setthetargetconnectstring.
#Replace"
sys/manager"
below,withthetargetconnectstring.
TARGET_CONNECT_STR=/
#SettheOracleRecoveryManagername.
RMAN=$ORACLE_HOME/bin/rman
#Printoutthevalueofthevariablessetbythisscript.
echo"
RMAN:
$RMAN"
>
ORACLE_SID:
$ORACLE_SID"
ORACLE_USER:
$ORACLE_USER"
ORACLE_HOME:
$ORACLE_HOME"
#Printoutthevalueofthevariablessetbybphdb.
NB_ORA_FULL:
$NB_ORA_FULL"
NB_ORA_INCR:
$NB_ORA_INCR"
NB_ORA_CINC:
$NB_ORA_CINC"
NB_ORA_SERV:
$NB_ORA_SERV"
NB_ORA_POLICY:
$NB_ORA_POLICY"
#NOTE:
Thisscriptassumesthatthedatabaseisproperlyopened.Ifdesired,
#thiswouldbetheplacetoverifythat.
#IfthisscriptisexecutedfromaNetBackupschedule,NetBackup
#setsanNB_ORAenvironmentvariablebasedonthescheduletype.
#TheNB_ORAvariableisthenusedtodynamicallysetBACKUP_TYPE
#Forexample,when:
#scheduletypeisBACKUP_TYPEis
#------------------------------
#AutomaticFullINCREMENTALLEVEL=0
#AutomaticDifferentialIncrementalINCREMENTALLEVEL=1
#AutomaticCumulativeIncrementalINCREMENTALLEVEL=1CUMULATIVE
#
#Foruserinitiatedbackups,BACKUP_TYPEdefaultstoincremental
#level0(full).Tochangethedefaultforauserinitiated
#backuptoincrementalorincrementalcumulative,uncomment
#oneofthefollowingtwolines.
#BACKUP_TYPE="
INCREMENTALLEVEL=1"
INCREMENTALLEVEL=1CUMULATIVE"
#Notethatweuseincrementallevel0tospecifyfullbackups.
#Thatisbecause,althoughtheyareidenticalincontent,only
#theincrementallevel0backupcanhaveincrementalbackupsof
#level>
0appliedtoit.
if["
$NB_ORA_FULL"
="
1"
echo"
Fullbackuprequested"
BACKUP_TYPE="
INCREMENTALLEVEL=0"
elif["
$NB_ORA_INCR"
Differentialincrementalbackuprequested"
$NB_ORA_CINC"
Cumulativeincrementalbackuprequested"
$BACKUP_TYPE"
"
Default-Fullbackuprequested"
#CallRecoveryManagertoinitiatethebackup.Thisexampledoesnotusea
#RecoveryCatalog.Ifyouchoosetouseone,replacetheoption'
nocatalog'
#fromthermancommandlinebelowwiththe
#'
rcvcat<
userid>
/<
passwd>
@<
tnsalias>
'
statement.
AnyenvironmentvariablesneededatruntimebyRMAN
#mustbesetandexportedwithintheswitchuser(su)command.
#-
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- nbu安装和oracle rman安装 nbu 安装 oracle rman