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

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

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

SAP中oracle数据库的备份恢复

1.备份数据库

进入T-codeDB13

备份在线数据库

精选文档

去DB12可以看进度

—2

精选文档

查看日志

—3

精选文档

这是成功了

—4

精选文档

2．备份数据库归档文件

执行DB13的TCODE，创建计划，设定计划时间，选择redologbackup.

利用命令备份：

brarchive-u/-cforce-pinitPRD.sap-sd

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-startedwiththeuseradmwhen

usingtheOPS$connection（option"-u/"）-terminateonLinuxorSolaris11withthefollowingerrormessages:

BR0301ESQLerror-1017atlocationBrDbConnect-2

ORA-01017:

invalidusername/password;logondenied

BR0310EConnecttodatabaseinstanceQO1failed

2.BRBACKUPorBRARCHIVEbackupwithRMAN-startedwiththeuseradm-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>

RMAN>connecttarget/;

RMAN-00571:

===========================================================

RMAN-00569:

===============ERRORMESSAGESTACKFOLLOWS===============

RMAN-00571:

===========================================================

ORA-01031:

insufficientprivileges

RMAN>**end-of-file**

3.BRBACKUPorBRARCHIVEfailwithORA-01031duringanattempttoconnecttothedatabaseusingtheSYSOPERauthorization,forexample:

BR0301ESQLerror-1031atlocationBrInitOraCreate-2,SQLstatement:

'CONNECT/ATPROF_CONNINSYSOPERMODE'

ORA-01031:

insufficientprivileges

BR0303EDeterminationofOracleversionfailed

OtherTerms

BR*Tools

ReasonandPrerequisites

TheBRexecutablesareassignedans-bit.Theproblemisrelatedtothespecialprocessingofthes-bitbyLinuxandSolaris11operatingsystems.

1.TheproblemdoesnotoccuriftheBR*ToolsarecalledwiththeSYSTEMdatabase

user,forexample:

brbackup-uSYSTEM/-q

2+3.TheproblemoccursforeverydatabaseuserifthebackupwasstartedwiththeOSuseradm.

Solution

1.AlthoughtheBR*ToolsarecalledwiththeOSadm,therelevantdatabase

userfortheOPS$connectionmustbecalledOPS$ORA.Ifitdoesnotexist

yet,createitasfollows:

sqlplus/nolog

—14

精选文档

SQL>connect/assysdba

SQL>createuserops$oraidentifiedexternallytemporarytablespacepsaptemp;

SQL>grantsapdbatoops$ora;

2+3.Tosolvetheproblem,settheSGIDbitforthebrarchive,brbackup,andbrconnectexecutables（theymustbelongtoora）:

su-root

cd/usr/sap//SYS/exe/run

改变文件所有者为ora

chownorabrarchivebrbackupbrconnect

改变所属用户组为dba

chgrpdbabrarchivebrbackupbrconnect

改变文件权限为6754

chmod6754brarchivebrbackupbrconnect

Thesecommandsshouldresultinthefollowingfileauthorizations:

-rwsr-sr--1ora

dba

93253742012-12-19

04:

52brarchive

-rwsr-sr--1ora

dba

94432232012-12-19

04:

52brbackupLS

-rwsr-sr--1ora

dba

113337562012-12-1904:

55brconnect

-rwxr-xr-x1

admsapsys

98937022012-12-19

04:

56brrecover

-rwxr-xr-x1

admsapsys

62030962012-12-19

04:

56brrestore

-rwxr-xr-x1

admsapsys117668272012-12-1904:

58brspace

-rwxr-xr-x1

admsapsys

67975242012-12-19

04:

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