My Oracle Support Banner

EM 13c: Migrate_db Fails In Prepare Phase In Step "Convert datafiles on destination host" With Error "ORA-19584: file /u01/db/BACKUP/USERS_7.dbf already in use". (Doc ID 2694986.1)

Last updated on AUGUST 26, 2020

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control, while performing emcli migrate_db fails in step "Convert datafiles on destination host" With Error "ORA-19584: file /u01/db/BACKUP/USERS_7.dbf already in use".

Command:

$ emcli migrate_db -file="/u03/migrate_scripts/tts_final.xml"
Migrate database deployment procedure submitted successfully: ONLINE_DBCONSOLIDATION_USING_TTS 1589720475057

Job Step Log:
Job Steps Log for Job :Convert datafiles on destination host
RMAN> restore from platform 'Linux x86 64-bit' FOREIGN DATAFILE 7 format
'/u01/db/BACKUP/USERS_7.dbf' from backupset
'/u01/db/DESTINATIONBACKUPS/ttsParent/scriptTemp/USERS_7_06v32ksh_1_1.bkp';2>
3>
Starting restore at 18-JUN-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=35 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/18/2020 14:54:52
ORA-19584: file /u01/db/BACKUP/USERS_7.dbf already in use

Cause

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
Symptoms
Cause
Solution
References

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