SAP Basis Administrator Blog: 2020

Thursday, September 10, 2020

ORA-00201: control file version 18.0.0.0.0 incompatible with ORACLE version 11.2.0.0.0 - NetWeaver

Problem:

ORA-00201: control file version 18.0.0.0.0 incompatible with ORACLE version11.2.0.0.0

Solution:

a. Reset COMPATIBLE parameter by SQL> ALTER SYSTEM SET COMPATIBLE = '18.0.0' SCOPE=SPFILE;

b. Then restart database.

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

Note : SAP Supported Values list all values that are supported for SAP for the given Oracle version.

Oracle Database Release SAP Default Value SAP Supported Value(s)

11.2.0.1 '11.2.0' (*) '11.2.0' (*)

11.2.0.2 '11.2.0' (*) '11.2.0' (*)

'11.2.0.2' '11.2.0.2'

11.2.0.3 '11.2.0' (*) '11.2.0' (*)

'11.2.0.2' '11.2.0.2'

'11.2.0.3'

11.2.0.4 '11.2.0' (*) '11.2.0' (*)

'11.2.0.2' '11.2.0.2'

'11.2.0.3'

'11.2.0.4'

12.1.0.2 '12.1.0.2.0' '12.1.0.2'

'12.1.0.2.0'

12.2.0.1 '12.2.0.1.0' '12.2.0.1.0'

18.X.Y (18c) '18.0.0' '18.0.0'

19.X.Y (19c) '19.0.0' '19.0.0'

(*) Value COMPATIBLE='11.2.0' is only supported for databases on file system, not for databases in ASM

Wednesday, September 9, 2020

Fetching Client IP Address in Security Audit logs

Problem :

You are using a Reverse Proxy or SAP Web Dispatcher to access the Portal and in the Security Audit Logs you want to capture the actual client IP address.

Solution:

Prerequisite - When SAP Web Dispatcher is used as reverse Proxy

1. Configure the proxy to send the IP address of the client in the X-Forwarded-For header.

When using SAP Web Dispatcher as Reverse Proxy the parameters that needs to added:
wdisp/add_client_protocol_header = true
wdisp/add_xforwardedfor_header = true
wdisp/handle_webdisp_ap_header = true

2. Set the property ClientIpHeaderName to X-Forwarded-For .
Navigate to /nwa -> configuration -> Infrastructure -> Java system properties -> tab 'Services'
HTTP provider -> properties -> ClientIpHeaderName
Modify -> set with value X-Forwarded-For -> Save

3. To enable the use of the X-Forwarded-For header as provider of the terminal client IP address, the following parameter needs to be set in the ABAP app server:

icm/use_xforwardedfor_header = true

3. Restart to take effect

Note : For 3rd Party reverse proxy please refer the reverse proxy document, else step 2 and 3 will be the same.

SAP_ABA is in an undefined state that is not safe to be upgraded

Error :

Severe error(s) occurred in phase PREP_INIT/VALCHK_INI!
SAP_ABA is in an undefined state that is not safe to be upgraded !!!
EA-APPL is in an undefined state that is not safe to be upgraded !!!
BBPCRM is in an undefined state that is not safe to be upgraded !!!
BI_CONT is in an undefined state that is not safe to be upgraded !!!
PI_BASIS is in an undefined state that is not safe to be upgraded !!!
GW_CORE is in an undefined state that is not safe to be upgraded !!!
CPRXRPM is in an undefined state, that is not safe to be upgraded !!!
MDG_FND is in an undefined state, that is not safe to be upgraded !!!
Reason: Upgrade wasn't completed.

Note : Do not Perform this step when you are in Execution.

Solution:

a. Stop the upgrade.

Change to the upgrade directory:

UNIX: <upgrade directory>/abap/bin

WINDOWS: <upgrade directory>\abap\bin

b. Execute the following command:

UNIX: ./SAPup reset prepare

WINDOWS: .\SAPup.exe reset prepare

c. Rename the current upgrade directory

NOTE: Once you have confirmed that the reset was done properly, you can then delete the directory.

