ASM--文件系统之间归档日志的拷贝
从ASM中拷贝归档日志到文件系统:
RMAN> copy archivelog '+ARCH/psdb/archivelog/2020_06_14/thread_2_seq_16087.1656.1043088111' to '/home/oracle/test/thread_2_seq_16087.dbf';
Starting backup at 15-JUN-20
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=2954 instance=psdb1 device type=DISK
channel ORA_DISK_1: starting archived log copy
input archived log thread=2 sequence=16087 RECID=68831 STAMP=1043088113
output file name=/home/oracle/test/thread_2_seq_16087.dbf RECID=68967 STAMP=1043161599
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:15
Finished backup at 15-JUN-20
RMAN> copy archivelog '+ARCH/psdb/archivelog/2020_06_14/thread_1_seq_12919.1522.1043088701' to '/home/oracle/test/thread_1_seq_12919.dbf';
Starting backup at 15-JUN-20
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=12919 RECID=68834 STAMP=1043088703
output file name=/home/oracle/test/thread_1_seq_12919.dbf RECID=68971 STAMP=1043161638
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:15
Finished backup at 15-JUN-20
RMAN> exit
Recovery Manager complete.
[oracle@psdb1 ~]$ cd test/
[oracle@psdb1 test]$ ll -thr
total 3.1G
-rw-r----- 1 oracle asmadmin 1.6G Jun 15 15:06 thread_2_seq_16087.dbf
-rw-r----- 1 oracle asmadmin 1.6G Jun 15 15:07 thread_1_seq_12919.dbf
[oracle@psdb1 test]$
-----
从文件系统中拷贝归档日志到ASM
RMAN> catalog archivelog '/disk/orabak/1_81_727543102.dbf';
cataloged archive log
archive log filename=/disk/orabak/1_79_727543102.dbf recid=158 stamp=747937512
RMAN> copy archivelog '/disk/orabak/1_81_727543102.dbf' to '+ORADATA_DG/ORADBSDB/ARCH/1_81_727543102.dbf';
Starting backup at 08-APR-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive copy
input archive log thread=1 sequence=81 recid=161 stamp=747938070
output filename=+ORADATA_DG/oradbsdb/arch/1_81_727543102.dbf recid=185 stamp=747938158
channel ORA_DISK_1: archivelog copy complete, elapsed time: 00:00:02
Finished backup at 08-APR-11
RMAN> catalog archivelog '+ORADATA_DG/ORADBSDB/ARCH/1_81_727543102.dbf';
cataloged archive log
archive log filename=+ORADATA_DG/oradbsdb/arch/1_79_727543102.dbf recid=160 stamp=747937552
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· 没有源码,如何修改代码逻辑?
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了