Database

Get Involved. Join the Conversation.

Topic

    Dragos Vilcu
    datafile location on a "DB on VM"Answered
    Topic posted July 29, 2019 by Dragos VilcuRed Ribbon: 250+ Points, tagged DBaaS, DBCS 
    40 Views, 3 Comments
    Title:
    datafile location on a "DB on VM"
    Summary:
    datafile location on a "DB on VM"
    Content:

    Hello,

    I want to create a new tablespaces on a DB on VM, but I don't know where is the location for the datafiles.

    if I query DBA_data_files I got some locations like +DATA/DCSDB03_IAD1X7/8DB63059418C5423E05373107D64E799/DATAFILE/system.271.1013680223   but  on operating system itself, I wasn't able to find the "DATAFILE" directory.

    Thank you

     

     

     

     

    Best Comment

    Simon Law

    This is because the storage for the Database is using Automatic Storage Management (ASM), so you will not see the OS file system. 

    -Simon  

    Comment

     

    • Simon Law

      This is because the storage for the Database is using Automatic Storage Management (ASM), so you will not see the OS file system. 

      -Simon  

    • enrique ortiz

      Hi 

      the storage for the database is in ASM , these disk are not visible to the operating system but managed by oracle 

      these disks are managed by oracle , it only has a header and has no operating system formatting at all , if you try to access write or mount at the operating system you probably delete the database 

      the disk are in the /dev directory and controlled by the asmcmd utility , there are commands to list the disk and the size of the data, for example

      - log as opc

      - change to user grid ( sudo su - grid ) 

      - asmcmd lsdks

      [grid@********** dev]$ asmcmd lsdsk 
      Path
      /dev/DATADISK10
      /dev/DATADISK11
      /dev/DATADISK12
      /dev/DATADISK9
      /dev/RECODISK10
      /dev/RECODISK11
      /dev/RECODISK12
      /dev/RECODISK9

      [grid@********* dev]$ asmcmd lsdg 
      State            Type    Rebal  Sector  Logical_Sector  Block       AU      Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
      MOUNTED  EXTERN  N         512             512        4096  4194304   4194304  2030272             0                      2030272              0             Y  DATA/
      MOUNTED  EXTERN  N         512             512       4096  4194304    839680   624264                0                        624264              0             N  RECO/

      the DATA is the data disk and the RECO is the recovery disk , used for the redos and archivers , so i have 4TB Data and  free 2Tb ( 2030272)