Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newspeer1.nwr.nac.net!news.maxwell.syr.edu!postnews2.google.com!not-for-mail
From: wy@fudan.edu (wy)
Newsgroups: comp.databases.oracle.server
Subject: Recover when Online Redo Log lost.
Date: 8 Aug 2004 20:49:20 -0700
Organization: http://groups.google.com
Lines: 21
Message-ID: <e8d0244c.0408081949.4a68ea5@posting.google.com>
NNTP-Posting-Host: 61.170.245.166
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1092023361 22639 127.0.0.1 (9 Aug 2004 03:49:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 9 Aug 2004 03:49:21 +0000 (UTC)
Xref: core-easynews comp.databases.oracle.server:227839
X-Received-Date: Sun, 08 Aug 2004 20:48:18 MST (news.easynews.com)

Hi,all.

  How do I recover the db while all the online redo log files were
lost.
  
  The database is running in archive mode and all the archived redo
log files were saved well.
  But since last hot backup,I have done some table inserting with
nologging.
  
  Now the database can not be opened.
  
  Who can tell me how to recover the db to the recent state.
  
  I remember the db was shutdown immediate.
  (Do it make any difference to online redo log file between shutdown
immediate and abort?)


Thanks.
wy.