My Oracle Support Banner

How to Rename or Move Datafiles and Logfiles (Doc ID 115424.1)

Last updated on JULY 05, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 and later
Enterprise Manager for Oracle Database - Version 11.2.0.4 and later
Information in this document applies to any platform.


Purpose

In many situations, a datafile or logfile must be renamed inside Oracle. Whereas the contents of the file remain valid, you need to define a new physical name or location for it. For example: 


- You want to move a database file to a different disk for performance or maintenance reasons.

- You have restored a datafile from backup, but the disk where it should normally be placed has crashed and you need to relocate it to a different disk.

- You have moved or renamed a datafile at operating system level but forgot to rename it within Oracle. At startup, you get ORA-01157 and ORA-01110. If the database is up and you try to shut it down normal or immediate, you get ORA-01116 ad ORA-01110.

- You have multiple databases on the same machine and you need to rename certain database files to prevent collision and confusion.

Scope

 This bulletin gives instructions to:

I. RENAME OR MOVE DATAFILE(S) WITH THE DATABASE OPEN 
II. RENAME AND OR MOVE DATAFILE(S) WITH THE DATABASE SHUT DOWN
III. RENAME AND OR MOVE A LOGFILE

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.