How to resolve datafile location error when omitted "+" when adding datafile in a tablespace in +DG_DATA diskgroup and it mistakenly added it to the filesystem.
Problem: Omitted "+" when adding datafile in a tablespace in +DG_DATA diskgroup and it mistakenly added it to the filesystem. below is the command that created the problem: alter tablespace SYSAUX add datafile 'DG_DATA' size 500m autoextend on next 5G maxsize 30G; select file_id, file_name, bytes, online_status from dba_data_files where tablespace_name = 'SYSAUX'; system@ORA01 > select file_id, file_name, bytes, online_status from dba_data_files where tablespace_name = 'SYSAUX'; FILE_ID FILE_NAME BYTES ONLINE_STA ---------- ---------------------------------------------------------------------- ---------- ---------- 2 +DG_ORA/ora01/ora_sysaux 1.0737E+10 ONLINE 33 +DG_ORA/ora01/ora_sysaux2.dbf 1.0737E+10 ONLINE 34 +DG_ORA/ora01/ora_sysaux3.dbf