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.

i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com

2130

---

what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?

2511

---

Where do you download trail version of sap ecc, what is sap cal?

1088

---

How to deactivate IPC in standalone CRM.

3022

---

you want to take sap backup using brtools. How would you do that?

1161

---

What is a support package?

972

---

Explain how to define logon groups?

1083

---

What is SSO? How to configure SSO?

1903

---

What are the different options available for scheduling a background job? What start conditions type can be used?

1065

---

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

1845

---

What is XI3.0? Explain XI

1200

---

What is heterogenous system copy and homogenous system copy ?

1052

---

What is the procedure to applying patches?

1129

---

Explain what is the use of reference and service user in sap?

1045

---

What are the types of transport queries?

1137

---