| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery excitement ...
hmm. okay. Oracle's advice sounds wrong, but maybe they have details I don't
have.
Did you possibly restore on-line logs from your tapes? Now at first blush it would not make sense that they are of a higher sequence number, but if you had an intervening open resetlogs that could be the case.
If you've overwritten your REAL online logs, then you'll be losing the changes in them and will have to resort to reset logs.
If those higher numbered logs really are older despite the higher numbers for sequence (due to the intervening hypothetical reset), then bad things could happen if you figure out a way to get them to apply.
Of course you made a copy of your online logs immediately before you began the restore/recovery process, so you can just put those back in place and try again, right? After all, backing up the online logs is the first step of any recovery, because that is the thing you can't get them from anywhere on your backups.
Regards,
mwf
-----Original Message-----
From: Spears, Brian [mailto:BSpears_at_Limitedbrands.com]
Sent: Wednesday, November 24, 2004 2:34 PM
To: Mark W. Farnham
Subject: RE: Recovery excitement ...
No funny..its not backup controlfiles...
Oracle is telling me just to recreate controlfiles from trace files and the sequence should be in sync.
Brian
-----Original Message-----
From: Mark W. Farnham [mailto:mwf_at_rsiz.com]
Sent: Wednesday, November 24, 2004 12:42 PM
To: Spears, Brian
Subject: RE: Recovery excitement ...
expected lower than actual usually means you're doing a recovery with a backup controlfile.
Did you tell the database you were using a backup controlfile?
Probably you can cancel recovery and start it again with the correct command.
If you're doing a complete recovery you should *NOT* need to reset.
Good luck
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Spears, Brian
Sent: Wednesday, November 24, 2004 12:30 PM
To: oracle-l_at_freelists.org
Subject: Recovery excitement ...
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 bytesDatabase 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 - 15:04:31 CST
 |
 |