Answer Posted / sandeep

1. Take a backup control file to trace from the source (SRC)

sql:>ALTER DATABASE BACKUP CONTROL FILE TO TRACE
AS '<PATH>';

2. Stop the DB & app is stoped in SRC.

3. Copy the datafiles, redo logs and control files from SRC
to targert(TRG). We will get the location of these file
from v$controlfile, v$lofile and v$datafile when
the DB is opened.

4. Edit the pfile in the TRG so that the path of datafiles
and redologs are same as in the backup control file.

5. Edit the backup control file, as per the situation, i.e.
reset/noreset & archive/noarchive log mode and save the
same as *****.sql.

6. Startup the DB in nomount using the edited pfile.

7. Run the sql script, ie

sql:>@****.sql

It will create the control file in the location specified
in the pfile.

8. Open thE DB.

sql:>ALTER DATABASE OPEN RESETLOGS;

9. Database opened.
10. Do the post activities in the table level ans start
sap.

The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?

2436

---

Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.

4978

---

How to update SAP

1784

---

can u explain step by step procedure of DB REFRESH..Ravi

3690

---

What are the different user types in sap system that an admin can use while creating a new user?

1025

---

Explain logon groups?

1097

---

Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance

2530

---

What are the Pre- requisite for system copy?

1774

---

When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?

1134

---

Hi,My name is Saurabh I have done BMS & currently working in Wipro BPO (1 year). I want to pursue my career in SAP. As I am totally new in the IT field(no course & no experience) Please could you suggest whether to do a certification from Certified institutes or Non Certified institutes.What is the difference? Also, Is MBA necessary to do certification from Certified institutes?

2250

---

Is system user sap basis consultant and dialogue user other user like fico, hr, mm user?

1473

---

What is the use of commit value while deleting jobs in sap system?

1009

---

what is role of sap administrator in pi & ep?

2078

---

What are the DVD's Download for implementation?

1936

---

What are the Parameters need to be set when connecting EP to r/3 system what are they?

1783

---