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: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
Email: malluramadurg@gmail.com
LinkedIn: / mallik034
RU-vid: / mallik034
Fakebook: / mallik034
Blog: mallik034.blog...
twitter: / mallik034
Instagram: / mallik034
FBPage: / mallik034oracledba
Skype: malluramadurg
25 авг 2024