d. Start a new upgrade from scratch.

e. Reset the table buffers in all application servers with the /$TAB command (Enter it in the ABAP system on the GUI window OK-code field).

Sunday, July 12, 2020

Brconnect or Brtools fails with error ORA - 01031

Error:

Procedure:

1. It can be resolved by giving the required privileges to the User

SQL > GRANT Select on "SAPSR3".DBDIFF to '<USER>';

or

2. Download the latest sapdba_roles.sql and copy it to /sapmnt/<SID>/exe/uc/linux_x86/

oracle > sqlplus /nolog @sapdba_roles.sql '<USER>';

Tuesday, June 30, 2020

Start a Oracle Physical Standby Database

Procedure:

"STARTUP" starts the database, mount it as a Physical standby but opens the database in read-only access.

"STARTUP MOUNT" starts the database mount it as a Physical standby , but does not open the database.

Start and mount the database:

SQL> STARTUP MOUNT;

To start Redo Apply, issue the following statement:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

To start real-time apply, issue the following statement:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

ORA-00210 Recover system from loss of a Standby Control File

Procedure:

Oracle allow multiplexing of standby control files. Check Parameter Control_Files to get the exact of control file

SQL> SHOW PARAMETER CONTROL_FILES
NAME                                 TYPE        VALUE
 ------------------------------------ ----------- ------------------------------
control_files                        string      /oracle/<SID>/sapdata1/cntrl/cntrl<sid>.dbf,

                                                 /oracle/<SID>/origlogA/cntrl/cntrl<sid>.dbf,

                                                 /oracle/<SID>/origlogB/cntrl/cntrl<sid>.dbf

if one of the multiplexed standby control files is lost or not accessible or all three stand by control file has been lost.Following error occurred in alert.log

ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/oracle/<SID>/sapdata1/cntrl/cntrl<sid>.dbf'
ORA-27041: unable to open file

If only one file has been lost.You can copy an intact copy of the control file over the lost copy

oracle > cp -rp /oracle/<SID>/origlogA/cntrl/cntrl<sid>.dbf /oracle/<SID>/sapdata1/cntrl/

SQL > startup mount;

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

If all the files has been then generate the standby file from primary and copy it to the standby

Primary

SQL > alter database begin backup;

SQL > alter database create standby controlfile as '/oracle/<SID>/<SID>_CNTRL_NEW.dbf' reuse;

Move and rename created standby file to Standby database

Standby

SQL > startup mount;
SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Saturday, June 13, 2020

Delete ST03/ST03N old system data

Procedure:

1. Run the Tcode : SE37 and execute the functional module SWNC_COLLECTOR_CLEAN_SWNCMONI

2. Set the value of reset 'X' and Execute

3. Run the Tcode ST03 or ST03N , you will get the message "NO SYSTEM LOAD DATA AVAILABLE"

4. Now schedule the Job "SAP_COLLECTOR_FOR_PERFMONITOR" from SM36.

5. After the successful job finish , you will get the data in ST03

List of Available icon in SAP

Procedure :

1. Tcode : SE38 --> RSTXICON -->EXECUTE

2. Choose Icon as ABAP List --> EXECUTE

3. Icon list is displayed, to use the icon in SAP GUI logon screen . User code @08@

Change the logon screen message in SAP GUI

Procedure :

1. Check the current message on logon screen

2. TCODE: SE61 --> Select Document Class "General text" --> select language --> Document Name as "ZLOGIN_SCREEN_INFO". Create a new one if it not exist or select Change to modified

3. Create a message as required

4. Save and Exit

How to activate SAP* in ABAP system

Procedure:

1. To Activate the SAP* in abap system set the parameter login/no_automatic_user_sapstar=0 in RZ10.

2. Take the restart of the application server.

If SAP* is enable but still unable to login fllow the below procedure.

1. Logon to database server and switch to database user.

2. Start the sqlplus with the command:
root > sqlplus / as sysdba

