Forum Stats

  • 3,828,180 Users
  • 2,260,870 Discussions
  • 7,897,509 Comments

Discussions

Copying archivelog files from ASM to filesystem in a remote server

user11971189
user11971189 Member Posts: 1
edited Apr 8, 2020 9:54AM in Recovery Manager (RMAN)

Hi,

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 12.2.0.1.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

RMAN> exit

Recovery Manager complete.

[newbox]/home/oracle> ls -l /oracle/XQ1/oraarch/XP1_stdby

total 0

[newbox]/home/oracle>

(...)

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,

Alexandre

Answers

  • Dude!
    Dude! Member Posts: 22,829 Black Diamond
    edited Apr 8, 2020 9:54AM
    RMAN> backup as copy2> DB_FILE_NAME_CONVERT = ('+XP1_ARCH/XP1/ARCHIVELOG/2020_04_07/','/oracle/XQ1/oraarch/XP1_stdby/')

    Are you trying to copy archivelogs from the XP1_ARCH datagroup of the target database to the remote /oracle directory at the standby database?