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

Post a Comment

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information"

Autoconfig post 12C upgrade from 11g failed with "ORA-01804: failure to initialize timezone information" Error DB Autoconfig ...