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
