DATABASE RECOVERY !!!! HELP!!! DBA s
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.
- I have in NOARCHILOG mode.
- I shutdown the database and then copied all the data files and the control files.
- I lost 1 disk , i tried restoring only that, but that did not work.
- 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.