Change location of controlfile..Does spfile need to be updated?
722130Sep 11 2009 — edited Sep 11 2009Following the steps below to change location of controlfile, so I need to update scope=spfile or scope = both. Please let me know. Thanks
Change location of controlfile on FVORCD17
1. Login to SQLPlus.
2. Connect as SYS DBA with CONNECT / AS SYSDBA command.
3. Shutdown the database instance with SHUTDOWN command.
4. Rename or/and move the datafiles at operating system level.
5. Start Oracle database in mount state with STARTUP MOUNT command.
6. Modify the name or location of datafiles in Oracle data dictionary using following command syntax:
ALTER DATABASE RENAME FILE ‘<fully qualified path to original data file name>’ TO ‘<new or original fully qualified path to new or original data file name>’;
7. Open Oracle database instance completely with ALTER DATABASE OPEN command.