2. Shut down the database:
SQL> connect user/password@service as sysdba;
SQL> shutdown
SQL> exit
3. Move the log files to a different location.
$ mv /opt/oracle/product/9.2.0/oradata/redo* /oracle/logs
4. Start the database in mount mode:
$ sqlplus
SQL> connect user/ password@service as sysdba;
SQL> startup mount;
5. Rename the new locations for each moved file:
alter database rename file
'/opt/oracle/product/9.2.0/oradata/redo01.log' to
'/oracle/logs/redo01.log';
Database altered.
alter database rename file
'/opt/oracle/product/9.2.0/oradata/redo02.log' to
'/oracle/logs/redo01.log';
Database altered.
alter database rename file
'/opt/oracle/product/9.2.0/oradata/redo03.log' to
'/oracle/logs/redo01.log';
Database altered.
6. Open the database in normal mode:
SQL> alter database open;
Example - Moving Control Files for Oracle9i
In the following example, the Oracle9i database uses SPFILE. To move the control
files from /opt/oracle/product/9.2.0/ to /oracle/oractl:
Appendix424
To Next Page
Loading...
Need help?
General