Monday, July 25, 2016

sample RAC Conversion steps



select GROUP#,THREAD#, SEQUENCE#, MEMBERS, status from v$log; 

alter system set cluster_database=TRUE scope=spfile; 
alter system set instance_number=1 SID='RAC11' scope=spfile; 
alter system set thread=1 SID='RAC11' scope=spfile; 
alter system set instance_number=2 SID='RAC12' scope=spfile; 
alter system set thread=2 SID='RAC12' scope=spfile; 
alter system set undo_tablespace='UNDOTBS1' SID='RAC11' scope=spfile; set the name same as prod 
alter system set undo_tablespace='UNDOTBS2' SID='RAC12' scope=spfile;
ALTER DATABASE ADD LOGFILE THREAD 2 
GROUP 1 ( 
   '+DATA1_DATA', 
   '+DATA1_DATA', 
   '+DATA1_DATA' 
) SIZE 100M BLOCKSIZE 512 REUSE, 
GROUP 2 ( 
   '+DATA1_DATA', 
   '+DATA1_DATA', 
   '+DATA1_DATA' 
) SIZE 100M BLOCKSIZE 512 REUSE, 
GROUP 5 ( 
   '+DATA1_DATA', 
   '+DATA1_DATA' 
   '+DATA1_DATA' 
) SIZE 100M BLOCKSIZE 512 REUSE; 

ALTER DATABASE ADD LOGFILE THREAD 2 
GROUP 3 ( 
   '+DATA1_DATA', 
   '+DATA1_DATA', 
   '+DATA1_DATA' 
) SIZE 100M BLOCKSIZE 512 REUSE, 
GROUP 4 ( 
   '+DATA1_DATA', 
   '+DATA1_DATA', 
   '+DATA1_DATA' 
) SIZE 100M BLOCKSIZE 512 REUSE, 
GROUP 6 ( 
   '+DATA1_DATA', 
   '+DATA1_DATA', 
   '+DATA1_DATA' 
) SIZE 100M BLOCKSIZE 512 REUSE; 

alter database enable public thread 

select GROUP#,THREAD#, SEQUENCE#, MEMBERS, status from v$log; 

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete