RE: some datafiles need recovery -noarchivelog -nobackup

  • From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
  • To: <b.rost@xxxxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 7 Nov 2008 06:06:18 -0600

Opening the database allowing resetlogs corruption *might* bring them
online. Mind you, this database will lose most of oracle's safeties
against corruption, so exporting and importing objects to a new database
should be the first and only thing you do when you open the database. If
backups were taken cold (using begin/end backup or shutting down the
database), you should have no problem opening a database with those
datafiles, unless SCN has changed for others. 

Guillermo Alan Bort
DBA / DBA Main Team

EDS, an HP company

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bjoern Rost
Sent: Friday, November 07, 2008 9:25 AM
To: Oracle Discussion List
Subject: Re: some datafiles need recovery -noarchivelog -nobackup

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

--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: