Re: Restoring from Cold Backup

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 26 Sep 2001 19:49:47 GMT
Message-ID: <9otbgr$43j$1@netnews.upenn.edu>

Sean Fitzgerald (sfitzgerald_at_centurytel.net) wrote:
: the ORA 1122 means that what is in the control file for the system
: datafile does not match the copy of the system datafile you have.

This turned out to be true, bringing the system back up moved the oracle drive to F: where it used to be d:

: Was your database down when you took the cold backup? Are you sure
: the files are all from the same backup? If your database wasn't down
: when you copied the files, the backup is inconsistent and you won't be
: able to use it.

It was down and the files were the same, but it was trying to find the files on d: and they weren't there. We renamed the drive letters to solve this.

Thanks for your help. Received on Wed Sep 26 2001 - 14:49:47 CDT