CREATE UNDO TABLESPACE UNDOTBS3
DATAFILE '+DG_PRD1N_DATA' SIZE 2048M
EXTENT MANAGEMENT LOCAL
/
 
CREATE UNDO TABLESPACE UNDOTBS4
DATAFILE '+DG_PRD1N_DATA' SIZE 2048M
EXTENT MANAGEMENT LOCAL
/

ALTER DATABASE DATAFILE '+DG_PRD1N_DATA/prd1n/datafile/undotbs1.267.723831121'AUTOEXTEND ON NEXT 128M MAXSIZE 4G;
ALTER DATABASE DATAFILE '+DG_PRD1N_DATA/prd1n/datafile/undotbs2.258.723831133'AUTOEXTEND ON NEXT 128M MAXSIZE 4G;
ALTER DATABASE DATAFILE '+DG_PRD1N_DATA/prd1n/datafile/undotbs3.273.724256891'AUTOEXTEND ON NEXT 128M MAXSIZE 4G;
ALTER DATABASE DATAFILE '+DG_PRD1N_DATA/prd1n/datafile/undotbs4.264.724256967'AUTOEXTEND ON NEXT 128M MAXSIZE 4G;

ALTER DATABASE DATAFILE '+DG_PRD1N_DATA/prd1n/datafile/undotbs1.267.723831121' RESIZE 2G;
ALTER DATABASE DATAFILE '+DG_PRD1N_DATA/prd1n/datafile/undotbs2.258.723831133' RESIZE 2G;

ALTER DATABASE 
ADD LOGFILE  THREAD 3 GROUP 7 ( '+DG_PRD1N_DATA/prd1n/redo07.log' ) SIZE 512M 
/

ALTER DATABASE 
ADD LOGFILE  THREAD 3 GROUP 8 ( '+DG_PRD1N_DATA/prd1n/redo08.log' ) SIZE 512M 
/

ALTER DATABASE 
ADD LOGFILE  THREAD 3 GROUP 9 ( '+DG_PRD1N_DATA/prd1n/redo09.log' ) SIZE 512M 
/
 
ALTER DATABASE 
ADD LOGFILE  THREAD 4 GROUP 10 ( '+DG_PRD1N_DATA/prd1n/redo10.log' ) SIZE 512M REUSE 
/

ALTER DATABASE 
ADD LOGFILE  THREAD 4 GROUP 11 ( '+DG_PRD1N_DATA/prd1n/redo11.log' ) SIZE 512M REUSE
/

ALTER DATABASE 
ADD LOGFILE  THREAD 4 GROUP 12 ( '+DG_PRD1N_DATA/prd1n/redo12.log' ) SIZE 512M REUSE
/

alter system set instance_number=3 sid='prd1n3' scope=spfile
/
alter system set thread=3 sid='prd1n3' scope=spfile
/
alter system set undo_tablespace='UNDOTBS3' sid='prd1n3' scope=spfile
/

alter system set instance_number=4 sid='prd1n4' scope=spfile
/
alter system set thread=4 sid='prd1n4' scope=spfile
/
alter system set undo_tablespace='UNDOTBS4' sid='prd1n4' scope=spfile
/