Oracle EBS 12.2.3
Database 19.15
Linux 7.9 vm on OCI
EBS instance on OCI. Rman is backing up to object storage.
Need to clone using an rman backup.
because i need to clone,
because i need to know the backups are ok and can restore from them.
To check for the backup time to use, on the source (production) i ran rman 'list backup summary';
I used the date/time from the last archive log listed. I am assuming 20-DEC-2022 161609 161609 is the time.
This is the duplicate command:
#!/bin/sh
export server=`hostname -s`
export today=`date +%Y%m%d_%M`
export log=/mount/clone/dupdev3_${today}_dev3.log
export NLS_DATE_FORMAT=DD-MON-RR_HH24:MI:SS
rman >> $log << EOF
connect catalog RCAT/***@Rman
connect AUXILIARY /
set decryption identified by "*****";
run {
allocate auxiliary channel c1 device type sbt PARMS 'SBT_LIBRARY=/u01/app/oracle/admin/opc/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oracle/admin/opc/config/opcCDBDEV3.ora)';
allocate auxiliary channel c2 device type sbt PARMS 'SBT_LIBRARY=/u01/app/oracle/admin/opc/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oracle/admin/opc/config/opcCDBDEV3.ora)';
allocate auxiliary channel c3 device type sbt PARMS 'SBT_LIBRARY=/u01/app/oracle/admin/opc/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oracle/admin/opc/config/opcCDBDEV3.ora)';
allocate auxiliary channel c4 device type sbt PARMS 'SBT_LIBRARY=/u01/app/oracle/admin/opc/lib/libopc.so, SBT_PARMS=(OPC_PFILE=/u01/app/oracle/admin/opc/config/opcCDBDEV3.ora)';
duplicate database CDBPRD to CDBDEV3 nofilenamecheck until time "to_date('20-DEC-2022 16:16:09', 'dd-mon-rrrr hh24:mi:ss')";
}
exit
EOF
This is the error
Oracle instance shut down
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/20/2022 18:29:53
RMAN-05501: aborting duplication of target database
RMAN-05624: data file name not found in the repository for data file number=236
RMAN-05624: data file name not found in the repository for data file number=235
We have a standby but it is broken. The consultant that is going to fix it, has not been able to. When the archive log directory on production fills up, we have to back them up and delete them manually. Not sure how to turn it off so it's not connected. Someone gave me some steps, but it seems to totally remove the standby, and that is not what we want, we need it fixed eventually.
Is this what is interfering with the duplicate command? Is there a way to make it so the standby is not affecting production if that is the issue?
I've clone a database more times than is countable onsite. This is the first time on OCI.