Thursday, February 2, 2012

DB Refresh steps in sap


PROCEDURE FOR DB REFRESH:
1)      Take full offline backup of database using BRTOOLS/DB13.
Brbackup –u –p init<sid>.sap –d disk –t offline –m all
2)      Generate the control file
SQL> alter database backup controlfile to trace;
Get the trace file from user trace directory and modify the file as following
è Rename the file to control.sql.
è Remove all the content above the line  STARTUP NOMOUNT and below CHARACTER SET URF8;
è Replace NORESETLOGS with RESETLOGS.
è Replace ARCHIVELOG with NOARCHIVELOG.
è Replace S_sid with T_sid.
3)      Change the S_sid with T_sid in b***.afd backup log file.
4)      Change the S_sid with T_sid  in the first file of backup folder and rename to target sid.
5)      Restore the database using the command
Brrestore –u 0b b***.afd -d disk –k yes -m all
6)      Login to database start the database(startup nomount).
7)      Run @contro.sql file.
SQL>select status from v$instance; it is in mounted state.
SQL>alter database open resetlogs; now it goes to open status.
SQL> select username from dba_users;
8)      Now copy ORADBUSR.SQL file from installation folder copy to sap backup directory and run.
SQL> @ORADBUSR.SQL
Enter value for  1: schema owner ID SAPSR3
                                2: file system NT
                                3: host name
                                4: SAP SID
Now again check the users
SQL>select username from dba_users;
Now you can see target system users only. Remove the source system users.
9)      Drop user
OPS$HOSTNAME\SIDADM  cascade.
10)   Now provide the permission to the target system users.
SQL> grant connect sapdba to “OPS$Hostname/SIDADM”;SAPSERVICESID;
SQL>grant dba to  “OPS$Hostname/SIDADM”;SAPSERVICESID;
11)   Now start the SAP system and is working or not.


 
See Related posts
26.DISABLE SAP USERS TO LOGON MULTIPLE TIMES27.SUPPRESS SAP MULTI LOGIN MESSAGE28.ADDING TEXT TO THE SAP LOGON/LOGIN SCREEN

29.HOW TO CREATE COMMUNICATION BETWEEN R3 SYSTEM &BW SYSTEM30.CLIENT EXPORT IMPORT PROCEDURE SCREEN SHOTS (CLIENT COPY)




Reactions:

16 comments:

a pride for me to be able to discuss on a quality website because I just learned to make an article on
cara menggugurkan kandungan

Nice Post! It is really interesting to read from the beginning & I would like to share your blog to my circles, keep sharing.
Top Most IOS Training Institute in Chennai | Top Most IOS Training Institute in Velachery

It is really very excellent blog; I find all of your blogs were amazing and awesome. The way to get expert tips from everyone, not only I like that posts all peoples like that post.
Outstanding Selenium Training Institute in Chennai | Outstanding Selenium Training Institute in OMR

This comment has been removed by the author.

Wonderful article, thanks for putting this together! This is obviously one great post. Thanks for the valuable information and insights you have so provided here.
Perfect Python Training Institute in Chennai | Perfect Python Training Institute in Perungudi

I read your blog which is really good. Thanks for sharing valuable information with us. Excellent Article.Nice to read your article, very informative.
Best Cloud Computing Training Institute in Chennai | Best Cloud computing Training Institute in Chrompet

Great post. wonderful information and really very much useful. Thanks for sharing and keep updating.
VMware Training Institute in Chennai | VMware Training Institute in Keelkattalai


I like the blog format as you create user engagement in the complete article. Thanks for the informative posts. Regards,
Perfect Cloud Computing Institute in Chennai | Perfect Cloud Computing Institute in Guindy

Your article was so impressive and informative. Its very interesting to read. Thanks for sharing,
Best Python Training Institute in Chennai | <a href="https://www.alltechzsolutions.in/python-training-in-chennai.php”> Best Python Training Institute in Naganallur </a>


Pretty article! I found some useful information in your blog, Thanks for sharing this great content to my vision, Keep sharing.
TopMost Cloud Computing Training Institute in Chennai | TopMost Cloud Computing Training Institute in Tambaram

This is extremely helpful information. Very good work. Everything is very interesting to learn and easy to understood. Regards,
Excellent VMWare Training Institute in Chennai | Excellent VMWare Training Institute in Adyar

Nice Post! It is really interesting to read from the beginning & I would like to share your blog to my circles, keep sharing.
Linux Training in Chennai | Linux Training in T.nagar

Post a Comment