RMAN image copy restore question

From: <wblanchard_at_oshkoshcorp.com>
Date: Mon, 6 Aug 2012 16:01:34 -0500
Message-ID: <OF8C826E24.DBE33450-ON86257A52.007309BA-86257A52.0073802E_at_oshkoshcorp.com>

I'm investigating different ways of backing up my databases and have a question that I couldn't find a good answer for... If you have an image copy backup, and are using incrementals to update the image copies, is it possible to restore to a point in time prior to the backup? Backup runs at 9pm and updates the image copy backup

Backup completes at 5am.

Archivelogs backed up once per hour

Point in time restore is requested for 5pm the previous day.

My belief is that once the image copy is restored using the incremental there's no way to go back before 5am.

Thank you,

WGB Although this e-mail and any attachments are believed to be free of any virus or other defect which might affect any computer system, it is the responsibility of the recipient to check that it is virus-free and the sender accepts no responsibility or liability for any loss, injury, damage, cost or expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential information and intended only for the use of the individual or entity named above, and may be privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this transmission in error, please contact the sender immediately, delete this material from your computer and destroy all related paper media. Please note that the documents transmitted are not intended to be binding until a hard copy has been manually signed by all parties. Thank you.

Received on Mon Aug 06 2012 - 16:01:34 CDT

Original text of this message