Monthly Archives: January 2017

Unknown's avatar Frank 6:16 pm on January 29, 2017  

duplicate database to another host

pre-duplicate

alter system set cluster_database=false scope=spfile sid='*';

duplicate

-- shutdown auxiliary database
-- startup nomount

-- rman script
run
{
}

-- run command
rman catalog rcat/rcat@rcatdb auxiliary / msglog= cmdfile=

post-duplicate

alter system set cluster_database=true scope=spfile sid='*';
Unknown's avatar Frank 6:13 pm on January 29, 2017  

create physical standby in oracle 12

prepare standby

prepare primary

rman duplicate

-- backup primary
run
{
sql "alter system switch logfile";
sql "alter system checkpoint";
backup database;
backup archivelog all delete input;
backup current controlfile for standby;
}

-- duplicate to auxiliary
run
{
  duplicate target database for standby nofilenamecheck dorecover;
}

dataguard broker setup

enable/disable log transport

validation