Tuning I/O - Oracle Database 11gR2 Performance Tuning - page 408

8. Alter the location of the log files:
ALTER DATABASE RENAME FILE '/u01/oradata/TESTDB/redo01.log'
TO '/u01/oradata/TESTDB2/redo01.log';
ALTER DATABASE RENAME FILE '/u01/oradata/TESTDB/redo02.log'
TO '/u01/oradata/TESTDB2/redo02.log';
ALTER DATABASE RENAME FILE '/u01/oradata/TESTDB/redo03.log'
TO '/u01/oradata/TESTDB2/redo03.log';

9. Open the database:

ALTER DATABASE OPEN;

10. Separate redo log files and archived redo logs, placing them on separate disks. To
change the destination of archived redo logs, execute the following steps; otherwise,
go to step 14. Shut down the database:
SHUTDOWN IMMEDIATE

11. Mount the database:
STARTUP MOUNT

12. Alter the parameter for archived redo log locations:
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 =
'LOCATION=/u01/oradata/disk1/archive';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 =
'LOCATION=/u01/oradata/disk2/archive';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_3 =
'LOCATION=/u01/oradata/disk3/archive';

13. Open the database:
ALTER DATABASE OPEN;

14. Move heavily-accessed files to a separate disk. If you want to move the EXAMPLE
tablespace to another disk, perform steps similar to step 5 through step 9. Take the
tablespace offline:
ALTER TABLESPACE EXAMPLE OFFLINE;

15. Move the data files using the O/S commands:
!mv /u01/oradata/TESTDB/example01.dbf
/u01/oradata/TESTDB2/example01.dbf

16. Alter the location of the data files:
ALTER DATABASE RENAME FILE '/u01/oradata/TESTDB/example01.dbf'
TO '/u01/oradata/TESTDB2/example01.dbf';