SAP中oracle數(shù)據(jù)庫的備份恢復(fù)

1、1. 備份數(shù)據(jù)庫進(jìn)入T-code DB13備份在線數(shù)據(jù)庫去DB12可以看進(jìn)度查看日志這是成功了2備份數(shù)據(jù)庫歸檔文件執(zhí)行DB13的TCODE，創(chuàng)建計(jì)劃，設(shè)定計(jì)劃時間，選擇redolog backup. 利用命令備份：brarchive -u / -c force -p initPRD.sap -sdZzxc報(bào)錯，說Function中寫的BRARCHIVE出錯了，所以這里要用 -sd這樣就可以了，去DB14中查看日志備份狀態(tài)成功了備份更改路徑3SAP數(shù)據(jù)恢復(fù)在運(yùn)行中輸入sqlplus /nolog打開cmd界面，登陸oracleWindows切換為devadm用戶登錄關(guān)閉數(shù)據(jù)庫服務(wù)Linux下備份

2、數(shù)據(jù)庫使用rdvadm用戶登錄用chmod R 777 /oracle 給權(quán)限修改/oracle/RDV/102_64/dbs/initRDV.sap備份日志文件路徑備份數(shù)據(jù)庫時報(bào)錯解決方法：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$關(guān)于s權(quán)限的說明： s表示setUID 和setGID 。位于

3、user和group權(quán)限組的第三位置。如果在user權(quán)限組中設(shè)置了s權(quán)限。那么當(dāng)該文件被執(zhí)行時，是以文件所有者的GID,而不是用戶的GID執(zhí)行文件,因此可執(zhí)行的文件搭配這個權(quán)限，便能得到特權(quán)，任意存取該文件的所有者能使用全部系統(tǒng)資源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改變文件權(quán)限為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下恢復(fù)數(shù)據(jù)庫 恢復(fù)數(shù)據(jù)文件>su oraprd>cd /oracle/PRD/sapbackup>brrestore b beqktnhh.andm fullc force-d disk注意：在上面命令中，beqktnhh.and為對應(yīng)備份集的備份日志文件，請根