Re: HELP!!!! Oracle Version 6 Database Crash (NOARCHIVELOG)

Nicolás Bernard wrote:

> -System crash, all information on disk damaged.
> -One Backup of all the database files (control files, datafiles, etc.)
> except log files (NOARCHIVELOG) and one Datafile.
> -Another Backup only with the datafile that is not present in previous
> backup. (database down)
> -The time between two backups is one day, WITH NO DATA ACTIVITY BETWEEN
> THEM.
>
> With that situation, after restoring the two backups, after a startup,
> Oracle mounts the database put can´t open it. The error message
> is ORA-01122 Verification check error on <The datafile of the second
> backup>.

  You cannot restore it because there is a datafile that was not backup at the same time as the other (not in single-point-of-time). As a result, there is a consistent problem.  

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841