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 is ocm and how to apply ocm patches?

1036


Error in the phase import_proper while applying support packages?

1338


Where do you check transport request logs?

657


What is oracle Architecture?

1684


What is the difference between consolidation and development route ?

741






How to transport objects from Production to Development?

1689


Hi All I am Vamshi I Provide Training on ECC Security, Bi Security, HR Security, GRC Access Control Suit(RAR SPM CUP ERM), SRM Security and CRM Security. Duration: 30 days Fees: Rs 7000/- Vamshi Krishna +91-7569362152 email: s.sap30@gmail.com

1875


Why can't we do it thru some other client?

1624


What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?

2754


what are the current support stack levels at market place?

1806


Differentiate between synchronous and asynchronous transport

650


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

729


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?

602


User wants lock ASAP then what will u do?

1469


Can you change the profile parameter in the os level? Which one is advisable why?

770