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;
This comment has been removed by a blog administrator.
ReplyDelete