Case when you are working with initSID.ora file:
- Change the new paths in the init parameter CONTROL_FILES - Reference
- Shutdown the database in a clean way ( Preferrable overall is this a production database
- Move with OS commands the control files to its new location.
- Startup the database
Case when you are working with spfileSID.ora file:
- Change the new paths of the CONTROL_FILES parameter in the spfile with
ALTER SYSTEM SET CONTROL_FILES=... scope=SPFILE\"
CONTROL_FILES - Reference
ALTER SYSTEM - Reference - Shutdown the database in a clean way ( Preferrable overall is this a production database )
- Startup the database
No comments:
Post a Comment