SAP中oracle数据库的备份恢复

1、1. 备份数据库进入T-code DB13备份在线数据库去DB12可以看进度查看日志这是成功了2备份数据库归档文件执行DB13的TCODE，创建计划，设定计划时间，选择redolog backup. 利用命令备份：brarchive -u / -c force -p initPRD.sap -sdZzxc报错，说Function中写的BRARCHIVE出错了，所以这里要用 -sd这样就可以了，去DB14中查看日志备份状态成功了备份更改路径3SAP数据恢复在运行中输入sqlplus /nolog打开cmd界面，登陆oracleWindows切换为devadm用户登录关闭数据库服务Linux下备份

2、数据库使用rdvadm用户登录用chmod R 777 /oracle 给权限修改/oracle/RDV/102_64/dbs/initRDV.sap备份日志文件路径备份数据库时报错解决方法：rootvm # su - oracleoraclevm $ cd $ORACLE_HOME/binoraclevm bin$ chmod +s oracleoraclevm bin$ ll oracle-rwsrwsr-x 1 oracle oinstall 152028761 Aug 30 19:06 oracleoraclevm bin$关于s权限的说明： s表示setUID 和setGID 。位于

3、user和group权限组的第三位置。如果在user权限组中设置了s权限。那么当该文件被执行时，是以文件所有者的GID,而不是用户的GID执行文件,因此可执行的文件搭配这个权限，便能得到特权，任意存取该文件的所有者能使用全部系统资源NOTE: 776505Symptom1. BRARCHIVE, BRBACKUP, and BRCONNECT - started with the user <sapsid>adm when using the OPS$ connection (option "-u /") - terminate on Linux or Sola

4、ris 11 with the following error messages:BR0301E SQL error -1017 at location BrDbConnect-2ORA-01017: invalid username/password; logon deniedBR0310E Connect to database instance QO1 failed2. BRBACKUP or BRARCHIVE backup with RMAN - started with the user <sapsid>adm - fails on Linux or Solaris 1

5、1 with the following error messages:BR0278E Command output of 'SHELL=/bin/sh /oracle/I20/920_32/bin/rmannocatalog':Recovery Manager: Release 9.2.0.4.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.RMAN>RMAN> connect target /;RMAN-00571: =RMAN-

6、00569: = ERROR MESSAGE STACK FOLLOWS =RMAN-00571: =ORA-01031: insufficient privilegesRMAN> *end-of-file*3. BRBACKUP or BRARCHIVE fail with ORA-01031 during an attempt to connect to the database using the SYSOPER authorization, for example:BR0301E SQL error -1031 at location BrInitOraCreate-2, SQL

7、 statement:'CONNECT / AT PROF_CONN IN SYSOPER MODE'ORA-01031: insufficient privilegesBR0303E Determination of Oracle version failedOther TermsBR*ToolsReason and PrerequisitesThe BR executables are assigned an s-bit. The problem is related to the special processing of the s-bit by Linux and S

8、olaris 11 operating systems.1. The problem does not occur if the BR*Tools are called with the SYSTEM database user, for example:brbackup -u SYSTEM/<password> -q2+3. The problem occurs for every database user if the backup was started with the OS user <sapsid>adm.Solution1. Although the B

9、R*Tools are called with the OS <sapsid>adm, the relevant database user for the OPS$ connection must be called OPS$ORA<DBSID>. If it does not exist yet, create it as follows:sqlplus /nologSQL> connect / as sysdbaSQL> create user ops$ora<dbsid> identified externally temporary t

10、ablespace psaptemp;SQL> grant sapdba to ops$ora<dbsid>2+3. To solve the problem, set the SGID bit for the brarchive, brbackup, and brconnect executables (they must belong to ora<dbsid>):su - rootcd /usr/sap/<SAPSID>/SYS/exe/run改变文件所有者为ora<dbsid>chown ora<dbsid> brarc

11、hive brbackup brconnect改变所属用户组为 dbachgrp dba brarchive brbackup brconnect改变文件权限为6754chmod 6754 brarchive brbackup brconnect These commands should result in the following file authorizations:-rwsr-sr- 1 ora<dbsid>  dba     9325374 2012-12-19 04:52 brarchive-rwsr-sr

12、- 1 ora<dbsid>  dba     9443223 2012-12-19 04:52 brbackupLS -rwsr-sr- 1 ora<dbsid>  dba    11333756 2012-12-19 04:55 brconnect-rwxr-xr-x 1 <sapsid>adm sapsys  9893702 2012-12-19 04:56 brrecover-rwxr-xr-x 1 <sa

13、psid>adm sapsys  6203096 2012-12-19 04:56 brrestore-rwxr-xr-x 1 <sapsid>adm sapsys 11766827 2012-12-19 04:58 brspace-rwxr-xr-x 1 <sapsid>adm sapsys  6797524 2012-12-19 04:58 brtoolsThe authorization *4 should prevent just anybody from being able to perform an offli

14、ne backup, which could disrupt the availability of the SAP system.Header DataReleased On27.07.2015 14:33:10Release StatusReleased for CustomerComponentBC-DB-ORA-DBA Database Administration with OraclePriorityCorrection with medium priorityCategoryHelp for error analysisValidityThis document is not r

15、estricted to a software component or software component version ReferencesThis document refers to:SAP Notes1882181 Corrections in BR*Tools 7.20 Patch 33 / 7.40 Patch 3361641 Creating OPS$ users on UNIX113747 Owners and authorizations for BR*ToolsThis document is referenced by:SAP

16、 Notes (3)113747 Owners and authorizations for BR*Tools361641 Creating OPS$ users on UNIX1882181 Corrections in BR*Tools 7.20 Patch 33 / 7.40 Patch 3Linux下恢复数据库 恢复数据文件>su oraprd>cd /oracle/PRD/sapbackup>brrestore b beqktnhh.andm fullc force-d disk注意：在上面命令中，beqktnhh.and为对应备份集的备份日志文件，请根