Wednesday, June 18, 2008

ASM DB Admin -- 1

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+PQSI/orcl/datafile/system.256.656811933
+PQSI/orcl/datafile/undotbs1.258.656811935
+PQSI/orcl/datafile/sysaux.257.656811935
+PQSI/orcl/datafile/users.259.656811935
+PQSI/orcl/datafile/undotbs2.264.656812055
+PQSI/orcl/datafile/undotbs3.265.656812055
+PQSI/orcl/datafile/undotbs4.266.656812057

7 rows selected.

SQL> create bigfile tablespace soeindex
datafile '+PQSI/orcl/datafile/soeindex_OLTP.dbf'
size 5000M reuse
autoextend on next 50m maxsize unlimited
extent management local uniform size 100k
segment space management auto
nologging;  2    3    4    5    6    7

Tablespace created.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+PQSI/orcl/datafile/system.256.656811933
+PQSI/orcl/datafile/undotbs1.258.656811935
+PQSI/orcl/datafile/sysaux.257.656811935
+PQSI/orcl/datafile/users.259.656811935
+PQSI/orcl/datafile/undotbs2.264.656812055
+PQSI/orcl/datafile/undotbs3.265.656812055
+PQSI/orcl/datafile/undotbs4.266.656812057
+PQSI/orcl/datafile/soeindex_oltp.dbf

8 rows selected.

SQL> create bigfile tablespace soedata
datafile '+PQSI/orcl/datafile/soedata_OLTP.dbf'
size 5000M reuse
autoextend on next 50m maxsize unlimited
extent management local uniform size 100k
segment space management auto
nologging;
  2    3    4    5    6    7

Tablespace created.

SQL> SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+PQSI/orcl/datafile/system.256.656811933
+PQSI/orcl/datafile/undotbs1.258.656811935
+PQSI/orcl/datafile/sysaux.257.656811935
+PQSI/orcl/datafile/users.259.656811935
+PQSI/orcl/datafile/undotbs2.264.656812055
+PQSI/orcl/datafile/undotbs3.265.656812055
+PQSI/orcl/datafile/undotbs4.266.656812057
+PQSI/orcl/datafile/soeindex_oltp.dbf
+PQSI/orcl/datafile/soedata_oltp.dbf

9 rows selected.

SQL> ALTER TABLESPACE system
ADD DATAFILE '+PQSI/orcl/datafile/system_addl1.dbf' SIZE 2000M
AUTOEXTEND ON
NEXT 100K;  2    3    4

Tablespace altered.

SQL> ALTER TABLESPACE system
ADD DATAFILE '+PQSI/orcl/datafile/system_addl2.dbf' SIZE 2000M
AUTOEXTEND ON
NEXT 100K;  2    3    4

Tablespace altered.

SQL> ALTER TABLESPACE sysaux
  2  ADD DATAFILE '+PQSI/orcl/datafile/sysaux_addl_1.dbf' size 2000m
AUTOEXTEND ON
NEXT 100K;  3    4

Tablespace altered.

SQL> ALTER TABLESPACE sysaux
ADD DATAFILE '+PQSI/orcl/datafile/sysaux_addl_2.dbf' size 2000m
AUTOEXTEND ON
NEXT 100K;
  2    3    4

Tablespace altered.

SQL> SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+PQSI/orcl/datafile/system.256.656811933
+PQSI/orcl/datafile/undotbs1.258.656811935
+PQSI/orcl/datafile/sysaux.257.656811935
+PQSI/orcl/datafile/users.259.656811935
+PQSI/orcl/datafile/undotbs2.264.656812055
+PQSI/orcl/datafile/undotbs3.265.656812055
+PQSI/orcl/datafile/undotbs4.266.656812057
+PQSI/orcl/datafile/soeindex_oltp.dbf
+PQSI/orcl/datafile/soedata_oltp.dbf
+PQSI/orcl/datafile/system_addl1.dbf
+PQSI/orcl/datafile/system_addl2.dbf

NAME
--------------------------------------------------------------------------------
+PQSI/orcl/datafile/sysaux_addl_1.dbf
+PQSI/orcl/datafile/sysaux_addl_2.dbf

13 rows selected.

No comments:

Post a Comment