由 webmaster 发布于: 2001-03-02 21:57

How to relocate or rename online redo log files

1.copy the online redo log files to the new location
2.Execute the ALTER DATABASE RENAME FILE command.

The locations of the online redo log files can be changed by renaming the online redo log files.Before renaming the online redo log files , ensure that the new online redo log file exists.The oracle server changes only the pointers in the control files ,but does not physically rename or create any operation system files.


ALTER DATABASE [database] RENAME FILE 'filename'[,'filename']... TO 'filename'[, 'filename'] ...