Re: RAC - NOARCHIVELOG to ARCHIVELOG migration
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: Andrey.Kriushin@xxxxxxxx
- Date: Wed, 26 Apr 2006 21:47:20 +0200
May I ask why should CLUSTER_DATABASE set to FALSE?
On 4/25/06, Andrey Kriushin <Andrey.Kriushin@xxxxxxxx> wrote:
>
> Hi,
>
> Steps:
> 0. ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
> 1. Shutdown all instances cleanly (normal, immediate, transactional)
> 2. "Startup mount" one instance
> 3. ALTER DATABASE ARCHIVELOG;
> 4. ALTER DATABASE OPEN;
> 5. ALTER SYSTEM SET CLUSTER_DATABASE=TRUE;
> 6. SHUTDOWN IMMEDIATE
> 7. Startup all the instances. Do not forget to set log_archive_dest_n
> for all instances. Otherwise you'll find archived logs in $ORACLE_HOME/dbs
> NOTE: do not forget to specify %t or %T in log_archive_format. That
> would help to distinguish logs from different instances.
>
> HTH
> Andrey
>
> ________________________________________________________________________
> Andrey KRIUSHIN (Oracle9i Certified Master), Oracle products expert
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Postal: RDTEX JSC, #6, Zavodskoy proezd, 142281, Protvino, Russia
> E-mail: Andrey.Kriushin@xxxxxxxx
> WWW: http://www.rdtex.ru
> Phone: +7(4967)744581,740876 (internal: 135), code (27) from Moscow
> Fax: +7(4967)740754
>
> vikram singh wrote:
> > 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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
