RE: RAC - NOARCHIVELOG to ARCHIVELOG migration

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 25 Apr 2006 20:58:12 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0BF940A0@ENYC11P32005.corpny.csfb.com>

On non-RAC, you would shut down the database, startup mount, then  

alter database archivelog;
alter database open;  

I don't know whether there are special considerations for RAC.  

You also want to make sure that log_archive_start = TRUE in your initialization parameter file.  

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of vikram singh Sent: Tuesday, April 25, 2006 3:49 PM
To: oracle-l_at_freelists.org
Subject: RAC - NOARCHIVELOG to ARCHIVELOG migration

Hi all,

     I am currently on a RAC database with NOARCHIVELOG option. I want to make the database to ARCHIVELOG mode. Please instruct me as to how to proceed. Any advice is welcome. Thanks in advance.

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

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

Received on Tue Apr 25 2006 - 14:58:12 CDT