Restoring / Cloning a database from the backup of standby database
Hello All
We have a 19c (19.26) production and physical standby (ACTIVE) database
We are backing these up to Data Domain. We usually use the primary database backup to clone non production environments
The script looks like this and this has been working for us pretty well
runDuplicateScript() {
echo "Starting RMAN Duplicate at $(date)" >> $TMPLOG
rman auxiliary / <<EOF
connect target sys/<Password>@PRIMARYDB
run {
set until time "to_date('2026-05-8 21:00:00','YYYY-MM-DD:HH24:MI:SS')";
allocate auxiliary channel ch01 DEVICE TYPE SBT_TAPE PARMS 'SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so,ENV=(STORAGE_UNIT=FLDD9900_RMAN,BACKUP_HOST=DDHOST,RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';