Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> HELP: Oracle data file recovery

HELP: Oracle data file recovery

From: Yi Zhang <yzhang_at_Stanford.EDU>
Date: 2000/01/29
Message-ID: <Pine.GSO.4.05.10001290226290.19687-100000@elaine40.Stanford.EDU>#1/1

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 Received on Sat Jan 29 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US