Database Backup and Recovery (MOSC)

MOSC Banner

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)';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center