RE: RAC - NOARCHIVELOG to ARCHIVELOG migration
- From: "ramick" <ramick@xxxxxxxxxxx>
- To: "'Kevin Lidh'" <kevin.lidh@xxxxxxxxx>
- Date: Wed, 26 Apr 2006 12:14:13 -0700
Interesting - how is only one of the physical nodes responsible for the I/O
to the archive log destination?
What platform?
The earlier point I was trying to make is - unless I'm missing something:
If you are using RMAN to manage archived redo files in a RAC environment
(like "delete input"), it wants all archived redo log files accessible from
the node which started the command (9205). This means all the targets for
archived redo must be on shared storage - not local storage.
I missed this when I first set up RAC and started using RMAN (never used
RMAN with OPS).
_____
From: Kevin Lidh [mailto:kevin.lidh@xxxxxxxxx]
Sent: Wednesday, April 26, 2006 11:50 AM
To: ramick@xxxxxxxxxxx
Cc: Andrey.Kriushin@xxxxxxxx; vikramsingh120@xxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: RAC - NOARCHIVELOG to ARCHIVELOG migration
We had an issue with our three-node RAC batch environment. Even at 5 GB
redo we were switching about every 15-20 minutes. Since only one of the
physical nodes was responsible for the I/O to the archive log destination,
it would be overwhelmed by requests to write the large archive logs.
Eventually, two of our three instances would shutdown (I think it was 3 or 5
attempts to get their archive logs written before they panicked and shut
down). So we wound up creating three disks for archive logs and had each
node be responsible for the archive log I/O for that node's instances. This
meant that each instance had it's own log_archive_dest.
Kevin Lidh
On 4/25/06, ramick <ramick@xxxxxxxxxxx> wrote:
Also, set your log_archive_dest_n to location(s) where RMAN will be able to
find the archived redo if using RMAN to manage these files.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Andrey Kriushin
Sent: Tuesday, April 25, 2006 1:54 PM
To: vikramsingh120@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: RAC - NOARCHIVELOG to ARCHIVELOG migration
And OF COURSE do not forget to backup your database after switching to
ARCHIVELOG mode.
- Andrey
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
