FATAL-9087: Could not find any valid archive or online redo log

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
2 min read

Problem Description

The following error is displayed when MINE process is started:

Trying to create support package (base error: FATAL-9087: Could not find any valid archive or online redo log 81189 (thread 1). See log file whether any files were rejected.) />Packaging into ZIP file: /home/oracle/lhc_prod/log/dbvisit_support_dbvrep_lhc_prod_MINE.3T65.zip for process MINE, addinfo [] />Trying retrieving +FRA/lhcprod/archivelog/2013_07_14/thread_1_seq_81193.4013.820784509 from ASM using asmcmd. If this fails, restart with NOASMDIRECT added to the SUPPORT command. This requires Oracle 11g or newer. />Connected to an idle instance. />ASMCMD-08102: no connection to ASM; command requires ASM to run />asmcmd failed to copy the log file. />Trying retrieving +FRA/lhcprod/archivelog/2013_07_14/thread_1_seq_81193.4013.820784509 from ASM. If this fails, restart with NOASM added to the SUPPORT command. />backtrace() returned: />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(bt+0x2b) [0x2b21f4305949] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(mine_dump_all_omitbuf+0x27e) [0x2b21f4305e8f] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(mine_dump_all_omitbuf_Perl+0xe) [0x2b21f42ff064] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/Libmine.so(XS_Libmine_mine_dump_all_omitbuf_Perl+0xdb) [0x2b21f40e5e8b] />dbvrep MINE lhc(Perl_pp_entersub+0x489) [0x4925d9] />dbvrep MINE lhc(Perl_runops_standard+0xe) [0x490afe] />dbvrep MINE lhc [0x4c657a] />dbvrep MINE lhc(Perl_runops_standard+0xe) [0x490afe] />dbvrep MINE lhc(Perl_call_sv+0x16f) [0x43657f] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(ASM_open_log+0x317) [0x2b21f4378403] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(mine_ASM_open_log+0x34) [0x2b21f42fde40] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/Libmine.so(XS_Libmine_mine_ASM_open_log+0x1d7) [0x2b21f40e8d47] />dbvrep MINE lhc(Perl_pp_entersub+0x489) [0x4925d9] />dbvrep MINE lhc(Perl_runops_standard+0xe) [0x490afe] />dbvrep MINE lhc(Perl_call_sv+0x48a) [0x43689a] />dbvrep MINE lhc(Perl_call_list+0x20f) [0x436caf] />dbvrep MINE lhc [0x4234df] />dbvrep MINE lhc(Perl_newATTRSUB+0x9f4) [0x42f654] />dbvrep MINE lhc(Perl_yyparse+0x1bbd) [0x45e04d] />dbvrep MINE lhc [0x438be1] />dbvrep MINE lhc(perl_parse+0x4a9) [0x439809] />dbvrep MINE lhc(main+0x170) [0x421170] />/lib64/libc.so.6(__libc_start_main+0xf4) [0x3ccda1d994] />dbvrep MINE lhc(sin+0xb9) [0x41ebc9] />backtrace() returned: />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCapply.so(bt+0x2b) [0x2b21fc35c581] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCapply.so(apply_dump_all_omitbuf+0x27e) [0x2b21fc35cac7] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCapply.so(apply_dump_all_omitbuf_Perl+0xe) [0x2b21fc35939c] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/Libapply.so(XS_Libapply_apply_dump_all_omitbuf_Perl+0xdb) [0x2b21fc1447eb] />dbvrep MINE lhc(Perl_pp_entersub+0x489) [0x4925d9] />dbvrep MINE lhc(Perl_runops_standard+0xe) [0x490afe] />dbvrep MINE lhc [0x4c657a] />dbvrep MINE lhc(Perl_runops_standard+0xe) [0x490afe] />dbvrep MINE lhc(Perl_call_sv+0x16f) [0x43657f] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(ASM_open_log+0x317) [0x2b21f4378403] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/libCmine.so(mine_ASM_open_log+0x34) [0x2b21f42fde40] />/tmp/par-oracle/cache-accc380098ae66b77c6d9132c52c769cf0dad3b4/Libmine.so(XS_Libmine_mine_ASM_open_log+0x1d7) [0x2b21f40e8d47] />dbvrep MINE lhc(Perl_pp_entersub+0x489) [0x4925d9] />dbvrep MINE lhc(Perl_runops_standard+0xe) [0x490afe] />dbvrep MINE lhc(Perl_call_sv+0x48a) [0x43689a] />dbvrep MINE lhc(Perl_call_list+0x20f) [0x436caf] />dbvrep MINE lhc [0x4234df] />dbvrep MINE lhc(Perl_newATTRSUB+0x9f4) [0x42f654] />dbvrep MINE lhc(Perl_yyparse+0x1bbd) [0x45e04d] />dbvrep MINE lhc [0x438be1] />dbvrep MINE lhc(perl_parse+0x4a9) [0x439809] />dbvrep MINE lhc(main+0x170) [0x421170] />/lib64/libc.so.6(__libc_start_main+0xf4) [0x3ccda1d994] />dbvrep MINE lhc(sin+0xb9) [0x41ebc9] />memory_limit set to 2147483648, now using 68182197 />ErrCode mallocs curr allocs curr size sum size max size

The issue is MINE is looking for an archive log file which is no longer available. Check that the redo log 81189 (thread 1) is in v$archived_log. It should be in this view and the file name should be filled in. The error message suggest the file name is NULL now, meaning it was deleted by rman.

Solution

You can either restore the archive log(s) from backup using rman or start the replication from scratch.

Arjen Visser July 17, 2013 22:14