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