3. View the entries of the SAP* with following command:
SQL > select * from "<SCHEMA_NAME>".usr02 where mandt = '<CLIENT_NO>' and bname = 'SAP*';

4. Delete the SAP* user
SQL > delete from "<SCHEMA_NAME>".usr02 where mandt = '<CLIENT_NO>' and bname = 'SAP*';
SQL > commit;

Note :

<SCHEMA_NAME> = SAPSR3 in Oracle

<SCHEMA_NAME> = SAPABAP1 or SAPHANADB in HANA

Thursday, June 11, 2020

ORA-00060: deadlock detected while waiting for resource

Error :

DEADLOCK DETECTED ( ORA-00060 )

[Transaction Deadlock]
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:

---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-0013000e-00183dd3 302 888 X 121 51 X
TX-0028000e-000b3549 121 51 X 302 888 X

session 888: DID 0001-012E-00002340 session 51: DID 0001-0079-0000040C
session 51: DID 0001-0079-0000040C session 888: DID 0001-012E-00002340

Rows waited on:
Session 888: obj - rowid = 001B352D - AAGzUtADgAABXGaAAC
(dictionary objn - 1783085, file - 224, block - 356762, slot - 2)
Session 51: obj - rowid = 001B6BF2 - AAHDULACaAAEIR7AAH
(dictionary objn - 1797106, file - 154, block - 1082491, slot - 7)

----- Information for the OTHER waiting sessions -----
Session 51:

sid: 51 ser: 15593 audsid: 907952455 user: 34/SAPSR3
flags: (0x1000041) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
flags2: (0x40009) -/-/INC
pid: 121 O/S info: user: oraBHP, term: UNKNOWN, ospid: 36985
image: oracle@oraclehost
client details:
O/S info: user: BHPadm, term: , ospid: 9188
machine: oraclehost program: dw.sapBHP_DVEBMGS01@oraclehost (TNS V1-V3)
client info: 0:ML81N:SAPLMLSR
application name: SAPLXMLU, hash value=1026532593
action name: 979, hash value=3010390085
current SQL:
UPDATE "REPOLOAD" SET "UNAM"=:A0,"UDAT"=:A1,"UTIME"=:A2,"L_DATALG"=:A3,"MINOR_VERS"=:A4,"MAJOR_VERS"=:A5 WHERE "PROGNAME"=:A6 AND "R3STATE"=:A7 AND "MACH"=:A8 AND "MAJOR_VERS"=:A9
----- End of information for the OTHER waiting sessions -----

Information for THIS session:
----- Current SQL Statement for this session (sql_id=c36b6kkw57c3t) -----
UPDATE "REPOSRC" SET "SDATE"=:A0,"STIME"=:A1 WHERE "PROGNAME"=:A2 AND "R3STATE"=:A3 AND ("SDATE"<:A4 OR ("SDATE"=:A5 AND "STIME"<:A6) )
*** 2020-06-09 20:52:47.893
Attempting to break deadlock by signaling ORA-00060

Solution :

Find out if it is an APPLICATION or DATABASE deadlock as shown below

Application deadlocks :

---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-0013000e-00183dd3 302 888 X 121 51 X
TX-0028000e-000b3549 121 51 X 302 888 X

Shutdown the SAP Instance and Database, Clean all the application running process,make sure no process
running and then restart the system.

Oracle deadlocks :

---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-0013000e-00183dd3 302 888 X 121 51 S
TX-0028000e-000b3549 121 51 X 302 888 S

Follow SAP Note : 84348

Oracle Datapump table import/export for Oracle Database

Procedure :

1. Create the database user

SQL > sqlplus / as sysdba
SQL > Alter User john Identified By penguin Account Unlock;

2. Create the alias for the import/export directory

root > mkdir /oracle/PUP/export_table
root > chown oracle:oinstall export_table
root > chmod 775 export_table
SQL > CREATE OR REPLACE DIRECTORY export_table AS '/oracle/PUP/sapdata1/exp_table';
SQL > GRANT READ, WRITE ON DIRECTORY export_table TO john;

