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

1、SAP中oracle数据库的备份恢复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

2、用户登录关闭数据库服务Linux下备份数据库使用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表

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

4、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 adm - fails on Linux or Solaris 11 with the following

5、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.RMANRMAN connect target /;RMAN-00571: =RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =RMAN-00571: =

6、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 statement:CONNECT / AT PROF_CONN IN SYSOPER MODEORA-01

7、031: 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 Solaris 11 operating systems.1. The problem does not occur if the

8、BR*Tools are called with the SYSTEM database user, for example:brbackup -u SYSTEM/ -q2+3. The problem occurs for every database user if the backup was started with the OS user adm.Solution1. Although the BR*Tools are called with the OS adm, the relevant database user for the OPS$ connection must be

9、called OPS$ORA. If it does not exist yet, create it as follows:sqlplus /nologSQL connect / as sysdbaSQL create user ops$ora identified externally temporary tablespace psaptemp;SQL grant sapdba to ops$ora;2+3. To solve the problem, set the SGID bit for the brarchive, brbackup, and brconnect executabl

10、es (they must belong to ora):su - rootcd /usr/sap/SYS/exe/run改变文件所有者为orachown ora brarchive brbackup brconnect改变所属用户组为 dbachgrp dba brarchive brbackup brconnect改变文件权限为6754chmod 6754 brarchive brbackup brconnect These commands should result in the following file authorizations:-rwsr-sr- 1 oradba 9325

11、374 2012-12-19 04:52 brarchive-rwsr-sr- 1 oradba 9443223 2012-12-19 04:52 brbackupLS -rwsr-sr- 1 oradba11333756 2012-12-19 04:55 brconnect-rwxr-xr-x 1 adm sapsys9893702 2012-12-19 04:56 brrecover-rwxr-xr-x 1 adm sapsys6203096 2012-12-19 04:56 brrestore-rwxr-xr-x 1 adm sapsys 11766827 2012-12-19 04:5

12、8 brspace-rwxr-xr-x 1 adm sapsys6797524 2012-12-19 04:58 brtoolsThe authorization *4 should prevent just anybody from being able to perform an offline backup, which could disrupt the availability of the SAP system.Header DataReleased On27.07.2015 14:33:10Release StatusReleased for CustomerComponentB

13、C-DB-ORA-DBA Database Administration with OraclePriorityCorrection with medium priorityCategoryHelp for error analysisValidityThis document is not restricted to a software component or software component versionReferencesThis document refers to:SAP Notes1882181Corrections in BR*Tools 7.20 Patch 33 /

14、 7.40 Patch 3361641Creating OPS$ users on UNIX113747Owners and authorizations for BR*ToolsThis document is referenced by:SAP Notes (3)113747Owners and authorizations for BR*Tools361641Creating OPS$ users on UNIX1882181Corrections in BR*Tools 7.20 Patch 33 / 7.40 Patch 3Linux下恢复数据库 恢复数据文件su oraprdcd

15、/oracle/PRD/sapbackupbrrestore b beqktnhh.andm fullc force-d disk注意：在上面命令中，beqktnhh.and为对应备份集的备份日志文件，请根据实际情况进行相关替换。在生产数据库中产生控制文件的trace.su oraprdsqlplus “/as sysdba”SQLalter database backup controlfile to trace as /tmp/prd.trc;将产生的控制文件拷贝到本地，加工获得相关目录和控制文件重建SQL脚本。由于是压缩备份，所以在恢复时必须解压日志文件解压命令cd /oracle/RDV/oraarch/gunzip c 文件名 解压到的文件名 感谢下载!欢迎您的下载，资料仅供参考