RE: RAC - NOARCHIVELOG to ARCHIVELOG migration

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_at_gmail.com] Sent: Wednesday, April 26, 2006 11:50 AM To: ramick_at_dotster.com
Cc: Andrey.Kriushin_at_rdtex.ru; vikramsingh120_at_gmail.com; oracle-l_at_freelists.org
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_at_dotster.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrey Kriushin
Sent: Tuesday, April 25, 2006 1:54 PM
To: vikramsingh120_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: RAC - NOARCHIVELOG to ARCHIVELOG migration

And OF COURSE do not forget to backup your database after switching to ARCHIVELOG mode.

• Andrey

--

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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 26 2006 - 14:14:13 CDT