Point-in-time recovery (PITR) by its very nature means that you will lose transactions. That is the idea! You want to restore the database at some point in time before all transactions.
Your standby databases will need to be restored to the same point as the primary database. You may find it easiest to use RMAN to clone the database, just like you did when you set up the standby database. Instructions are in the RMAN documentation.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.