Rolling Forward a Physical Standby Database Using the RECOVER FROM SERVICE


Hi
Since Oracle 12c we can recover standby only by accessing the standby database/site, no need to copy nor transfer any file
Short and easy - just copy and paste
enjoy :)

Standby Database Name: STBY
Primary Database Name: PRIM

On Standby
sqlplus / as sysdba
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

rman target /
RECOVER DATABASE FROM SERVICE PRIM USING COMPRESSED BACKUPSET NOREDO SECTION SIZE 120M;

sqlplus / as sysdba
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;

rman target /
RESTORE STANDBY CONTROLFILE FROM SERVICE PRIM;

sqlplus / as sysdba
ALTER DATABASE MOUNT STANDBY DATABASE;

rman target /
CATALOG START WITH '+DATA/STBY/DATAFILE/';
SWITCH DATABASE TO COPY;

sqlplus / as sysdba
set pages 0 verify off feed off term off echo off
spool /tmp/clear.sql
select distinct 'ALTER DATABASE CLEAR LOGFILE GROUP '||GROUP#||';' as cmd from v$logfile;
spool off
@/tmp/clear.sql
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

For Oracle 11g there is a longer version, see Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (Doc ID 836986.1)

Yossi

Comments

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP