Use RMAN KEEP Backup To Roll Back From an Upgrade
There is a requirement to back up a database before an application upgrade to be able to rollback. Guarantee Restore Point (GRP) was first considered by us; however, it looks like there is insufficient space from Flash Recovery Area (FRA). Further, the duration before the decision to rollback application upgrade is unknown, as it can be a week or a month. We made a decision to create RMAN KEEP UNTIL TIME backup to prevent deletion based on RETENTION POLICY. Here is a demo showing how to perform a RMAN KEEP backup and to restore from a RMAN KEEP backup. Please note there is no standby configuration for this environment. Please reference for standby environment Recovering Through the OPEN RESETLOGS Statement.