Re: Database recovery
Date: Thu, 16 Jul 1998 15:18:11 GMT
Message-ID: <35ae1841.273109555_at_news.senate.gov>
You can restore your entire database from a cold backup set of files and then apply the archived log files.
- Restore files from cold backup
- Startup mount the database
- issue: recover database using backup controlfile This will bypass the current control file since it will indicate - no recovery is needed
- After you have applied all your archived logs you can alter database open resetlogs.
- TAKE TIME TO DO A FULL COLD BACKUP NOW RIGHT AFTER YOU'VE FINISHED APPLYING YOUR LOGS.
On Wed, 15 Jul 1998 08:38:47 +0100, "MotoX" <rat_at_tat.a-tat.com> wrote:
>You might want to try the '.server' newsgroup for a start! :-)
>
>If it's a cold backup, then just restore it and restart it. NB. this will
>put you're ENTIRE DB back to where it was when you backed it up. If you just
>want to recover your current db, pull of the bit's you lost and recover it
>with the archive logs. Oracle will jump into recovery mode it it sees a data
>file is out of sync and needs recovery.
>
>MotoX.
>
>Norhayati Hassalli wrote in message <35AC25E9.4248BD88_at_mimos.my>...
>>How to I recover database fom the cold backup and the archive log ?
>>
>>Thank you
>>
>
>
Received on Thu Jul 16 1998 - 17:18:11 CEST