ASM

RESIZING DATAFILE IN ASM

  • Re-sizing  datafiles in ASM is very simple.

+ASM oracle@akyaka:/home/oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 26 14:53:56 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

 

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> select name from v$datafile;

NAME
——————————————————————————–

+DBA/sritam01/datafile/system.260.932399649
+DBA/sritam01/datafile/sysaux.261.932399653
+DBA/sritam01/datafile/undotbs1.262.932399655
+DBA/sritam01/datafile/users.264.932399665
+DBA/sritam01/datafile/cw_data.266.933506593
+DBA/sritam01/datafile/cw_index.267.933506607
+DBA/sritam01/datafile/tools.268.933506617
+DBA/sritam01/datafile/xcom_data.269.933506639
+DBA/sritam01/datafile/xcom_indx.270.933506647
+DBA/sritam01/datafile/xcom_lobs.271.933506659
+DBA/sritam01/datafile/cw_data.272.933506675

NAME
——————————————————————————–
+DBA/sritam01/datafile/cw_data.273.933506679
+DBA/sritam01/datafile/dbmain_data.274.950891839
+DBA/sritam01/datafile/cw_data.275.966863495
+DBA/sritam01/datafile/cw_data.276.966863579
+DBA/sritam01/datafile/cw_data.277.966863661

16 rows selected.

the following example shows how to extend a datafile to the table_space_name tablespace in the +DBA ASM group.

1. Identify the datafiles for the tablespace you want to increase.

SQL> select file_name,bytes/1024/1024 mb from dba_data_files where tablespace_name = ‘SYSTEM‘ order by file_name;

FILE_NAME
——————————————————————————–
MB
———-
+CWBAU/sritam01/datafile/system.260.932399649
30000

Extened the Datafile

SQL> alter database datafile ‘+DBA/sritam01/datafile/system.260.932399649’ RESIZE 30001M;

Database altered.

SQL> select file_name,bytes/1024/1024 mb from dba_data_files where tablespace_name = ‘SYSTEM’ order by file_name;

FILE_NAME
——————————————————————————–
MB
———-
+DBA/sritam01/datafile/system.260.932399649
30001

 

SQL>

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s