Disclaimer

Sunday 11 July 2021

ASM to ASM file Copy

 

How to Copy File from One Server to Another in ASM Diskgroup

As you already know, we can even store the DB export dumpfile in ASM diskgroup itself. Often it becomes challenging to find space in file system to perform export and we decide to use ASM diskgroup to hold the export dump files

If you are performing the export to import it on some 3rd server you need to transfer these export dumpfiles to the target server (Again in target server we have space in ASM diskgroup only), so in this scenarios we need some method to copy the export dump file from source ASM DG to target ASM DG directly. No need to worry the Answer is asmcmd cp command.
I want to copy the export dumpfile from source to target

Environment Setup
Source Server =>  q-orcl-test01
ASM DG=>          +DATAC2
Exp dumpfile=>    QA01_01.dmp
ASM Instance=>   +ASM1

Target Server =>   d-orcl-test01
ASM DG=>          +RECOC1
ASM Instance=>   +ASM1

$asmcmd cp +DATAC2/QA01_01.dmp  sys/password@d-orcl-test01.+ASM1:+RECOC1/backup/QA01_01.dmp

Note: Note the dot immediate after target host name in the command and Password is the  password of sys user for ASM Instance in target server



No comments:

Post a Comment

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...