how can u change the location of control files of oracle in sap?

Answer Posted / shashisy

One way is ....

1. Shutdown the databse
2. Copy the control file to the new location
3. Adjust the changes in your ini<SID>.ora ( spfile as
applicable) the parameter CONTROL_FILES
4. Bring back the database

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

833


How can you find a list of objects that have been repaired in the system?

971


A user moved the transport request from dev to qua. How would you trace him?

990


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

823


What is osp$ mean?

1049


Explain kernel upgrade?

788


steps to congigure CMS in XI ?

1946


what are the current support stack levels at market place?

1979


What is process for applying patches?

871


What will you observe in st06?

1082


What is a developer key? and how to generate a developer key?

859


What are the different modules of SAP?

842


What is the need of having Development system?

1525


What is the purpose of table tadir?

968


Have you done any up gradations?

1953