Applying archivelogs to a cold backup - shortcut?

Hi all,

  I've lost a database. Disk went bad. Ouch.

  So anyway, I have a cold backup of that db. I restored it, and now want to apply the archivelogs to it.

  So I started with a 'alter database recover until cancel using backup controlfile;'

  After that, Metalink tells me to do a 'alter database recover continue default;'

  The only problem is, that seems to apply one log, so I have to execute that statement once per archivelog. I've got 800+ archive logs to apply, and this could take a very long time if I've got to do each one by hand.

  Is there an automatic way to do this? I'm on Oracle 8.1.8 / Solaris 2.8.

    Jason Received on Mon Nov 19 2001 - 02:11:14 CST