SOS: How to recover a database with missing all online redo logs

From: Prabhu, Krishnaswamy <>
Date: Mon, 21 Apr 2008 15:08:31 +0000
Message-ID: <BAY142-W53EA70E6D880338E9BFD2D85E10@phx.gbl>


Inadvertently one of our team member dropped all the online redo logs from all the file systems from one of our 1.5 tera bytes test instance. The instance is running on 9208,64 bit on AIX box. We failed when we tried to do simulate an incomplete recovery "recover database using backup control file until cancel;", and try to open the database using open resetlogs, but the recovery command fails with an error ora-01113. Please help us to recover this instance.  


Video: Get a glimpse of the latest in Cricket, Bollywood, News and Fashion. Only on MSN videos.
Received on Mon Apr 21 2008 - 10:08:31 CDT

Original text of this message