My Oracle Support Banner

How to relocate database files using RMAN (Doc ID 755620.1)

Last updated on JANUARY 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Goal

How to relocate all database files - datafiles, online redo logs, and controlfiles. This requires the database to be in mounted mode.

Non-system datafiles can be relocate with minimal outage - see solution 2.

 

Solution

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

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


In this Document
Goal
Solution
   
 For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
 ****************
 Solution 1 - How to relocate all database files
 Solution 2 - How to relocate a non-system datafile

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