Re: HELP: Oracle data file recovery

Your only bet is to issue startup nomount and provide a create controlfile statement. This statement should list exactly which datafiles belong to the database. The password file can be recreated with the orapwd utility, this should not be a big deal.

Hth,

--
Sybrand Bakker, Oracle DBA
Yi Zhang <yzhang_at_Stanford.EDU> wrote in message
news:Pine.GSO.4.05.10001290226290.19687-100000_at_elaine40.Stanford.EDU...


>

> Dear All,

>

> I have an Oracle 8i running on Solaris. In an effort to resolve some Net8

> problems, I reinstalled Oracle today. Because my previous installation

> used all default configurations, so before reinstalling I only made a

> backup for the data files, namely, dbf and control files. But I didn't

> backup those configuration files. After a database instance (with the same

> name as my previous one) is created, Oracle just doesn't read my data

> files. If all data and control files are copied to the new data directory,

> the following error is generated at database startup:

> ORA-01991: invalid password file

> '/u01/app/oracle/product/8.1.5/dbs/orapwCME'

>

> If I copy one data file to that directory, will get the following error:

> ORA-01122: database file 4 failed verification check

> ORA-01110: data file 4: '/u03/oradata/CME/temp01.dbf'

> ORA-01206: file is not part of this database - wrong database id

>

> Is there a way to get the original data back into database in my

> situation? The data is very important. Any help is appreciated.

>

> yi

>