Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I copy archivelogs from one log_archive_dest to another

Duncan GardnerJul 18 2020 — edited Jul 22 2020

I temporarily ran out of disc space in log_archive_dest_2, which is a file system. log_archive_dest_1 was ok (ASM). I got error:

ARC0: Error 19504 Creating archive log file

So now I want to copy files from log_archive_dest_1 to log_archive_dest_2 (which now has sufficient space). AND have them reflected in v$archived_log where dest_id =2. I know I can copy the file to the file system, but I end up with a record in v$archive_log where dest_id = 1 (using RMAN> copy archivelog '+FRA...' to '/u01...';)

Is this possible? Oracle 11g RAC, Standard Edition.

Thanks, Duncan

Comments
Post Details
Added on Jul 18 2020
8 comments
2,619 views