How to increase TABLESPACE size in ASM

 Re-sizing data files in ASM is very straightforward.


+ASM oraprod@appsolworld:/home/oracle>sqlplus / as sysdba


SSQL*Plus: Release 19.0.0.0.0 - Production on Sun Nov 27 19:53:53 2022

Version 19.14.0.0.0


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



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.14.0.0.0


SQL> select name from v$datafile;


NAME

——————————————————————————–


+DBA/appsolworld/datafile/system.260.932399649

+DBA/appsolworld/datafile/sysaux.261.932399653

+DBA/appsolworld/datafile/undotbs1.262.932399655

+DBA/appsolworld/datafile/users.264.932399665

+DBA/appsolworld/datafile/cw_data.266.933506593

+DBA/appsolworld/datafile/cw_index.267.933506607

+DBA/appsolworld/datafile/tools.268.933506617

+DBA/appsolworld/datafile/xcom_data.269.933506639

+DBA/appsolworld/datafile/xcom_indx.270.933506647

+DBA/appsolworld/datafile/xcom_lobs.271.933506659

+DBA/appsolworld/datafile/cw_data.272.933506675

NAME

——————————————————————————–

+DBA/appsolworld/datafile/cw_data.273.933506679

+DBA/appsolworld/datafile/dbmain_data.274.950891839

+DBA/appsolworld/datafile/cw_data.275.966863495

+DBA/appsolworld/datafile/cw_data.276.966863579

+DBA/appsolworld/datafile/cw_data.277.966863661

16 rows selected.


The below command shows how to extend a datafile to the table_space_name tablespace in the +APPS ASM group.


1. Identify the data files for the tablespace that must be increased.


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


FILE_NAME

——————————————————————————–

GB

———-

+APPS/appsolworld/datafile/system.260.932399649

30


Extended the Datafile


SQL> alter database datafile ‘+APPS/appsolworld/datafile/system.260.932399649’ RESIZE 60G;


Database altered.


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


FILE_NAME

——————————————————————————–

GB

———-

+APPS/appsolworld/datafile/system.260.932399649

60



Steps to create tablespace :

CREATE TABLESPACE tbs1 

   DATAFILE 'tbs1_data.dbf' 

   SIZE 1m;



Comments

Popular posts from this blog

How to drop index and before dropping it how to get the DDL.

PRVG-11250 : The check "RPM Package Manager database" was not performed because

How to troubleshoot Long Running Concurrent Request in EBS 12.2

ORA-00257:archiver error, connect internal only until freed

Verifying Daemon “Avahi-Daemon” Not Configured And Running …FAILED (PRVG-1360)

Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm

CPU Patch Analysis

How to write to a CSV file using Oracle SQL*Plus

SKIP DNS RESLOV.CONF CHECK DURING RAC CONFIGURATION

How to fix Oracle SQL Developer connection issue "Got minus one from a read call"