June, 2023

RMAN: Folling forward and Oracle Standby DB with “recover from service”

You have a standby DB out of sync and all logs on primary are gone. At this stage you have 2 options: 1:- rebuild standby 2:- Rollforward standby What about a “one line” command that does automatically all the steps you usually do on a rollforward? Here is the magic: After this, you just need... » read more

RMAN duplicate for standby fails with ORA-19845

While recreating an standby DB from an active primary RAC DB, rman might fail with these errors: This is not an actual issue on the standby side, but instead a RMAN config on primary. Since primary is a RAC DB, snapshot control file needs to be located on a shared location, so lets change to:... » read more