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/*

export NLS_DATE_FORMAT='yyyymmdd hh24:mi:ss'

rman  auxiliary  /

RUN

{

  ALLOCATE auxiliary  CHANNEL ch1 TYPE DISK MAXPIECESIZE 1G;

  ALLOCATE auxiliary  CHANNEL ch2 TYPE DISK MAXPIECESIZE 1G;

    duplicate database for standby NOFILENAMECHECK  backup location '/u02/app/oracle/jsun/ffdeip';

  }

step 4: recover and verify

SQL> recover managed standby database using current logfile disconnect;

SQL> alter database open read only;

SELECT inst_id,PROCESS, pid,client_pid,client_process,STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM gV$MANAGED_STANDBY

where (process='RFS' and thread#<>0) or process<>'RFS'

order by process, inst_id,thread#;

col name format a40

col value format a30

set linesize 200

 select recovery_mode from v$archive_dest_status where recovery_mode <> 'IDLE';

select * from v$dataguard_stats;