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

Home -> Community -> Usenet -> c.d.o.misc -> Help recover from crash

Help recover from crash

From: Clark Murray <clark_at_interaccess.com>
Date: 1998/02/08
Message-ID: <6bkfc4$j61$1@nntp3.interaccess.com>#1/1

Our data warehouse crashed on Friday and I'm trying to figure out what I can do to recover it. We're using Oracle 7 on OS/2. I don't think we were running in archivelog mode. The way we've been backing up the warehouse has been to merely backup the datafiles and the oracle directory to tape while the database is still up. I restored these files from tape but can't get the database to come up. Here are the errors:

SQL*DBA: Release 7.1.4.3.0 - Production on Sat Feb 7 14:04:29 1998

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

Oracle7 Workgroup Server Release 7.1.4.3.0 - Production Release PL/SQL Release 2.1.4.3.0 - Production

Connected.
ORACLE instance started.
Database mounted.

ORA-01122: database file 5 failed verification check
ORA-01110: data file 5: 'd:\oradata\big_rb.dat'
ORA-01207: file is more recent than control file - old control file
Attempting to dismount database........Database dismounted. Attempting to shutdown instance........ORACLE instance shut down. SQL*DBA complete.

Can someone please help me get started on reviving this database? Received on Sun Feb 08 1998 - 00:00:00 CST

Original text of this message

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