Skip to main content

Posts

Showing posts from October, 2020

RMAN refresh standby database from backup

  Record the steps I took to refresh standby database: couple of links I use as reference: https://support.oracle.com/epmos/faces/SearchDocDisplay?_afrLoop=467283015956943&_afrWindowMode=0&_adf.ctrl-state=fuirhqzw5_4 https://walkthrough-dba.blogspot.com/2019/04/rman-duplicate-database-without.html step 1:  on primary: take a backup to file system run  { allocate channel c1 type disk;  allocate channel c2 type disk;  backup as compressed backupset database format '/u99/jsun/ffdeip/backup_%d_%U';  backup as compressed backupset archivelog all format '/u99/jsun/ffdeip/backup_%d_%U'; backup current controlfile for standby format '/u99/jsun/ffdeip/stby_control_ffdeip.bck' } step 2: transfer the backup in step 1 to standby host, e.g. scp step 3: on standby: duplicate to standby srvctl start instance -d FFDEIPDG -i FFDEIPDG1 -o nomount asmcmd rm +oradata01/ffdeipdg/datafile/* asmcmd rm +oradata01/ffdeipdg/tempfile/* asmcmd rm +oraflash01/ffdeipdg/archivelog/* e