Answer / 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.

Answer / hiren

I have done it in R/3 4.7, not sure about ECC-5.

Answer / muneer

Homogeneous system copy is done using Netweaver 2004 or
2004s master cd/dvd/media. Just select the type of
configuration (db, OS) for both the source and target system
and follow the steps.

In which table failed user login attempts will be there?

1 Answers  

---

Dear all, I m looking out a Remote Support Service for SAP BASIS opperation, my entire database is within my company only, and we are currently using SAP 4.7, we also looking for upgratation to ECC 6.0. Can any one suggest me who the company is beetr for Upgradation as well as REMOTE BASIS SUPPORT. kindly provide me the PRICE for Remote SAP BASIS SUPPORT SERVICES. Thanks in advance

14 Answers  

---

What is Hit Ratio?

1 Answers  

---

What are homogeneous copy and heterogeneous copy and how you will do that? how to impot the OSS notes? What is OCS how to apply OCS patches? ABAP service pack level can found in SPAM, but how to find the java stack level?

2 Answers  

---

Problem in SPAM taking lot of time? Why?

2 Answers  

---

---

What do will do in OS level monitoring

3 Answers   HCL,

---

What Is your landscape

1 Answers   IBM,

---

1)Have you used performance tuning? What major steps will you use for these? 2)In production what is the user exit? 3)What type of user exits have you written? 4)Difference between Search Helps and Match Codes 5)On which even we can validate the input fields in module progams? 6)what are the table controls in BDC ? 7)what is the difference between bdc and lsmw ? 8) If the scripts are client dependent, what above driver program ? (client dependent / independent) 9). I have two pages, In one page I want address, Header, Main & footer. In the second page I want only Main. How to do it? 10) Will 50,000 records be uploaded directly into APP's Server? 11) What is the button to change the variant in ALV ? 12) If your project is support project ? when is your implementation has completed ? 13)In start of selection, if we perform validation, what happens ? 12)How to join 3 tallies & looping. We have developed a program in a client say (200- client) and 210 has test data. No developing rights. How to test data? 13)How to transfer data which is coming from are report as output to another report 14)How to create standard text and how do u transfer it ? 15)What are the views when we are creating Material ?

0 Answers   ABC,

---

What are the regular activities u do in solution manager and how

0 Answers  

---

how many max user's can apply for one application server? last limitation pls tell me in figure.

4 Answers  

---

Explain what is heterogenous system copy and homogenous system copy ?

0 Answers  

---

1. Can we change the data file location from existing directory?

3 Answers   IBM,

---