Role Forward Physical Standby Using service method
Oracle Physical standby sometimes can go out of sync and it may not be possible to get the archive logs due to the size and amount of time. In these cases earlier we need to either rebuild the standby or take the incremental backup from primary database and recover the standby. With 12c in place oracle introduced one more method commonly known as recover form service as well which makes this process simple and straightforward. Using service method does following 1. It takes the incremental backup from the SCN of the standby datafile and transfer that backup to DR site over the network (earlier this method use to be done manually). 2. Applies the incremental backup to physical standby. Lets discuss the steps now in detail: Step1 : Start the standby database is mount state. srvctl stop database -d <db unique name> srvctl start database -d <db unique name> -o mount Step2 : Stop the standby database recovery alter database recover managed standby database cancel;