SQL> create tablespace app_data datafile '+DATA/cbsrun/app_data01.dbf' size 8g
2 extent management local uniform size 1m
3 segment space management auto;
Tablespace created.
SQL> alter tablespace app_data add datafile '+DATA/cbsrun/app_data02.dbf' size 8g;
Tablespace altered.
SQL> create tablespace indx datafile '+DATA/cbsrun/indx01.dbf' size 8g
2 extent management local uniform size 1m
3 segment space management auto;
Tablespace created.
SQL> alter database datafile '+DATA/cbsrun/app_data01.dbf' autoextend on next 100m maxsize 16g;
Database altered.
SQL> alter database datafile '+DATA/cbsrun/app_data02.dbf' autoextend on next 100m maxsize 16g;
Database altered.
SQL> alter database datafile '+DATA/cbsrun/indx01.dbf' autoextend on next 100m maxsize 16g;
Database altered.
SQL> alter system set undo_retention=86400 scope=both;
System altered
SQL> alter tablespace undotbs1 retention guarantee;
Tablespace altered.
SQL> alter tablespace undotbs2 retention guarantee;
Tablespace altered.
SQL> alter database datafile '+DATA/cbsrun/undotbs02.dbf' autoextend on next 10m;
Database altered.
SQL> alter database datafile '+DATA/cbsrun/undotbs01.dbf' autoextend on next 10m;
Database altered
SQL> alter system set memory_target=30g scope=spfile;
System altered.
SQL> alter system set sga_max_size=25g scope=spfile;
System altered.
SQL> alter system set sga_target=25g scope=spfile;
System altered.
SQL> alter system set shared_pool_size=5g scope=spfile;
System altered.
SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited;
Profile altered.
SQL> alter database add logfile '+DATA/cbsrun/redo11.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo12.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo13.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo14.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo15.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo16.log' size 500m;
Database altered.
NODE2:
SQL> alter database add logfile '+DATA/cbsrun/redo21.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo22.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo23.log' size 500m;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> alter system checkpoint;
System altered.
SQL> alter database drop logfile group 4;
Database altered.
SQL> alter database drop logfile group 5;
Database altered.
SQL> alter database drop logfile group 6;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo24.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo25.log' size 500m;
Database altered.
SQL> alter database add logfile '+DATA/cbsrun/redo26.log' size 500m;
Database altered.
alter sequence CBSRUN.IBPS_AUTH_SEQUENCE cache 1000;
alter sequence CBSRUN.IBPS_COMM_SEQUENCE cache 1000;
alter sequence CBSRUN.IBPS_MSG_SEQUENCE cache 1000;
alter sequence CBSRUN.IBPS_PKG_SEQUENCE cache 1000;
alter sequence CBSRUN.IBPS_PROTOCOL_SEQUENCE cache 1000;
alter sequence CBSRUN.NBTC_MSG_SEQUENCE cache 1000;
alter sequence CBSRUN.SETNUMBER1X cache 1000;
alter sequence CBSRUN.SETNUMBER2X cache 1000;
alter sequence CBSRUN.SHTCMSGSEQNO cache 1000;
alter sequence CBSRUN.SHTCPKGSEQNO cache 1000;
alter sequence CBSRUN.SHTCRCVSEQNO cache 1000;
alter sequence CBSRUN.SHTCSNDSEQNO cache 1000;
alter sequence CBSRUN.SMSMAXID cache 1000;