How to Rename a Datafile in Primary Database Within in Physical Dataguard Configuration (Doc ID 733796.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 28-Sep-2012***

***Checked for relevance on 5-Aug-2014***
** Checked for relevance '25-Nov-2015' **


Goal

How to rename a datafile in the primary database and manually propagate the changes to the standby database.

When you rename one or more datafiles in the primary database, the change is not propagated to the standby database, even if the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO.

If you do not rename the corresponding datafile at the standby system, and then try to refresh the standby database control file, the standby database will attempt to use the renamed datafile, but it will not find it. Consequently, you will see error messages similar to the following in the alert log:

ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock datafile 14 - see DBWR trace file
ORA-01110: datafile 14: '/Disk1/oracle/oradata/mum/payroll_01.dbf'

Solution

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 hundreds of Community platforms