HOW CAN I DO HOMOGENOUS SYSTEM COPY (ECC5.0)?TELL STEP BY
STEP PROCESS?
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.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the key activities that you perform as part of sap basis support?
I would like to know the version or name of SAP that is implemented in real time?
What are the different options available for scheduling a background job? What start conditions type can be used?
Hi Shridher, Would you please send me an SAP CRM question and Answer to siri.testing@gmail.com Thanks, siri
Explain logon groups?
In a situation where my sap system is down (users unable to login to sap system), how to analyze the problem?
What are the activities you done in PI?
When should we use Transactional RFC?
What are the different modules of SAP?
How to make security authorization reports?
How to find users used transaction codes which are not authorized for?
How do you generate (recover) old system logs in a newly created SLOG00?
Do you have done System copy? What are the steps?
What is the purpose of support package?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?