Re: Is there any hope of geting a datafile in RECOVER mode backe?

Thanks for pointing that out. I previously missed the on line where he was missing some archived log files.

Thanks,
Brian

Turkbear wrote:
>
> If he is missing his archive log files, wouldn't that then fail..The redo may be gone by this time..
>
> Brian Peasland <dba_at_remove_spam.peasland.com> wrote:
>
> >Why recover until CANCEL? If all the redo is there, why not apply *full*
> >recovery?
> >
> >Cheers,
> >Brian
> >
> >Turkbear wrote:
> >>
> >> Stan Brown <stanb_at_panix.com> wrote:
> >>
> >> >In <fingnvsddbpvitgepi1onk21fsf8mgmo43_at_4ax.com> Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> writes:
> >> >
> >> >>On Mon, 29 Sep 2003 16:12:05 +0000 (UTC), Stan Brown <stanb_at_panix.com>
> >> >>wrote:
 

> >> >>>Due to a combination of hardware failure, and administrtor incompetence
> >> >>>(that's me folks), I find my self with one datafile the returns the
> >> >>>following, when I query v$datafile:
> >> >>>
> >> >>> 10 RECOVER READ WRITE 108474673 20971520 20971520
> >> >>> /db_local1/oradata/pwhse/tables/config.dbf
> >> >>>
> >> >>>Is there any hope of recovering this?
 

> >> >>If you have your archivelogs available Oracle will allow you to
> >> >>*recover* a *datafile*. You can find the specifics in your
> >> >>documentation.
> >> >
> >> >Sorry that's what comes of switching threads in mid crisis :-(
> >> >Not _all_ of the archivelogs are avaialble, due to hardware failure.
> >> >
> >> >SVRMGR> alter database datafile
> >> >'/db_local1/oradata/pwhse/tables/config.dbf' online ;
> >> >alter database datafile '/db_local1/oradata/pwhse/tables/config.dbf' online
> >> >
> >> >*
> >> >ORA-01113: file 10 needs media recovery
> >> >ORA-01110: data file 10: '/db_local1/oradata/pwhse/tables/config.dbf'
> >> >
> >> >So, given this, is there any hope?
> >>
> >> You can do a 'recover until cancel' and cancel as soon as it asks for an archive log you don't have.
> >> But, your data will be incomplete..
 

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"