3. Move the log files to a different location using operating system tools.
4. Start the database in mount mode:
$ sqlplus
SQL> connect user/password@service as sysdba;
SQL> startup mount;
5. Register the new locations for each moved file:
SQL> alter database rename file 'OldPathName' to
'NewPathName';
where OldPathName and NewPathName are full paths to the log file.
6. Open the database in normal mode:
SQL> alter database open;
Moving Control Files
To move the control files from the source volumes to be replicated, to other locations:
1. Determine if the database uses the SPFILE parameter:
SQL> show parameter SPFILE
2. If the database does not use SPFILE:
a. Shut down the database.
SQL> shutdown
b. Move the control files to a different location using operating system tools.
c. Edit the CONTROL_FILES parameter in the database's initialization
parameter file (usually located in the $ORACLE_HOME/dbs/initSID.ora
directory) to change the existing control file names:
control_files = ("NewPathName", ...)
d. Restart the database:
SQL> startup
If the database uses SPFILE:
a. Specify the new location for control files by running the following command:
SQL> alter system set control_files='NewPathName1',
'NewPathName2',..., scope=spfile
b. Shut down the database.
Appendix422
To Next Page
Loading...
Need help?
General