Re: some datafiles need recovery -noarchivelog -nobackup

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_at_eds.com> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
thanks and regards
ujang | oracle dba
jakarta | http://ora62.wordpress.com
--
http://www.freelists.org/webpage/oracle-l