Saturday, 16 February 2019

Resolve archivelog gap using service

Resolve archivelog gap using service(12c new feature)
In standby side:
rman target /
RMAN>recover database from service <primary service name> noredo using compressed backupset;
RMAN>shutdown immediate
RMAN>startup nomount
RMAN>RESTORE STANDBY CONTROLFILE FROM SERVICE <primary service name>;
RMAN>alter database mount;
Start mrp using below command.
sql>alter database recover managed standby database disconnect from session;