Re: some datafiles need recovery -noarchivelog -nobackup
From: Bjoern Rost <b.rost_at_portrix.net>
Date: Fri, 07 Nov 2008 12:25:17 +0100
Message-Id: <1226057117.8017.29.camel@hermes>
Date: Fri, 07 Nov 2008 12:25:17 +0100
Message-Id: <1226057117.8017.29.camel@hermes>
Hi
> may be the case has been discussed here, but I need to refresh or if
> someone has extreme solution?
> I have 8 datafiles need media recovery, backup was taken per day with
> cold backup (NOARCHIVELOG mode).
>
> is there any extreme approach to bring those datafiles online?
I don't know if this is extreme, but maybe transportable ts can help? Restore a backup (to before the corruption), start that db, export the tablespace that got corrupted and import it back again into your current database.
Bjoern
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 07 2008 - 05:25:17 CST