Re: Recovery

Joey wrote:

> Hi,
>
> If a DB is in noarchivelog mode, is restoring the fulldb the only option ?

Another option is to restore the database from a logical backup. If a full database export is available, you can create an empty database and use
the imp utility to restore the dabase from the logical backup.

>
>
> I have a DB which spans across 3 partitions say /d1, /d2, /d3.
> The story goes that the db was shut down.(intented for maintenance of disk)
> Only /d2 was backed up.
>
> Our daily backup cron was accidently overlooked and started the DB after it
> was backed up.
> The sys adm shutdown the db again and began his work on /d2 partition.
> When done he restored the /d2 from the backup.
>
> Naturally, the db cannot start as /d1, /d3 is not longer consistent with /d2
> (the backup version) as
> the db was re-started after the backup.
>
> We are sure the DB has no transactions during the whole maintenance.
> Is there still a way to open the DB without the need to restore the previous
> day backup ?

>
> and will the DB be in a consistent state if it is able to ?

No way.

Received on Thu Dec 02 1999 - 13:25:54 CST