Re: Help ORA-1113 datafile needs media recovey

In article <948986289.7931.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote:
> Without archivelog the only thing you can do is restore the
> backup, alter
> open resetlogs
> and loose everything that happened after backup.
> All the options you describe would have been available if you
> would have ran
> in archivelog.
> Sorry,
> --
> Sybrand Bakker, Oracle DBA
> Peter Laursen < ptl_at_edbgruppen.dk> wrote in message
> news:01bf68d3$c3d3a980$2c289a0a_at_apollo...

If you are not in archivelog mode, the entire database must be restored from the backup, including the control files and the redo log files. Then just startup the database. You do not need to resetlogs because you haven't done a point in time recovery -- you have done a full complete recovery.

Just a clarification.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!