Lost a redo disk

2002-02-20 Thread Seefelt, Beth
Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online

Re: Lost a redo disk

2002-02-20 Thread Stephane Faroult
Seefelt, Beth wrote: Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1

RE: Lost a redo disk

2002-02-20 Thread Arun Chakrapani
Nope u cannot switch when it is in mount mode have u lost all your redlogs -Original Message- Sent: Wednesday, February 20, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Hi everybody, This all started with the halon firing in our data center last night around 10pm so you

RE: Lost a redo disk

2002-02-20 Thread Seefelt, Beth
-Original Message- From: Seefelt, Beth Sent: Wednesday, February 20, 2002 8:28 AM To: '[EMAIL PROTECTED]' Subject: Lost a redo disk Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost

Re: Lost a redo disk

2002-02-20 Thread Bunyamin K. Karadeniz
alter database clear logfile group 1; alter database open; may help you... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 20, 2002 3:28 PM Hi everybody, This all started with the halon firing in our data center last night

Re:RE: Lost a redo disk

2002-02-20 Thread dgoulet
Tom, It would appear that Beth hit the right solution in the end. In the past when I've lost a redo log it was the active one which makes for a much bigger mess. What I believe Beth was running into is that when the database opens it tries to connect with each file that makes up the

RE: Lost a redo disk

2002-02-20 Thread Mercadante, Thomas F
Dick, Couldn't she just Alter database open reset logs - wouldn't this create a new set of redo logs? Beth - you didn't say whether you lost all of your redo logs - please do NOT do the above right away. I've never faced this, and am guessing a bit. Tom Mercadante Oracle Certified

RE: Lost a redo disk

2002-02-20 Thread SARKAR, Samir
Do u have a consistent backup of the database ?? If so, restore the same and issue the command : recover database until cancel; When all the archived logs have been applied, issue the command : alter database open resetlogs; This should create the online redologs. Hope this helps, Samir

Re: Lost a redo disk

2002-02-20 Thread Peter Gram
, 2002 8:28 AM To: '[EMAIL PROTECTED]' Subject: Lost a redo disk Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313

Re:RE: RE: Lost a redo disk

2002-02-20 Thread dgoulet
Tom, If you rebuilt the control file, giving the redo log a new drive to reside thereon, and then issued the alter database open reset logs (which btw is a part of the script created by the alter database backup controlfile to trace command) the missing log would in fact then exist albeit

RE: RE: Lost a redo disk

2002-02-20 Thread Mercadante, Thomas F
Dick, Thanks for the reply. I saw that Beth figured it out on her own. When you said : In her case the first task was to point to a disk drive that's available in the first place. Rebuilding the control file has the same effect, it's just that you can 'rename' the missing log all in one