Oracle7 Server Administrator's Guide

Contents Index Home Previous Next

Renaming and Relocating Online Redo Log Members

You can rename online redo log members to change their locations. This procedure is necessary, for example, if the disk currently used for some online redo log files is going to be removed, or if datafiles and a number of online redo log files are stored on the same disk and should be separated to reduce contention.

To rename online redo log members, you must have the ALTER DATABASE system privilege. Additionally, you might also need operating system privileges to copy files to the desired location and privileges to open and back up the database.

Before renaming any online redo log members, ensure that the new online redo log files already exist.

Warning: The following steps only modify the internal file pointers in a database's control files; they do not physically rename or create any operating system files. Use your computer's operating system to copy the existing online redo log files to the new location.

Rename online redo log members with the Rename Logfile Member property sheet of Server Manager, or the SQL command ALTER DATABASE with the RENAME FILE parameter.

To Rename and Relocate Online Redo Log Members

Suggestion: You can execute an operating system command to copy a file without exiting Server Manager. Use the Server Manager HOST command.

The following example renames the online redo log members. However, first assume that:

The files LOG1A and LOG2A on Disk A must be copied to the new files LOG1C and LOG2C on Disk C.

ALTER DATABASE
   RENAME FILE 'log1a', 'log2a'
      TO 'log1c', 'log2c';


Contents Index Home Previous Next