SAP中oracle數(shù)據(jù)庫的備份恢復(fù)

.備份數(shù)據(jù)庫進(jìn)入T-codeDB13備份在線數(shù)據(jù)庫.去 DB12可以看進(jìn)度.查看日志.這是成功了.2．備份數(shù)據(jù)庫歸檔文件執(zhí)行DB13的TCODE，創(chuàng)建計(jì)劃，設(shè)定計(jì)劃時(shí)間，選擇redologbackup.精品文檔放心下載利用命令備份：brarchive-u/-cforce-pinitPRD.sap-sd謝謝閱讀Zzxc.報(bào)錯(cuò)，說Function中寫的BRARCHIVE出錯(cuò)了，所以這里要用 -謝謝閱讀sd.這樣就可以了，去DB14中查看日志備份狀態(tài)..成功了備份更改路徑.3．SAP數(shù)據(jù)恢復(fù)在運(yùn)行中輸入sqlplus/nolog打開cmd界面，登陸oracle精品文檔放心下載Windows切換為devadm用戶登錄關(guān)閉數(shù)據(jù)庫服務(wù)..Linux下備份數(shù)據(jù)庫使用rdvadm用戶登錄chmod–R777/oracle給權(quán)限修改/oracle/RDV/102_64/dbs/initRDV.sap謝謝閱讀.備份日志文件路徑備份數(shù)據(jù)庫時(shí)報(bào)錯(cuò).解決方法：[root@vm~]#su-oracle[oracle@vm~]$cd$ORACLE_HOME/bin精品文檔放心下載[oracle@vmbin]$chmod+soracle精品文檔放心下載[oracle@vmbin]$lloracle感謝閱讀-rwsrwsr-x1oracleoinstall152028761Aug3019:06oracle精品文檔放心下載[oracle@vmbin]$.關(guān)于s權(quán)限的說明：s表示setUID和setGID。位于user和group權(quán)限組的第三位置。如果在user權(quán)限組中設(shè)置了s權(quán)限。那么當(dāng)該文件被執(zhí)行時(shí)，是以文件所有者的GID,而不是用戶的GID執(zhí)行文件,因此可執(zhí)行的文件搭配這個(gè)權(quán)限，便能得到特權(quán)，任意存取該文件的所有者能使用全部系統(tǒng)資源謝謝閱讀NOTE:776505SymptomBRARCHIVE,BRBACKUP,andBRCONNECT-startedwiththeuser<sapsid>admwhenusingtheOPS$connection(option"-u/")-terminateonLinuxorSolaris11withthefollowingerrormessages:謝謝閱讀BR0301ESQLerror-1017atlocationBrDbConnect-2謝謝閱讀ORA-01017:invalidusername/password;logondenied精品文檔放心下載BR0310EConnecttodatabaseinstanceQO1failed精品文檔放心下載.BRBACKUPorBRARCHIVEbackupwithRMAN-startedwiththeuser<sapsid>adm-failsonLinuxorSolaris11withthefollowingerrormessages:感謝閱讀BR0278ECommandoutputof'SHELL=/bin/sh/oracle/I20/920_32/bin/rmannocatalog':精品文檔放心下載RecoveryManager:Release9.2.0.4.0-Production感謝閱讀Copyright(c)1995,2002,OracleCorporation.Allrightsreserved.感謝閱讀RMAN>RMAN>connecttarget/;RMAN-00571:===========================================================謝謝閱讀RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS謝謝閱讀===============RMAN-00571:===========================================================精品文檔放心下載ORA-01031:insufficientprivileges感謝閱讀RMAN>**end-of-file**BRBACKUPorBRARCHIVEfailwithORA-01031duringanattempttoconnecttothedatabaseusingtheSYSOPERauthorization,forexample:感謝閱讀BR0301ESQLerror-1031atlocationBrInitOraCreate-2,SQLstatement:謝謝閱讀'CONNECT/ATPROF_CONNINSYSOPERMODE'感謝閱讀ORA-01031:insufficientprivileges精品文檔放心下載BR0303EDeterminationofOracleversionfailed謝謝閱讀OtherTermsBR*ToolsReasonandPrerequisitesTheBRexecutablesareassignedans-bit.Theproblemisrelatedtothespecialprocessingofthes-bitbyLinuxandSolaris11operatingsystems.精品文檔放心下載1.TheproblemdoesnotoccuriftheBR*ToolsarecalledwiththeSYSTEMdatabaseuser,for謝謝閱讀.example:brbackup-uSYSTEM/<password>-q謝謝閱讀2+3.TheproblemoccursforeverydatabaseuserifthebackupwasstartedwiththeOSuser<sapsid>adm.謝謝閱讀SolutionAlthoughtheBR*ToolsarecalledwiththeOS<sapsid>adm,therelevantdatabaseuserfortheOPS$connectionmustbecalledOPS$ORA<DBSID>.Ifitdoesnotexistyet,createitasfollows:感謝閱讀sqlplus/nologSQL>connect/assysdbaSQL>createuserops$ora<dbsid>identifiedexternallytemporarytablespacepsaptemp;SQL>grantsapdbatoops$ora<dbsid>;感謝閱讀2+3.Tosolvetheproblem,settheSGIDbitforthebrarchive,brbackup,andbrconnectexecutables(theymustbelongtoora<dbsid>):感謝閱讀su-rootcd/usr/sap/<SAPSID>/SYS/exe/run感謝閱讀改變文件所有者為ora<dbsid>chownora<dbsid>brarchivebrbackupbrconnect謝謝閱讀改變所屬用戶組為dbachgrpdbabrarchivebrbackupbrconnect謝謝閱讀改變文件權(quán)限為6754chmod6754brarchivebrbackupbrconnect謝謝閱讀Thesecommandsshouldresultinthefollowingfileauthorizations:感謝閱讀-rwsr-sr--1ora<dbsid>dba93253742012-12-1904:52brarchive-rwsr-sr--1ora<dbsid>dba94432232012-12-1904:52brbackupLS-rwsr-sr--1ora<dbsid>dba113337562012-12-1904:55brconnect-rwxr-xr-x1<sapsid>admsapsys98937022012-12-1904:56brrecover-rwxr-xr-x1<sapsid>admsapsys62030962012-12-1904:56brrestore-rwxr-xr-x1<sapsid>admsapsys117668272012-12-1904:58brspace-rwxr-xr-x1<sapsid>admsapsys67975242012-12-1904:58brtools.Theauthorization***4shouldpreventjustanybodyfrombeingabletoperformanofflinebackup,whichcoulddisrupttheavailabilityoftheSAPsystem.謝謝閱讀HeaderDataReleasedOn 27.07.201514:33:10精品文檔放心下載ReleaseReleasedforCustomerStatusBC-DB-ORA-DBADatabaseAdministrationwith感謝閱讀ComponentOraclePriority Correctionwithmediumpriority精品文檔放心下載Category Helpforerroranalysis精品文檔放心下載ValidityThisdocumentisnotrestrictedtoasoftwarecomponentorsoftwarecomponentversion感謝閱讀.ReferencesThisdocumentrefersto:SAPNotes188218 CorrectionsinBR*Tools7.20Patch33/7.40感謝閱讀Patch3361641 CreatingOPS$usersonUNIX感謝閱讀113747 OwnersandauthorizationsforBR*Tools感謝閱讀Thisdocumentisreferencedby:精品文檔放心下載SAPNotes(3)113747 OwnersandauthorizationsforBR*Tools精品文檔放心下載361641 CreatingOPS$usersonUNIX精品文檔放心下載188218 CorrectionsinBR*Tools7.20Patch33/7.40感謝閱讀Patch3Linux下恢復(fù)數(shù)據(jù)庫恢復(fù)數(shù)據(jù)文件.>su–oraprd>cd/oracle/PRD/sapbackup>brrestore–bbeqktnhh.and–mfull–cforce-ddisk感謝閱讀注意：在上面命令中，beqktnhh.and為對(duì)應(yīng)備份集的