recreating control file in RAC with noresetlogs

From: Prat <prat.kp_at_gmail.com>
Date: Sat, 04 Aug 2007 22:26:08 -0700
Message-ID: <1186291568.786313.80590@i38g2000prf.googlegroups.com>

Hi all,

I need to recreate the controlfile in a 2-node RAC environment (9i) for altering the MAXLOGHISTORY value. I will be using noresetlogs as I have all the online logs avaliable with me.

I refered to metalink note (Note:118931.1) for the same, and to clarify the same, it referes to set cluster_database to false and then to true after creating the new controlfile.

Log Groups 1,2,5,6,7 belongs to instance1 and the rest belongs to instance2

create controlfile reuse database "prod" noresetlogs force logging archivelog

    maxlogfiles 64
    maxlogmembers 3
    maxdatafiles 800
    maxinstances 32
    maxloghistory 15000
logfile

  group 1 '/dev/rprod_redo11'  size 100m,
  group 2 '/dev/rprod_redo12'  size 100m,
  group 3 '/dev/rprod_redo21'  size 100m,
  group 4 '/dev/rprod_redo22'  size 100m,
  group 5 '/dev/rprod_redo13'  size 100m,
  group 6 '/dev/rprod_redo14'  size 100m,
  group 7 '/dev/rprod_redo15'  size 100m,
  group 8 '/dev/rprod_redo23'  size 100m,
  group 9 '/dev/rprod_redo24'  size 100m,

  group 10 '/dev/rprod_redo25' size 100m -- standby logfile
datafile
.
.

Please clarify on the same.

Thanks!
Prat Received on Sun Aug 05 2007 - 00:26:08 CDT