|
RMAN can help in both of your requests. First, you need a baseline backup. With RMAN, this baseline backup can be hot or cold. You can then perform incremental backups on a daily basis. These incremental backups can replace your nightly hot backups. Since these nightly backups are incremental, your backup time should be significantly reduced. Only those blocks that have changed since the last baseline backup or incremental backup will be backed up. Those blocks that
haven't changed will not be backed up.
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.
|