Re: Applying archivelogs to a cold backup - shortcut?

Never, ever use the 'alter database recover...' syntax. There's no need ('recover....' works perfectly well on its own, and doesn't suppress all the vital 'error' messages you need when performing recoveries).

All you need to do is issue the appropriate recover command. I presume in your case that will be 'recover database;'. It then will pop up with a prompt for the first archive. You then just type the one word 'auto' at that prompt, and (provided all 800 archives are still available where Oracle thinks it put them), the job will complete on its own. Follow that up with 'alter database open', and the job's done.

You can also issue the 'recover automatic database' command, which saves you from having to type the word 'auto' at the first prompt (though it's 5 extra key stokes!).

At the 'books' link on my site, there's a backup and recovery document you may find useful for all sorts of recovery scenarios.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Night Shade Books" <jasonw_at_nightshadebooks.com> wrote in message
news:B0D1A1C21BAAEC7E.BD12F7BB388255DC.4EAA8B54226781A6_at_lp.airnews.net...


> 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

>

>