Showing posts with label recover from service dataguard. Show all posts
Showing posts with label recover from service dataguard. Show all posts

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;