What we want:
1) Hot backup time reduced. 2) Ability to create reporting database using this backup daily. This process also should be faster than what we have now. I would like to know how RMAN can help our scenario.
Now that RMAN is backing up your database, you can use RMAN to create a clone of that database on another server for your reporting applications. RMAN doesn't care if the clone is created from a full database backup or from the baseline plus incrementals. RMAN will handle all of this for you!
Please read the RMAN documentation as it contains all of the information you'll need for incremental backups and for creating clones of the database.
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