ASM - How to Move Datafile Between DG - What is ASM Diskstring? What are Common Discovery Problems?

Move datafile between DG‘s:
alter database datafile old_file offline
copy file
either dbms_file_transfer
or RMAN: copy datafile [OLD] to [NEW]
or XDB ftp client
see Note 330103.1
alter database rename file old_file new_file
recover datafile new_file
alter database datafile new_file online
drop old file

ASM_DISKSTRING Parameter:
all disks accessed by ASM must match one of the disk discovery strings in asm_diskstring
asm_diskstring = ‘string1‘, ‘string2‘, ‘string1‘,‘string2‘,‘string3‘

OS specific default
/dev/raw/raw* on Linux
ORCL:VOL* on Linux (asmlib)
/dev/rdsk/* on Solaris
/dev/rdsk/* on HP
/dev/rhdisk/* on AIX
\\.\ORCLDISK* on Windows

Common Discovery Problems:
diskstring doesn’t match (ORA-15031)
diskstring to complex
wrong device ownership
wrong device type
wrong device binding
disks partitioned incorrectly
OS header missing

#ASM #ASMFileCopy #ASMDiskstring #MoveASMFiles #DiscoverDisks #RAC #Oracle #Database #Exadata

Please do follow me and support me on,

LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg


Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: [email protected]
LinkedIn: https://www.linkedin.com/in/mallik034
YouTube: https://www.youtube.com/c/mallik034
Fakebook: https://www.facebook.com/mallik034
Blog: https://mallik034.blogspot.com
twitter: https://twitter.com/mallik034
Instagram: https://www.instagram.com/mallik034
FBPage: https://www.facebook.com/mallik034oracledba
Skype: malluramadurg