DATABASE RECOVERY !!!! HELP!!! DBA s

From: Shankar Ramanathan <srnathan_at_amoco.com>
Date: 1996/06/04
Message-ID: <31B4D38E.2CBC_at_amoco.com>#1/1


I have a situation which is really frustrating.. I have a cold backup taken on a weekend, all the datafiles, control files copied. (Redo logs were not).

When I restored the datafiles and the control file it says control file older than the data file.. (this is a cold backup and nothing happened around that period.

  1. I have in NOARCHILOG mode.
  2. I shutdown the database and then copied all the data files and the control files.
  3. I lost 1 disk , i tried restoring only that, but that did not work.
  4. I restored the entire database including the control file. now it says control file is older.

is there a way out?

Can I not recreate the control file and reset the logs..

I have the backup yet it is not good enough...

DO we need to backup redo logs also even for a cold backup?

please e-mail me personally since i will be working on this problem all night , i may not get into the usenet ... i promise to post it to the news groups whatever inteligent solution i get.. thanks in advance...

Shankar RamaNathan. Received on Tue Jun 04 1996 - 00:00:00 CEST

Original text of this message