Re: Restoring from Cold Backup

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 25 Sep 2001 04:32:01 GMT
Message-ID: <9op1c1$o2p$1@netnews.upenn.edu>

Sean,

Thanks for your quick response. We are trying to do as you've instructed below and are currently getting the error messages:

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\DIRTDT\SYSTEM01.DBF'
ORA-01292: wrong incarnation of this file - wrong creation time

We've copied over or manually edited what I think comprise all of the files you mention: admin\TESTDB\initTESTDB.ora, ora81\DATABASE\PWDTESTDB.ora

We copied over the entire oradata folder for the old database including the controls files and datafiles.

Can you help point out anything else?

Maybe we can go about this some other way, but I don't know. We've got the entire folder that contains our Oracle installation. If there were some way to tell Win2k that the software is already installed that seems like an option as well, but I have no idea how to do that.

Thanks again!
Greg

Sean Fitzgerald (sfitzgerald_at_centurytel.net) wrote:
: You can't use the backup files with a "new" database. You must restore all
: the old database files (control files, parameter files and datafiles) and
: recover the old database. These old files contain all the information from
: your original database.
Received on Mon Sep 24 2001 - 23:32:01 CDT