You can recreate and recover a database file if and only if you have all the
redo logs since the creation of that file.This is documented on Howard
Rogers site www.hjrdba.com
Unfortunately, for the system tablespace in many cases this is unlikely as
the database is not in archive log mode at the moment of database creation,
and typically a lot of redo is generated even before putting the database in
archive log mode.If you have no backup and don't have all the redo then the
answer I'm afraid is no.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote in message
news:a8uka0$2c7$1_at_news.tpi.pl...
> I've migrate my database (9i) from linux to tru64 last week. In tru64 my
> database have changed tablespaces, f.exampl: added datafile to tablespaces
> or some tables were moved to to new tablespaces.
> Unfortunantly today file system01.dbf (fram tablespace system) has been
> coruppted. Now I have no backup since last week. Now my is working my old
> database (on linux) but I have no datas from last week.
> Can I recover it?
> Can I fix system01.dbf with no backup?
>
> SM
>
>
>
Received on Tue Apr 09 2002 - 08:14:46 CDT
