- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Copying archivelog files from ASM to filesystem in a remote server
We want to copy archivelogs files from ASM to filesystem in a remote server (cloud).
A bit of context: those archivelog files are generated by a 4 node 12.2 RAC which, for technical limitations,
has only one node able to communicate with remote server. That's why set an additional "log_archive_dest"
won't work for us. We don not have space to save archivelogs in local filesystem to move them later.
Parallel to this we are running a "RMAN duplicate" to copy the database using the same path. It is working fine.
We are trying to use "RMAN backup as copy archivelog" but it's not working as expected:
Recovery Manager: Release 18.104.22.168.0 - Production on Wed Apr 8 12:23:30 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/************@XP1001
connected to target database: XP1 (DBID=1480839655)
RMAN> connect auxiliary sys/************@xq1
connected to auxiliary database: XP1 (DBID=1480839655, not open)
RMAN> backup as copy
2> DB_FILE_NAME_CONVERT = ('+XP1_ARCH/XP1/ARCHIVELOG/2020_04_07/','/oracle/XQ1/oraarch/XP1_stdby/')
3> archivelog like '+XP1_ARCH/XP1/ARCHIVELOG/2020_04_07/thread_2_seq_170879.1193.1037105983';
Starting backup at 08-APR-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=7838 instance=XP1001 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=4401 instance=XP1001 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=6686 instance=XP1001 device type=DISK
allocated channel: ORA_DISK_15
channel ORA_DISK_15: SID=3223 instance=XP1001 device type=DISK
allocated channel: ORA_DISK_16
channel ORA_DISK_16: SID=4611 instance=XP1001 device type=DISK
channel ORA_DISK_1: starting archived log copy
input archived log thread=2 sequence=170879 RECID=669041 STAMP=1037106003
output file name=+XP1_ARCH/XP1/ARCHIVELOG/2020_04_08/thread_2_seq_170879.1101.1037190319 RECID=669487 STAMP=1037190325
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:07
Finished backup at 08-APR-20
Starting Control File and SPFILE Autobackup at 08-APR-20
piece handle=+XP1_ARCH/XP1/AUTOBACKUP/2020_04_08/s_1037190329.859.1037190331 comment=NONE
Finished Control File and SPFILE Autobackup at 08-APR-20
Recovery Manager complete.
[newbox]/home/oracle> ls -l /oracle/XQ1/oraarch/XP1_stdby
Could you help us to find out what are we doing wrong? Is Anything regarding the auxiliary destination missing ?
Thanks in advance and best regards,