SAP中oracle数据库的备份恢复Word格式.docx
- 文档编号:13631659
- 上传时间:2022-10-12
- 格式:DOCX
- 页数:9
- 大小:17.58KB
SAP中oracle数据库的备份恢复Word格式.docx
《SAP中oracle数据库的备份恢复Word格式.docx》由会员分享,可在线阅读,更多相关《SAP中oracle数据库的备份恢复Word格式.docx(9页珍藏版)》请在冰豆网上搜索。
Zzxc
报错,说Function中写的BRARCHIVE出错了,所以这里要用-sd
—5
这样就可以了,去DB14中查看日志备份状态
—6
—7
成功了
备份更改路径
—8
3.SAP数据恢复
在运行中输入sqlplus/nolog打开cmd界面,登陆oracle
Windows切换为devadm用户登录
关闭数据库服务
—9
—10
Linux下备份数据库
使用rdvadm用户登录
用chmod–R777/oracle给权限
修改/oracle/RDV/102_64/dbs/initRDV.sap
—11
备份日志文件路径
备份数据库时报错
解决方法:
[root@vm~]#su-oracle
[oracle@vm~]$cd$ORACLE_HOME/bin
[oracle@vmbin]$chmod+soracle
[oracle@vmbin]$lloracle
-rwsrwsr-x1oracleoinstall152028761Aug3019:
06oracle
[oracle@vmbin]$
—12
关于s权限的说明:
s表示setUID和setGID。
位于user和group权限组的第三位置。
如果在user
权限组中设置了s权限。
那么当该文件被执行时,是以文件所有者的GID,而不是用户的GID执行文件,因此可执行的文件搭配这个权限,便能得到特权,任意存取该文件的所有者能使用全部系统资源
NOTE:
776505
Symptom
1.BRARCHIVE,BRBACKUP,andBRCONNECT-startedwiththeuser<
sapsid>
admwhen
usingtheOPS$connection(option"
-u/"
)-terminateonLinuxorSolaris11withthefollowingerrormessages:
BR0301ESQLerror-1017atlocationBrDbConnect-2
ORA-01017:
invalidusername/password;
logondenied
BR0310EConnecttodatabaseinstanceQO1failed
2.BRBACKUPorBRARCHIVEbackupwithRMAN-startedwiththeuser<
adm-failsonLinuxorSolaris11withthefollowingerrormessages:
BR0278ECommandoutputof'
SHELL=/bin/sh/oracle/I20/920_32/bin/rmannocatalog'
:
RecoveryManager:
Release9.2.0.4.0-Production
—13
Copyright(c)1995,2002,OracleCorporation.Allrightsreserved.
RMAN>
connecttarget/;
RMAN-00571:
===========================================================
RMAN-00569:
===============ERRORMESSAGESTACKFOLLOWS===============
ORA-01031:
insufficientprivileges
**end-of-file**
3.BRBACKUPorBRARCHIVEfailwithORA-01031duringanattempttoconnecttothedatabaseusingtheSYSOPERauthorization,forexample:
BR0301ESQLerror-1031atlocationBrInitOraCreate-2,SQLstatement:
'
CONNECT/ATPROF_CONNINSYSOPERMODE'
BR0303EDeterminationofOracleversionfailed
OtherTerms
BR*Tools
ReasonandPrerequisites
TheBRexecutablesareassignedans-bit.Theproblemisrelatedtothespecialprocessingofthes-bitbyLinuxandSolaris11operatingsystems.
1.TheproblemdoesnotoccuriftheBR*ToolsarecalledwiththeSYSTEMdatabase
user,forexample:
brbackup-uSYSTEM/<
password>
-q
2+3.TheproblemoccursforeverydatabaseuserifthebackupwasstartedwiththeOSuser<
adm.
Solution
1.AlthoughtheBR*ToolsarecalledwiththeOS<
adm,therelevantdatabase
userfortheOPS$connectionmustbecalledOPS$ORA<
DBSID>
.Ifitdoesnotexist
yet,createitasfollows:
sqlplus/nolog
—14
SQL>
connect/assysdba
createuserops$ora<
dbsid>
identifiedexternallytemporarytablespacepsaptemp;
grantsapdbatoops$ora<
;
2+3.Tosolvetheproblem,settheSGIDbitforthebrarchive,brbackup,andbrconnectexecutables(theymustbelongtoora<
):
su-root
cd/usr/sap/<
SAPSID>
/SYS/exe/run
改变文件所有者为ora<
chownora<
brarchivebrbackupbrconnect
改变所属用户组为dba
chgrpdbabrarchivebrbackupbrconnect
改变文件权限为6754
chmod6754brarchivebrbackupbrconnect
Thesecommandsshouldresultinthefollowingfileauthorizations:
-rwsr-sr--1ora<
dba
93253742012-12-19
04:
52brarchive
94432232012-12-19
52brbackupLS
113337562012-12-1904:
55brconnect
-rwxr-xr-x1
<
admsapsys
98937022012-12-19
56brrecover
62030962012-12-19
56brrestore
admsapsys117668272012-12-1904:
58brspace
67975242012-12-19
58brtools
Theauthorization***4shouldpreventjustanybodyfrombeingabletoperformanofflinebackup,whichcoulddisrupttheavailabilityoftheSAPsystem.
HeaderData
ReleasedOn27.07.201514:
33:
10
ReleaseStatusReleasedforCustomer
ComponentBC-DB-ORA-DBADatabaseAdministrationwithOracle
PriorityCorrectionwithmediumpriority
—15
CategoryHelpforerroranalysis
Validity
Thisdocumentisnotrestrictedtoasoftwarecomponentorsoftwarecomponentversion
References
Thisdocumentrefersto:
SAPNotes
1882181CorrectionsinBR*Tools7.20Patch33/7.40Patch3
361641CreatingOPS$usersonUNIX
113747OwnersandauthorizationsforBR*Tools
Thisdocumentisreferen
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- SAP oracle 数据库 备份 恢复