How to Recover with an RMAN Backup Without Resetlogs
I have two 10.2.0.4, ASM- managed databases. Streams capture and propagate runs on database A, and apply runs on database B. Before performing maintenance on these two, I can take either an online or offline RMAN backup. The point of the backup is to have a return point, should Streams fail as a result of the maintenance.
However, if I use an RMAN offline or online backup and have to issue a "resetlogs" command, Streams capture may abort. Can anyone recommend any documents with instructions for an RMAN restore and recovery without the need to resetlogs? MetaLink document 780229.1 states "A potential workaround is to perform cancel based recovery up to but not including the current online redo log." I am not clear on the steps needed to accomplish this.