Re: PLEASE HELP URGENT RECOVERY

Trond Enstad wrote:

> This is the situation:
>
> I have my control files from tuesday night.
> I have my redo log files from tuesday night.
> I have most og my datafiles from tuesday night.
> I have some datafiles which are newer. (These were not on my backup device
> unfortunately)
>
> I'm running in NONARCHIVELOG MODE

  You can go back to the time of tuesday night.  

  Assume that there is no any structural changes on the database (that is there has been no any changes involved in datafiles, control files since tuesday night).

  Before doing recovery, please backup *current* redo log files, control files, initialization parameter files and datafiles in a safe location.

  Copy the older version of previous files into the corresponding location if ALL are ready. Do not use the newer datafiles to overwrite the backup at Tuesday night to ensure the database is synchronized at a single point of time. If you have missed some datafiles. It is no hope. However, if you missed some datafiles at Tuesday but have the newer one. You can try to use these copies.

  Then, you can startup and mount the database but not open it.

  Issue ALTER DATABASE OPEN RESETLOGS to reset the SCN.

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