




下载本文档
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
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为对应备份集的备份日志文件,请根
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 2025年度厂房出租合同(含金融融资支持)
- 2025年度车辆进出口损害赔偿协议范本
- 2025房产中介合伙人投资合作及退出机制合同
- 2025年理发、美容服务项目建议书
- 提高护理文书书写规范的实施措施计划
- 仓库节能降耗工作的总结与展望计划
- 新年自我反思与成长计划
- 创造多元环境培养幼儿园小班的艺术表达能力计划
- 调整工作节奏的方法计划
- 经验教训与未来目标的思考计划
- 部编版二年级下册语文教案全册
- 解放牌汽车CA10B后钢板弹簧吊耳加工工艺及夹具设计哈
- 高中地理高清区域地理填图册
- 培根铸魂征文800字
- 连续梁0号块施工课件
- 旋挖钻机入场安全教育记录
- 第二章直线和圆的方程(单元测试卷)(原卷版)
- 第二篇-安全操作规程
- 罪犯教育学课程
- 纪检监察办案谈话应注意的问题研讨
- 落实国家组织药品集中采购使用检测和应急预案
评论
0/150
提交评论