This discussion is archived
1 Reply Latest reply: Jun 23, 2011 2:07 AM by 423754 RSS

tips on speeding up recover database

839604 Newbie
Currently Being Moderated
Hi all,

A few questions on restore/recover database.

If a recover database command needs to apply many archive logs, does the process of restoring archive logs and then applying them benefit from multiple channels? Or does this run in serial since archive logs must be applied serially?

In my case, I am running via SBT_TAPE through NetBackup, which is reading and writing to a disk based device.

Ben
  • 1. Re: tips on speeding up recover database
    423754 Newbie
    Currently Being Moderated
    I tested in my UAT environment but unable to see that they are using more channel to apply the recovery.

    The only thing that actually speed up is when restoring archivelog from backupset to disk level as I noticed that is using the channel I allocated.

    One more parameter you can look into is recovery_parallelism.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points