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.

How do you check the installed software components and product versions on sap system?

981

---

What are the key activities that you perform as part of sap basis support?

1045

---

Explain logon load balancing?

1067

---

Some transactions in sap are seen as customizing, for instance ovrf (updating routes). In some systems this is set as master data and can be set open. Where do you do this?

1015

---

How database extend?

1862

---

Is it possible to install sap patches when other users are online?

983

---

Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?

1220

---

What is the use of account id in logon tab?

2125

---

What is osp$ mean?

1371

---

What is the purpose of table tdevc?

2560

---

what is garbage collector. is there any way to set the time to gc?

4255

---

Explain what are the functional modules used in sequence in bdc?

994

---

What is the purpose of support package?

1036

---

If a background job runs more than the time it should be completed normally then what actions will u take?

1770

---

For ex: i scheduled one ABAP program as a background job but it was running 10 days, how to analyze the problem?

1841

---