Recovery excitement ...

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Wed, 24 Nov 2004 12:30:22 -0500
Message-ID: <7B51890723365F4591B1B2319985D012BE919F@EXCHSERV2.Limited.brands.com>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen
Sent: Wednesday, November 24, 2004 11:56 AM To: 'shrekdba_at_gmail.com'; reginald.w.bailey_at_jpmorgan.com Cc: meenakshi.aggarwal_at_fishersci.com; oracle-l_at_freelists.org 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_at_SVetsa-IT /cygdrive/c/tmp

--
Mladen Gogala
Ext. 121

-----Original Message-----
From: Shrek [mailto:shrekdba_at_gmail.com] 
Sent: Wednesday, November 24, 2004 11:49 AM
To: reginald.w.bailey_at_jpmorgan.com
Cc: meenakshi.aggarwal_at_fishersci.com; oracle-l_at_freelists.org
Subject: Re: silly vi question

On Wed, 24 Nov 2004 10:33:11 -0600, reginald.w.bailey_at_jpmorgan.com
<reginald.w.bailey_at_jpmorgan.com> wrote:


> Content-type: text/plain; charset=US-ASCII

> Content-transfer-encoding: quoted-printable

> 

> 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.

-- 
--
Bill "Shrek" Thater     ORACLE DBA     
       shrekdba_at_gmail.com 
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 24 2004 - 11:26:23 CST