ORA ASM
main monitor ddl objects dml stato e configurazione rman & dpump pl/sql cluster ASM
main config start-shut process memory monitor diag
user rman & dpump pl/sql cluster ASM

Reference

Add datafile

alter tablespace &tbs add datafile '&df_name' size %df_size;
 
-- Es:
alter tablespace AUDTBS add datafile '+DATA_PRE' size 30G;

Verifica spazio disponibile su cluster ASM

sudo su - grid
ls -la       
. ./.profileGRID
sc02db101bil@+ASM1:/export/home/grid # asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Block       AU  Total_MB   Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512   4096  4194304  37748736  18067260          1048576         8509342              0             N  BACKUP_PRE/
MOUNTED  NORMAL  N         512   4096  4194304  62926848  38861012          1747968        18556522              0             N  DATA_PRE/
MOUNTED  NORMAL  N         512   4096  4194304    221184    219888             6144          106872              0             Y  DBFS_PRE/
MOUNTED  NORMAL  N         512   4096  4194304  14708736   8762236           408576         4176830              0             N  RECO_PRE/
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License