SAP中oracle数据库的备份恢复Word格式.docx

SAP中oracle数据库的备份恢复Word格式.docx

《SAP中oracle数据库的备份恢复Word格式.docx》由会员分享，可在线阅读，更多相关《SAP中oracle数据库的备份恢复Word格式.docx（17页珍藏版）》请在冰豆网上搜索。

Windows切换为devadm用户登录

关闭数据库服务

Linux下备份数据库

使用rdvadm用户登录

用chmod–R777/oracle给权限

修改/oracle/RDV/102_64/dbs/initRDV.sap

备份日志文件路径

备份数据库时报错

解决方法：

[root@vm~]#su-oracle

[oracle@vm~]$cd$ORACLE_HOME/bin

[oracle@vmbin]$chmod+soracle

[oracle@vmbin]$lloracle

-rwsrwsr-x1oracleoinstall152028761Aug3019:

06oracle

[oracle@vmbin]$

关于s权限的说明：

s表示setUID和setGID。

位于user和group权限组的第三位置。

如果在user权限组中设置了s权限。

那么当该文件被执行时，是以文件所有者的GID,而不是用户的GID执行文件,因此可执行的文件搭配这个权限，便能得到特权，任意存取该文件的所有者能使用全部系统资源

NOTE:

776505

Symptom

1.BRARCHIVE,BRBACKUP,andBRCONNECT-startedwiththeuser<

sapsid>

admwhenusingtheOPS$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/rman

nocatalog'

:

RecoveryManager:

Release9.2.0.4.0-Production

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*ToolsarecalledwiththeSYSTEMdatabaseuser,forexample:

brbackup-uSYSTEM/<

password>

-q

2+3.TheproblemoccursforeverydatabaseuserifthebackupwasstartedwiththeOSuser<

adm.

Solution

1.AlthoughtheBR*ToolsarecalledwiththeOS<

adm,therelevantdatabaseuserfortheOPS$connectionmustbecalledOPS$ORA<

DBSID>

.Ifitdoesnotexistyet,createitasfollows:

sqlplus/nolog

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-1904:

52brarchive

94432232012-12-1904:

52brbackupLS

113337562012-12-1904:

55brconnect

-rwxr-xr-x1<

admsapsys 

98937022012-12-1904:

56brrecover

62030962012-12-1904:

56brrestore

admsapsys117668272012-12-1904:

58brspace

67975242012-12-1904:

58brtools

Theauthorization***4shouldpreventjustanybodyfrombeingabletoperformanofflinebackup,whichcoulddisrupttheavailabilityoftheSAPsystem.

HeaderData

ReleasedOn

27.07.201514:

33:

10

ReleaseStatus

ReleasedforCustomer

Component

BC-DB-ORA-DBADatabaseAdministrationwithOracle

Priority

Correctionwithmediumpriority

Category

Helpforerroranalysis

Validity

Thisdocumentisnotrestrictedtoasoftwarecomponentorsoftwarecomponentversion 

References

Thisdocumentrefersto:

SAPNotes

1882181

CorrectionsinBR*Tools7.20Patch33/7.40Patch3

361641

CreatingOPS$usersonUNIX

113747

OwnersandauthorizationsforBR*Tools

Thisdocumentisreferencedby:

SAPNotes（3）

Linux下恢复数据库

恢复数据文件

>

su–oraprd

cd/oracle/PRD/sapbackup

brrestore–bbeqktnhh.and–mfull–cforce-ddisk

注意：

在上面命令中，beqktnhh.and为对应备份集的备份日志文件，请根据实际情况进行相关替换。

在生产数据库中产生控制文件的trace.

sqlplus“/assysdba”

alterdatabasebackupcontrolfiletotraceas'

/tmp/prd.trc'

将产生的控制文件拷贝到本地，加工获得相关目录和控制文件重建SQL脚本。

由于是压缩备份，所以在恢复时必须解压日志文件

解压命令

cd/oracle/RDV/oraarch/

gunzip–c文件名>

解压到的文件名

（注：

可编辑下载，若有不当之处，请指正，谢谢!

）