RE: Recovery excitement ...
- From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
- To: "'Hallas, John, Tech Dev '" <John.Hallas@xxxxxxxxxxxxxxxxx>, "'oracle-l-bounce@xxxxxxxxxxxxx '" <oracle-l-bounce@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx '" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2004 22:54:04 -0600
They do, among a number of other things. I'm just not sure which is checked
first internally, the log sequence number or the DBID. My guess is that it's
the log sequence number, but it might well be the DBID. It's been a while
since I've dived into the online redo logs, sounds like a fun project to
take up and see which is the case.
RF
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: Freeman Robert - IL; oracle-l@xxxxxxxxxxxxx
Sent: 11/24/2004 12:12 PM
Subject: RE: Recovery excitement ...
Robert,
Don't the redo logs headers have something in them that recognises DBID
=
or even SID?
Presumably it would check that before moving on to verify the sequence =
number
J
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Freeman Robert - IL
Sent: Wednesday, November 24, 2004 6:06 PM
To: 'Spears, Brian '; 'oracle-l@xxxxxxxxxxxxx '
Subject: RE: Recovery excitement ...=20
What did you do before you shutdown the database? Looks like you are
pointing at the wrong online redo logs. Either you have overwritten them
(but this seems unlikley since the sequence number it is grabbing is
*higher* than the one it is expecting...), or you have moved them but =
not
renamed them in the database, or you renamed them in the database to an
incorrect location.
RF=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: 11/24/2004 11:30 AM
Subject: Recovery excitement ...=20
I tell you ...days before holidays and Fridays are the worst for
having to
do restores.
I have a 600gig windows database :) yes 600GB.. That says..
Database Buffers 1073741824 bytes
Redo Buffers 4104192 bytes
Database mounted.
ORA-00314: log 2 of thread 1, expected sequence# 46671 doesn't match
51245
ORA-00312: online log 2 thread 1:
'G:\ORACLE\LTSPXBR\ORALOGS\REDO02B.LOG'
ORA-00314: log 2 of thread 1, expected sequence# 46671 doesn't match
51245
ORA-00312: online log 2 thread 1:
'F:\ORACLE\LTSPXBR\ORALOGS\REDO02A.LOG'
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- ---
----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 46669 134217728 2 YES INACTIVE
2337739049 05-NOV-04
2 1 46671 134217728 2 NO CURRENT
2337739053 05-NOV-04
3 1 46670 134217728 2 NO INACTIVE
2337739051 05-NOV-04
Any tricks... Out there.. Recover/cancel resetlogs..anybody do that
before?
We just put in our Rman solution... Just in time!
Brian
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Gogala, Mladen
Sent: Wednesday, November 24, 2004 11:56 AM
To: 'shrekdba@xxxxxxxxx'; reginald.w.bailey@xxxxxxxxxxxx
Cc: meenakshi.aggarwal@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: silly vi question
Another version of "vi" for Winduhs can be found at www.cygwin.com.
Install
everything and you'll get vim for Winduhs. It can make your Winduhs look
half way decent. Here are commands that you don't frequently see on a
Winduhs workstation: $ uname -a CYGWIN_NT-5.1 SVetsa-IT
1.5.12(0.116/4/2)
2004-11-10 08:34 i686 unknown unknown Cygwin
$ ls -l /usr/bin/vi
lrwxrwxrwx 1 MGogala Users 7 Nov 24 09:37 /usr/bin/vi ->
vim.exe
MGogala@SVetsa-IT /cygdrive/c/tmp
--
Mladen Gogala
Ext. 121
-----Original Message-----
From: Shrek [mailto:shrekdba@xxxxxxxxx]=20
Sent: Wednesday, November 24, 2004 11:49 AM
To: reginald.w.bailey@xxxxxxxxxxxx
Cc: meenakshi.aggarwal@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: silly vi question
On Wed, 24 Nov 2004 10:33:11 -0600, reginald.w.bailey@xxxxxxxxxxxx
<reginald.w.bailey@xxxxxxxxxxxx> wrote:
> Content-type: text/plain; charset=3DUS-ASCII
> Content-transfer-encoding: quoted-printable
>=20
> Where do you download the WinVI from?
VIM is better.
www.vim.org
has syntax highlighting built in and comes with it already set up.
--=20
--
Bill "Shrek" Thater ORACLE DBA =20
shrekdba@xxxxxxxxx=20
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