3. Export / import the table using below command

Table Export:

root > expdp john/penguin@PUP tables="SAPSR3".CCCFLOW directory=export_table dumpfile=CCCFLOW.dmp logfile=expdpCCCFLOW.log;

Table Import:

root > impdp john/penguin@PUP tables="SAPSR3".CCCFLOW directory=export_table dumpfile=CCCFLOW.dmp logfile=impdpCCCFLOW.log;

Note :
Always make sure while taking the export no sql connection or user connection are available

Sunday, June 7, 2020

ORA-31993: cannot overwrite parameter file

Error :

Procedure:

Rename the spfile<SID>.ora and let the brtools create the spfile by
command brconnect -u /-c -f check

OR

If you are using BRTOOLS 740 and PATCH (26)< 32 then do the DBA Tool patching with latest.

Tuesday, June 2, 2020

On-Premise SAP VM Migration to AWS Cloud Using Cloud Endure

Monday, June 1, 2020

How to connect and transfer data (WINSCP) with other user on AWS EC2 Instance

Procedure :

1. Download and Install the PuttyGen link.

2. Open the PuttyGen and Click on Generate

3. Keep hovering in the KEY blank area until the status bar gets complete.

4. Copy the Public key till end

5. Paste the public key in ~/.ssh/authorized_keys of the EC2 Instance user

6. Restart the ssh service

7. Click on Save private key and save it on safe location.

8. Now open the WINSCP provide the IP and the private key of the EC2 Instance.

9. Provide the Username

10. Now you can copy the data

How to SSH with other user on AWS EC2 Instance

Procedure :

1. Download and Install the PuttyGen link.

2. Open the PuttyGen and Click on Generate

3. Keep hovering in the KEY blank area until the status bar gets complete.

4. Copy the Public key till end

5. Paste the public key in ~/.ssh/authorized_keys of the EC2 Instance user

6. Restart the ssh service

7. Click on Save private key and save it on safe location.

8. Now open the PUTTY provide the IP and the private key of the EC2 Instance

9. Now provide the user on the login screen and you will be connected to the instance.

Friday, May 29, 2020

Unified Rendering Update with TCI for WD ABAP

Procedure :

The Unified Rendering engine is incrementally patched on the ABAP side. When you apply the notes there will be numerous prerequisites. These prerequisites will apply one by one the changes to the ABAP engine. All the notes together will bring the system to the complete and actual stack level.

Implementing the UR notes may take time, and you need to be careful to always activate all the objects listed at the application, otherwise the UR framework can become inconsistent and syntax errors can occur in UR classes.

1. Open the SAP Note : 2090746 and search for the relevant component SAP_BASIS or SAP_UI
2. Open the UR SAP note from the table which is relevant for your SAP_BASIS or SAP_UI release.
3. Download the that relevant UR SAP Note using Transaction SNOTE
4. Upload the relevant TCI using SPAM or SAINT.
5. Now Apply the downloaded UR note to the SAP System.

Post Processing:

1. Once all the notes are applied, make sure that you delete the server and client cache
2. Run report: WDG_MAINTAIN_UR_MIMES.
3. Compare the two values labeled "urchangelist". Both must show the same number.

4. If they do not show the same value, please execute the option 'Deploy Mimes' and check if this resolves the issue.

Note:
Ensure you have full backup of the system, before applying TCI.
Minimum SPAM Version should be 70.

Wednesday, May 27, 2020

Enable X11 Forwarding For AWS EC2 Linux Instance

Procedure :

i. [ec2-user@10-20-3-40 ~]$ xclock
Warning: Missing charsets in String to FontSet conversion

ii. [ec2-user@10-20-3-40 ~]$ xauth list
10-20-3-40/unix:12 MIT-MAGIC-COOKIE-1 7e53e7600ff4177d7bbc66bde0a1b1ca
10-20-3-40/unix:11 MIT-MAGIC-COOKIE-1 e3d1a8915484c929ef3e809b047e6352

iii. [ec2-user@10-20-3-40 ~]$ env | grep DISPLAY
DISPLAY=localhost:10.0

