Sunday, November 6, 2016

COPY Archivelog from ASM to File System (vice-versa)

In this article we will show COPY archivelog from ASM to File System (vice-versa)

COPY ARCHIVELOG FROM ASM TO FILE SYSTEM
Copy Archive log from ASM to File System (172.xx.xx.17)
ASMCMD> cp thread_2_seq_29276.2143.926850451 /u01/grid/seq_29276.bak
copying +fra/dcpdb/ARCHIVELOG/2016_11_02/thread_2_seq_29276.2143.926850451 -> /u01/grid/seq_29276.bak
ASMCMD>
ASMCMD>
ASMCMD> cp thread_2_seq_29277.909.926851881 /u01/grid/seq_29277.bak
copying +fra/dcpdb/ARCHIVELOG/2016_11_02/thread_2_seq_29277.909.926851881 -> /u01/grid/seq_29277.bak
ASMCMD>
ASMCMD>
ASMCMD> cp thread_2_seq_29278.1497.926853021 /u01/grid/seq_29278.bak
copying +fra/dcpdb/ARCHIVELOG/2016_11_02/thread_2_seq_29278.1497.926853021 -> /u01/grid/seq_29278.bak
ASMCMD>

Copy Archive log from ASM to File System (172.xx.xx.15)
ASMCMD>
ASMCMD> cp thread_1_seq_29530.2118.926850057 /u01/oraclesoft/seq_29530.bak
copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29530.2118.926850057 -> /u01/oraclesoft/seq_29530.bak
ASMCMD>
ASMCMD> cp thread_1_seq_29531.848.926851257 /u01/oraclesoft/seq_29531.bak
copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29531.848.926851257 -> /u01/oraclesoft/seq_29531.bak
ASMCMD>
ASMCMD> cp thread_1_seq_29532.2814.926852359 /u01/oraclesoft/seq_29532.bak
copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29532.2814.926852359 -> /u01/oraclesoft/seq_29532.bak
ASMCMD>
ASMCMD> cp thread_1_seq_29533.2639.926853019 /u01/oraclesoft/seq_29533.bak
copying +fra/dcpdb/archivelog/2016_11_02/thread_1_seq_29533.2639.926853019 -> /u01/oraclesoft/seq_29532.bak
ASMCMD>

TRANSFER ARCHIVELOG TO ANOTHER SERVER
grid@dcpdb2 [/u01/grid]$
grid@dcpdb2 [/u01/grid]$ scp seq* grid@172.xx.xxx.26:/u01/grid
The authenticity of host '172.31.200.26 (172.xx.xxx.26)' can't be established.
ECDSA key fingerprint is 09:14:29:aa:83:c6:df:68:28:94:56:e8:0e:b0:db:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.xx.xxx.26' (ECDSA) to the list of known hosts.
Password:
seq_29276.bak                                                         100%  582MB  32.3MB/s  34.4MB/s   00:18
seq_29277.bak                                                         100%  582MB  30.6MB/s  34.4MB/s   00:19
seq_29278.bak                                                         100%  561MB  31.1MB/s  35.6MB/s   00:18
grid@dcpdb2 [/u01/grid]$


grid@dcpdb1 [/u01/oraclesoft]$ scp seq* grid@172.xx.xxx.26:/u01/grid
The authenticity of host '172.31.200.26 (172.xx.xxx.26)' can't be established.
ECDSA key fingerprint is 09:14:29:aa:83:c6:df:68:28:94:56:e8:0e:b0:db:3d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.xx.xxx.26' (ECDSA) to the list of known hosts.
Password:
seq_29530.bak                                                         100%  582MB  34.2MB/s  34.0MB/s   00:17
seq_29531.bak                                                         100%  581MB  30.6MB/s  34.9MB/s   00:19
seq_29532.bak                                                         100%  594MB  31.3MB/s  36.1MB/s   00:19
seq_29533.bak                                                         100%  381MB  34.7MB/s  36.1MB/s   00:11
grid@dcpdb1 [/u01/oraclesoft]$


COPY ARCHIVELOG FROM FILE SYSTEM TO ASM
ASMCMD>
ASMCMD> cp /u01/grid/seq_29276.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29276.bak -> +fra/dcpdb/ARCHIVELOG/seq_29276.bak
ASMCMD> cp /u01/grid/seq_29277.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29277.bak -> +fra/dcpdb/ARCHIVELOG/seq_29277.bak
ASMCMD>
ASMCMD> cp /u01/grid/seq_29278.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29278.bak -> +fra/dcpdb/ARCHIVELOG/seq_29278.bak
ASMCMD>
ASMCMD> cp /u01/grid/seq_29530.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29530.bak -> +fra/dcpdb/ARCHIVELOG/seq_29530.bak
ASMCMD>
ASMCMD> cp /u01/grid/seq_29531.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29531.bak -> +fra/dcpdb/ARCHIVELOG/seq_29531.bak
ASMCMD>
ASMCMD> cp /u01/grid/seq_29532.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29532.bak -> +fra/dcpdb/ARCHIVELOG/seq_29532.bak
ASMCMD>
ASMCMD> cp /u01/grid/seq_29533.bak +fra/dcpdb/ARCHIVELOG/
copying /u01/grid/seq_29533.bak -> +fra/dcpdb/ARCHIVELOG/seq_29533.bak
ASMCMD>
ASMCMD>


No comments:

Post a Comment