hi, thanks for the clue, but this is oracle application which may need special export-import... On Fri, Nov 7, 2008 at 7:06 PM, Bort, Guillermo <guillermo.bort@xxxxxxx> wrote: > 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 > > > -- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com -- //www.freelists.org/webpage/oracle-l