iv. [ec2-user@10-20-3-40 ~]$ xauth list | grep unix 'echo $DISPLAY | cut -c10-12' > /tmp/xauth
[ec2-user@10-20-3-40 ~]$ ll /tmp/xauth ; cat /tmp/xauth
-rw-rw-r-- 1 ec2-user ec2-user 78 Dec 7 14:47 /tmp/xauth

10-20-3-40/unix:11 MIT-MAGIC-COOKIE-1 e3d1a8915484c929ef3e809b047e6352

v. [ec2-user@10-20-3-40 ~]$ sudo -i
Last login: Fri Dec 7 14:43:12 UTC 2018 on pts/0

vi. [root@10-20-3-40 ~]$ xauth add 'cat /tmp/xauth'
[root@10-20-3-40 ~]$ xauth list
10-20-3-40/unix:11 MIT-MAGIC-COOKIE-1 e3d1a8915484c929ef3e809b047e6352

vi. [root@10-20-3-40 ~]$ env | grep DISPLAY
vii.[root@10-20-3-40 ~]$ export DISPLAY=localhost:11.0

viii.[root@10-20-3-40 ~]$ xclock
Warning: Missing charsets in String to FontSet conversion

Note :
After swtiching it from root to any other user please follow the step vi to step viii

[dinh@securehost ~]$ ssh -X ec2-user@ipaddress
Last login: Fri Dec  7 14:41:41 2018 from gw.ca.adm.pythian.com

       __|  __|_  )
       _|  (     /   Amazon Linux AMI
      ___|\___|___|

https://aws.amazon.com/amazon-linux-ami/2018.03-release-notes/
13 package(s) needed for security, out of 16 available
Run "sudo yum update" to apply all updates.

### Test xclock works from ec2-user
[ec2-user@ipaddress ~]$ xclock
Warning: Missing charsets in String to FontSet conversion
^C

### Show all magic cookie
[ec2-user@ipaddress ~]$ xauth list
ipaddress/unix:12  MIT-MAGIC-COOKIE-1  7e53e7600ff4177d7bbc66bde0a1b1ca
ipaddress/unix:11  MIT-MAGIC-COOKIE-1  e3d1a8915484c929ef3e809b047e6352
<strong>ipaddress/unix:10  MIT-MAGIC-COOKIE-1  07b3de3093cef835c19239ea952231b7</strong>

### Show DISPLAY variable
[ec2-user@ipaddress ~]$ env|grep DISPLAY
<strong>DISPLAY=localhost:10.0</strong>

### Create /tmp/xauth based on current DISPLAY variable
[ec2-user@ipaddress ~]$ xauth list | grep unix`echo $DISPLAY | cut -c10-12` > /tmp/xauth
[ec2-user@ipaddress ~]$ ll /tmp/xauth ; cat /tmp/xauth 
-rw-rw-r-- 1 ec2-user ec2-user 78 Dec  7 14:47 /tmp/xauth
<strong>ipaddress/unix:10  MIT-MAGIC-COOKIE-1  07b3de3093cef835c19239ea952231b7</strong>

### Sudo to oracle
[ec2-user@ipaddress ~]$ sudo su - oracle
Last login: Fri Dec  7 14:43:12 UTC 2018 on pts/0

### Add and Verify xauth
[oracle@ipaddress ~]$ xauth add `cat /tmp/xauth`
[oracle@ipaddress ~]$ xauth list
<strong>ipaddress/unix:10  MIT-MAGIC-COOKIE-1  07b3de3093cef835c19239ea952231b7</strong>

### Verify and Add DISPLAY variable
[oracle@ipaddress ~]$ env|grep DISPLAY
[oracle@ipaddress ~]$ export <strong>DISPLAY=localhost:10.0</strong>

### Test xclock works from oracle
[oracle@ipaddress ~]$ xclock
Warning: Missing charsets in String to FontSet conversion
^C
[oracle@ipaddress ~]$ 

### Example of failed xclock
[oracle@ipaddress ~]$ xclock
Error: Can't open display: 
[oracle@ipaddress ~]$ xclock

Friday, May 15, 2020

Create directory path Alias in Linux

Procedure:

Creating alias is the shortcut method or command to change the directory path

The below example is for bash shell

$ cd ~
$ vi .bashrc

# Add the following line in file

alias cdbo="cd /usr/sap/BOP/sap_bobj"

$ source .bash_profile

Then you can run cdbo as a command.

Thursday, May 14, 2020

Configure the SSO based Authentication between Netweaver Portal and ABAP System

Procedure :

1. Update the system parameter in Instance Profile / Default Profile in RZ10

icm/host_name_full = <FQDN>
login/accept_sso2_ticket = 1
login/create_sso2_ticket = 2

2. Create user in Netweaver Portal and ABAP system with same name and admin authorization

ABAP:
Username : admin
Profile : SAP_ALL and SAP_NEW

Netweaver Portal :
Username : admin
Assigned Roles : Super Admin , NWA Admin. Content Administrator
Assigned Groups: Administrator

3. Download the system pse of the Portal and ABAP System

ABAP:
Tcode : STRUSTSSO2
Download Path:
System PSE --> Own Certificate --> Export Certificate -> Save As (base64) ABAP.cert

Netweaver Portal :
Path : NWA --> Configuration --> Security --> Certificates and Keys --> Key Storage (TicketKeyStore)
Select SAPLogonTicketKeypair-cert --> Export -->Select Export format (base64) --> Click Download

4. Import the downloaded certificates of ABAP and Portal

ABAP :
Tcode : STRUSTSSO2
Import Path: Certificate --> Import certificate -> Select Certificate (SAPLogonTicketKeypair-cert) --> Add to Certificate list and Add to ACL --> Give Client 000 and SID of Portal --> Save

Netweaver Portal :
Path : NWA --> Configuration --> Security --> Certificates and Keys --> Key Storage (TicketKeyStore)
Click Import --> Select 509.X --> Select ABAP.cert --> Import

5. Add ABAP Certificate to Trusted System

Netweaver Portal :
Path : NWA --> Configuration --> Security --> Trusted System --> Add Trusted System --> By Uploading Certificate Manually
Import the ABAP Certificate and give the ABAP System Client

6. Create the Backend Entry in System Landcape of Portal

Netweaver Portal:
Path : System Administration --> System Landscape --> System Landscape Overview

Create the Backend System Entry :

New --> SAP System Using Dedicated Application Server
SYSTEM NAME: <SID>CLNT<ClientNO>
ADD Alias : <AID>CLNT<ClientNO> --> Finish

Configure the Backend System :
Choose System Alias --> Configure --> Modify Properties

Connector
Application Host : FQDN of ABAP
Gateway Host : FQDN of ABAP
Gateway Service : Gateway Service Port of ABAP
Logical System Name : <SID>CLNT<ClientNo>
SAP Client : ABAP Productive Client
SAP System ID (SID) : ABAP SID
SAP System Number : ABAP Instance No.
Server Port : ABAP Message Server port
System Type : SAP_R3

Information
System Name : <SYSTEM ALIAS>

Internet Transaction Server (ITS)
ITS Description : ABAP ITS
ITS Host Name : <ABAP FQDN>:<ICM PORT>
ITS Path : /sap/bc/gui/sap/its/webgui
ITS Protocol : http/https

User Management
Logon Method: SAPLOGONTICKET
User Mapping Fields
User Mapping Type : admin,user

Web Application Server (Web AS)
ICM Host Name : <ABAP FQDN>:<ICM PORT>
ICM Protocol : http/https
ICM URL Prefix : /sap/bc/webdynpro/sap
SAP NetWeaver
AS Description : ABAP WEB AS

7. Restart the Application Server of ABAP and Portal System.

8. Now login with the admin user created in Step 2 and do the connection test of System Alias.

9. Select the System Alias and Click Established trust and provide the admin user credentials.

10. Test the SSO configuration

Netweaver Portal :
Path: System Administration --> Support --> Application Integration and Session Management --> Test and Configuration Tools --> Tools (Transaction) --> RUN
SYSTEM : System Alias
Transaction : SM59/SM50 --> GO

Rebuild the Oracle 11g DR configuration for SAP using File System Copy

Procedure :

a. Standby Site

1. Shutdown the database.

$ su – ora<sid>
SQL> shutdown immediate;

2. Delete all files under /oracle/SID/sapdata<n>, /oracle/SID/mirrlog<n>, /oracle/SID/origlog<n>.

b. Primary Site

3. Begin Backup mode

SQL> alter database begin backup;

4. Copy all the under /oracle/SID/sapdata<n>, /oracle/SID/mirrlog<n>, /oracle/SID/origlog<n>.

5. Create the standby database control file for standby

SQL> alter database create standby controlfile as '/oracle/<SID>/stdby_control.dbf' reuse;

6. End Backup Mode

SQL> alter database end backup;

c. Standby Site

7. Start the database in mount

SQL> startup mount;

8. Check the database role

SQL> select status,instance_name,database_role,open_mode from v$database,v$Instance;

9. Start the log replication and log apply

$ lsnrctl start
SQL> alter database recover managed standby database disconnect from session;

10. Check the logs are getting applied

SQL> select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;

Rebuild the Oracle 11g DR configuration for SAP using RMAN

Procedure :

a. StandBy Site

1. Shutdown the database.

su – ora<sid>
shutdown immediate;

2. Delete all files under /oracle/SID/sapdata<n>, /oracle/SID/mirrlog<n>, /oracle/SID/origlog<n>

3. Execute the following command

SQL> startup nomount pfile=/oracle/AB1/11203/dbs/initAB1DR.ora
ORACLE instance started.

Total System Global Area 1.8774E+10 bytes
Fixed Size 2236128 bytes
Variable Size 9596567840 bytes
Database Buffers 9126805504 bytes
Redo Buffers 48386048 bytes
SQL>

b. Primary Site

4. Execute the following commands

pgpbibpprddc2:oraAB1 17> rman target sys/sap123@AB1_PRIMARY.WORLD auxiliary sys/sap123@AB1DR_STANDBY.WORLD

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 14 12:35:04 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: AB1 (DBID=2377696196)
connected to auxiliary database: AB1 (not mounted)

RMAN>
run {
allocate channel ch1 type disk;
allocate channel ch2 type disk;
allocate channel ch3 type disk;
allocate channel ch4 type disk;
allocate channel ch5 type disk;
allocate channel ch6 type disk;
allocate channel ch7 type disk;
allocate channel ch8 type disk;
allocate auxiliary channel ch10 type disk;
allocate auxiliary channel ch11 type disk;
allocate auxiliary channel ch12 type disk;
allocate auxiliary channel ch13 type disk;
allocate auxiliary channel ch14 type disk;
allocate auxiliary channel ch15 type disk;
allocate auxiliary channel ch16 type disk;
allocate auxiliary channel ch17 type disk;

duplicate target database for standby from active database DORECOVER NOFILENAMECHECK
spfile
set db_unique_name='AB1DR'
set control_files='/oracle/AB1/origlogA/cntrl/cntrlAB1DR.dbf','/oracle/AB1/origlogB/cntrl/cntrlAB1DR.dbf','/oracle/AB1/sapdata1/cntrl/cntrlAB1DR.dbf'
set log_archive_max_processes='10'
set fal_client='AB1DR_STANDBY.WORLD'
set fal_server='AB1_PRIMARY.WORLD'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(AB1,AB1DR)'
set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.102.1.168)(PORT =1521))'
set log_archive_dest_1= 'LOCATION=/oracle/AB1/oraarch/AB1arch MANDATORY Valid_for=(all_logfiles,all_roles) db_unique_name=AB1DR'
set log_archive_dest_2= 'SERVICE=AB1_PRIMARY.WORLD ARCH VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=AB1'
;
}