Skip to main content

Timeline for RMAN incremental restore

Current License: CC BY-SA 4.0

4 events
when toggle format what by license comment
Mar 24, 2020 at 3:38 comment added pmdba Check this out for a configuration example: docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/…
Mar 24, 2020 at 3:38 comment added pmdba You're going to have to stop the source DB applications, do a full backup, move your tapes and catalog them into the new backup system, then run the restore and recovery operation. Speed is going to depend almost entirely on your backup media and hardware; In my experience actual tape backups aren't particularly fast. If there's any way to do multipart/parallel backup sets and parallel restoration threads with your tape hardware that would be ideal. I would get in a couple of practice runs so you have a good idea how much time you'll need before the final migration.
Mar 24, 2020 at 0:24 comment added Franco Thanks for reply. That's what I was afraid of. We have no direct connection to the source DB unfortunately so the restore can only come from the backup pieces on tape. Can't restore to disk first either. What's the accepted best approach for restoring very large DBs (more than 50TB) as fast as possible?
Mar 23, 2020 at 23:38 history answered pmdba CC BY-SA 4.0