I am having trouble cloning a database. This was working but I am unsure what I am doing differently now. First I was backing up the database.
BACKUP DATABASE
FORMAT '/ora2/adhoc_bkp/HEPRD_5_2_2014_%u.bak'
TAG HEPRD_ADHOC_2014_05_23
I believe the backup will be a backupset and compressed this is set as the default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO COMPRESSED BACKUPSET;
After the backup I would then sftp the files to the server where I want to do the clone
Then I would start the auxiliary instance via an init file
STARTUP FORCE NOMOUNT PFILE=$ORACLE_HOME/dbs/init2.ora
Finally I was running a duplicate using the following.
DUPLICATE TARGET DATABASE TO HEUPX
SPFILE
PARAMETER_VALUE_CONVERT 'HEPRD', 'HEUPX'
SET CONTROL_FILES='/m60/oradata/HEUPX/control01.ctl', '/d60/oradata/HEUPX/control02.ctl',
'/x60/oradata/HEUPX/control03.ctl'
SET DB_UNIQUE_NAME='HEUPX'
SET DB_FILE_NAME_CONVERT '/d10/oradata/HEPRD/', '/d60/oradata/HEUPX/',
'/m10/oradata/HEPRD/', '/m60/oradata/HEUPX/',
'/x10/oradata/HEPRD/', '/x60/oradata/HEUPX/'
SET LOG_FILE_NAME_CONVERT '/m10/oradata/HEPRD/', '/m60/oradata/HEUPX/'
SET DB_RECOVERY_FILE_DEST '/ora2/FRA'
# SET DB_RECOVERY_FILE_DEST_SIZE '250G'
SET MEMORY_TARGET '2147483648'
SET MEMORY_MAX_TARGET '2147483648'
SET INSTANCE_NAME 'HEUPX'
BACKUP LOCATION '/ora2/adhoc_bkp';
The problem I am getting is it keeps telling me
RMAN-05569: SPFILE backup not found in /ora2/adhoc_bkp
So I do not understand why it can not see the backup. Is it because I am doing a backupset? What am I missing