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
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
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
-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
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
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
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
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
, 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
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
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
11 matches
Mail list logo