Again - in situations where incomplete recovery is necessary but is not
possible (due to lack of decent backup)
try setting the parameter of the last hope :
- shutdown abort your database
- open your parameter file
- add _allow_resetlogs_corruption = true
- save your parameter file
- startup mount
- recover database until cancel ;
- cancel
- alter database open resetlogs
- pray the DB opens
- if it opens - export the DB, drop the DB, create the DB, import the DB
- taken a decent backup
"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 - 14:33:03 CDT
