This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle.
Thursday, February 28, 2013
Copy Archivelogs from ASM to disk via asmcmd
Copy current archivelogs from asmcmd (as oracle user):
export ORACLE_HOME=/u01/app/11.2.0/grid
export ORACLE_SID=+ASM1
asmcmd
ASMCMD> ls -la
ASMCMD> cd TEST_TESTDB_ARCH0/
ASMCMD> cd TESTDB/
ASMCMD> cd ARCHIVELOG/
ASMCMD> cd 2012_02_28/
# This gives you latest logs in the end of the listing:
ASMCMD> ls -lat --reverse
ASMCMD> cp '+TEST_TESTDB_ARCH0/TESTDB/ARCHIVELOG/2012_02_28/thread_2_seq_144810.3108.808567851' /backup/export/thread_2_seq_144810.3108.808567851
NOTE! You can use the cp command to:
----
-Copy files from a disk group to the operating system
-Copy files from a disk group to a disk group
-Copy files from the operating system to a disk group
----
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment