-Original Message-
From: Daniel Fink [mailto:[EMAIL PROTECTED]
Sent: Mon 11/3/2003 8:09 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Re: Redo log corruption
Shibu,
I'd go ahead and check your
-
From: Daniel W. FInk [mailto:[EMAIL PROTECTED]
Sent: Fri 10/31/2003 10:09 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Re: Redo log corruption
Shibu,
What version of Oracle? There is a 7.x bug where mismatches in asynch
Solar flares.
On 10/31/2003 10:24:31 AM, Shibu MB wrote:
Hi all ,
While applying archive logs to my standby database i got theerror
ORA-00353: log corruption near block 207725 change 111482169731153 time
10/25/2003 12:14:01
Can anybody tell me how archive logs can get corrupted
They get corrupted like any other OS files (hardware and/or OS
problems).
Have the second destination for archive logs.
This way, if one gets corrupted, the second one could be used.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Shibu MB
Sent: Friday, October 31, 2003 10:25
Shibu,
What version of Oracle? There is a 7.x bug where mismatches in asynch i/o read/write
corrupted the logs. I don't recall if I encountered it in 8i as well, but there is
something in the back of my mind saying it may still exist in later releases.
Daniel Fink
Shibu MB wrote:
Hi all ,
Shibu,
How can i check the "health" of archive logs ??
apply them to a standby database. daily. grep the alert logs for errors.
If you have 2 servers with adequate storage space, have standby databases for each database on the other server. use one set of scripts, all using environment
3 Options
1) Apply to a standby
2) Use for a test recovery
3) Issue the undocumented command "alter system dump logfile 'logfile_name';"
for each archive log generated.
Daniel
Paul Drake wrote:
Shibu,> How can i check the "health" of archive
logs ??apply them to a standby database. daily. grep
[mailto:[EMAIL PROTECTED]
Sent: Fri 10/31/2003 10:09 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Re: Redo log corruption
Shibu,
What version of Oracle? There is a 7.x bug where mismatches in asynch
i/o read/write
I have redo log sized to 800MB in a one of our databases. I am considering to double
its size, as
the application generates too much redo, due to bad application code. Even for one
column change,
the rest of the row gets updated with the same values.
I have heard of no issues with large redo
recipients of list ORACLE-L [EMAIL PROTECTED]
|
| cc:
|
| Subject: Re: Redo Log (Largest size used
]
|
| cc:
|
| Subject: Re: Redo Log (Largest size used
Title: redo log maintenance
Thought so. Thanks Mladen.
-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 5:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
redo log maintenance
Doco
is plain wrong. I've been adding
Title: redo log maintenance
Doco
is plain wrong. I've been adding, dropping and switching logfiles ever since the
version 6 and
I have
never needed to shut down the database for it.
Mladen Gogala Oracle DBA Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-From:
Lisa,
I do not have the pleasure of migrating to 9.2 yet, In a few months
maybe on my play box. Could it be that the docs are refering to the AUTO
UNDO function that is availabe in 9i?
I, like you have offlined, dropped and rebuilt redo logs on the fly
without any problems.
Ron
[EMAIL
the DB is open doing so while the DB is quite
is the best time.
Dick GouletSenior Oracle DBAOracle Certified 8i DBA
-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 5:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
redo log
, 2003 12:49
AM
Subject: RE: redo log maintenance
Lets
just say that the docs are erroring on the safe side. The reason is that
if you try to do any of these tasks with the database open you could be
affecting (negatively) an active log file. While I agree with both of
you
-Original Message-
We hope by
eliminating redo log multiplex, but with OS mirroring we
can speed up this loading process.
--
We deal with this by:
1. Hardware mirroring of archives.
2. Archives go to device on which no other I/O is present and,
Hello Guang
From your note about weekly one day long import I think that you are dealing
with DW.
1) Am I correct?
2) Are there other updates to the database while the import is in progress?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Now for those who are into this worst scenario thing let me ask you: What
if I put your storage array between a 30HP air conditioning blower moter and
a spot welder, and run a couple of paint shakers on top of the array to
boot. What will your vaunted Oracle multiplexing do for you then? Huh?
Amen to that!
Stephen,
It seems like you keep this discussion on just for the sake of discussion.
And also, it seems like you live in some kind of ideal world, where
hardware and software is 100% error-free and is 100% bullet-proof and
fool-proof, and SAs, DBAs, developers, etc... never make a
-Original Message-
We do redo log file multiplexing to protect against fat
fingers and other odd-ball stuff that have caused problems
for an entire file system. Call it an unreliable OS, poor SA
(ok, maybe even DBA) practices
I do it because it's a CYA thing of doing it by the
PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Stephen Lee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 5:26 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: redo log file setup with mirrored drives
-Original
-Original Message-
have you NEVER accidentally, at 3AM, after having been woken from a
sound sleep to a crisis that needs to be fixed RIGHT NOW,
made a typo?
Actually no. But we usually script our actions and test the scripts prior
to doing anything in production. As a sys
Hi:
I am the original poster and thanks for all your inputs on this topic. Now I
know more about what might happen if something goes wrong. The main
purpose of we thinking doing this was to gain some performance. We have a
weekly schema imp process which takes about a day to finish. We hope by
I was amazed at the non-security that seems to be rampant out there,
with mischievous people running around deleting files. I kept
reading
about it and thinking you've got to be kidding.
Steven,
have you NEVER accidentally, at 3AM, after having been woken from a
sound sleep to a crisis that
PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 9:54 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: redo log file setup with mirrored drives
[snip
-Original Message-
Sorry if you took offense at some attempted humor.
--
No offense taken here. I've always worked in large environments where there
were multiple DBA's, sys admins, developers, and testers. One cannot be
easily offended and
I script and test as well. But sometimes you can't think of every
possible problem.
My point wasn't to have a contest of who had worse problems or who had
a problem that the other didn't.
merely that sometimes hardware mirroring is not the be-all/end-all
solution.
We all could swap war stories
If I may offer another view
-Original Message-
Having multiple redo log members has its advantages. The
archiver process 'knows' these multiple members and it will
optimize the archiving process,
Is there any supporting documentation about this optimizing? Are you
saying
Pending further evidence to the contrary, I'll take mirroring external to
Oracle as the better choice.
Redo and archived redo logs are the most important files in the database.
Lose a datafile? You can still recover the database.
Lose all controlfiles? They can be recreated.
Lose a single redo
Addressing the corruption issue, Kirti's statement is not speculation. Because my
OS/hardware IS reliable a corrupted log file that is mirrored outside of Oracle will
be corrupt - the original is corrupt, so is the mirror. If I mirror my log files
using Oracle, logfile A may be corrupt, but
Sure...
What I posted came from my discussions with others and from various resources on
Metalink and from Oracle Training Classes. Note #45042.1 titled Archiver Best
Practices summarizes it all.
Agreed, that RAID and disk technologies have improved over the years, however, I would
still
Also stand by that corrupted write will be restricted to just the affected member
Hence one can simply overwrite the BAD (Corrupted) member with the Good one
-Original Message-
Sent: Tuesday, November 26, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L
Sure...
What I posted
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: redo log file setup with mirrored drives
Pending further evidence to the contrary, I'll take mirroring external to
Oracle as the better choice.
Redo and archived redo
I was going to let the differences of opinion stand, but I suppose this
requires an answer.
-Original Message-
Redo and archived redo logs are the most important files in
the database.
Lose a datafile? You can still recover the database.
Lose all controlfiles? They can be
Stephen,
Nothing is gained by personal attacks in this forum. This forum is
intended to be a learning experience for all (myself included). I suggest
that you review the archived list and examine the quality of posts by Kirti,
Jared, et.al. They speak for themselves.
BTW, 2 + 2
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: redo log file setup with mirrored drives
[snip]
not protect against the accidental deletion of the file. I
have had to deal
with situations where people deleted
On Tue, 2002-11-26 at 10:50, Stephen Lee wrote:
And from another post ...
Because my OS/hardware IS reliable a corrupted
log file that is mirrored outside of Oracle will be corrupt -
the original is corrupt, so is the mirror.
In one sentence you have claimed that your OS/hardware IS
-Original Message-
Stephen,
Nothing is gained by personal attacks in this forum.
Please enlighten me. Exactly what personal attack was made?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network
:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 2:25 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: redo log file setup with mirrored drives
Stephen,
Nothing is gained by personal attacks in this forum.
This forum is
intended to be a learning experience for all (myself
-Original Message-
Of course, you'll need Tom Kyte's binary conversion program
here to execute this very weak proof:
Yeah, well this didn't come from Stephen Hawking. And let's not forget the
part about in the natural integers. Homey didn't take a bunch of 5000 and
6000 level math
While all this is true, this is all based on the forgone conclusion that
mirroring outside Oracle will result in file loss. It is that conclusion
with which I disagree.
I believe the forgone conclusion you are talking about is that mirroring
outside of Oracle MAY result in data loss MAY is a
I agree. And this is why Oracle has the capability to manage many redo log
members in the same group and many copies of the control file. It does not
offer the same for regular data files.
Regards,
Waleed
-Original Message-
Sent: Tuesday, November 26, 2002 6:05 PM
To: Multiple recipients
-Original Message
I believe the forgone conclusion you are talking about is that mirroring
outside of Oracle MAY result in data loss MAY is a very important word.
The multiplexing of redo logs across multiple disks and controllers is a
simple way protect your
I suppose I should come clean on this deal and admit that we do indeed have
Oracle duplex the redo files. The only time we would not do this is if some
user with sufficient bureaucratic power has some suckwad app and was
demanding that everything be done to bump up performance. If it comes to
Having multiple redo log members has its advantages. The archiver process 'knows'
these multiple members and it will optimize the archiving process, but it does not
know about the mirrored copies of these logs. The other important thing to know is
that Oracle issues a separate write for these
David,
Based on the ls output it seems you may have 4 groups with 1 member in groups 1,2 4
but 3 members in group 3.
Do a select * from v$log; and see how the logs are really setup.
I would suggest you want to have the same number of members in each group.
If you want them to switch less
Hi,
Thanks for all the replies. I am still unable to archive my redo logs in order to back them up.When startup the database I then enter
archive log list;
Itshows archiving information for the coonected instance:
Database log modeARCHIVELOG
automatic archival DISABLED
Archive destination
Hi All,
Finally, I have successfully had the automatic archiving turned on. My problem was I modified the wrong parameter file. Thus that caused the automatic archivalDISABLED.
Regards,
Trang
Meomeo Nguyen [EMAIL PROTECTED] wrote:
Hi,
Thanks for all the replies. I am still unable to archive
Been there, done that. Hope it doesn't happen again.
-Original Message-
Sent: Monday, May 13, 2002 5:43 PM
To: Multiple recipients of list ORACLE-L
Hi All,
Finally, I have successfully had the automatic archiving turned on. My
problem was I modified the wrong parameter file.
You probably received an error in your alert log and Oracle disabled archiving. Make
sure yuou have these 3 parameters in your initsid.ora and set accordingly:
log_archive_dest = /oracle/data/arc/sid/
log_archive_format = sid_%s.arc
log_archive_start = true
hth,
Gene
[EMAIL PROTECTED]
Trang: I think that you missed the step of alter database archivelog while
the database is mounted but not open.
Here is the precise steps for you to review:
Modify the init.ora file with log_archive_start = true (you've already done
that)
Shutdown the database.
STARTUP MOUNT
ALTER
Its not the size of the database that counts, it the
amount of changes (that generated redo) that matters.
The general consensus for redo logs is big is
beautiful but of course, other things can alter that
(archiving frequency, population of standby database
etc).
1G would seem a sensible
Hi
I will try to answer you questions :
The size of redo log files is depend on the transaction activity, you have
to monitor the Checkpoint activity and Log Switch activity, the ideal time
for Log file switching can be minimum 15 minutes per Group, the information
you can get from v$loghist.
log parallel write and log file sync are good indications of redo log
problems.
This isn't directly considered contention but more like the disk medium is
too slow to keep up.
redo log space requests generally are log buffer related, meaning the
buffer may be too small.
Walking on water and
That would be one of those RTFM questions, don't you think?
-Original Message-
Sent: Tuesday, April 03, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Why can't you use archiving? It doesn't effect the applications running on
the database in anyway (except space to store the
ORACLE-L
Subject: RE: Redo log size MAX = ?
hi
forget about recovery from online redo logs
It doesn't exist in Oracle
Regards
Tapiwa
-Original Message-
Sent: Tuesday, April 03, 2001 3:01 PM
To: Multiple recipients of list ORACLE-L
Hi,
My database = noarchive mode
So, based on the responses I've seen, this statement can be declared to be false.
[EMAIL PROTECTED] 04/03/01 11:05AM
hi
forget about recovery from online redo logs
It doesn't exist in Oracle
Regards
Tapiwa
-Original Message-
Sent: Tuesday, April 03, 2001 3:01 PM
To: Multiple
Hi Glenn,
Try 'log_file_usage.sql' at
http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
-Original Message-
Sent: Tuesday, 27 March 2001 5:51
To: Multiple recipients of list
See your alertSID.log by using
tail -f alertSID.log
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Mon, 26 Mar 2001 11:51:11 -0800
What can I query to see how much of the redo log file is currently in use?
--
Please see the
?
-Original Message-
From: Steve Adams [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 3:26 PM
To: [EMAIL PROTECTED]
Cc: Oracledba
Subject: RE: Redo Log size used
Hi Glenn,
Try 'log_file_usage.sql' at
http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage.
@ Regards
Ian,
This is one of those where you can get the old "it depends" answer.
What type of database is this? What level of transaction activity do you
have? How big are your redo logs if you switch every 15 min, 20 min, 30 min?
How critical is recovery to the current time to you?
If you don't
62 matches
Mail list logo
