Saturday, March 04, 2017

RMAN DB Duplicate Script

$ORACLE_HOME/bin/rman nocatalog log=rman_restore_STG4_$(date +"%Y-%m-%d-%S").log <<EOF
connect auxiliary sys/manager@STG4
run
{
allocate auxiliary channel dup1 type disk;
allocate auxiliary channel dup2 type disk;
allocate auxiliary channel dup3 type disk;
allocate auxiliary channel dup4 type disk;
allocate auxiliary channel dup5 type disk;
allocate auxiliary channel dup6 type disk;
allocate auxiliary channel dup7 type disk;
allocate auxiliary channel dup8 type disk;
allocate auxiliary channel dup9 type disk;
allocate auxiliary channel dup10 type disk;
duplicate target database to STG4 nofilenamecheck backup location '/backups/rman/PRD2/';
}
EOF

No comments:

Oracle EBS integration with Oracle IDCS for SSO

Oracle EBS integration with Oracle IDCS for SSO Oracle EBS SSO? Why is it so important? Oracle E-Business Suite is a widely used application...