We still can’t find backup archivelog in local controlfile

oracleoracle-11g-r2rman

Oracle database is Oracle 11.2.0.3 version.

Every one hour, archivelog will backup to netbackup tape.

But it is strange, even when we use resync catalog command, we still can't find the backed up archivelog file in the local controlfile; but in nbu catalog database, we can find backup archivelog info.

Could you please check if we are doing anything wrong?

list backup of archivelog from logseq 382594 until logseq 382595;
  1. when in local control ,list backup archivelog info is as below; no backed up archivelog found .

Recovery Manager complete.
[opreb@srebdb01 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 23 10:21:38 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: REB (DBID=2063200898)

RMAN> list backup of archivelog from logseq 382594 until logseq 382595;                                    <-

using target database control file instead of recovery catalog
specification does not match any backup in the repository

RMAN> exit


Recovery Manager complete.
  1. Use catalog database to check if we can find backuped archivelog info;
[opreb@srebdb01 ~]$ rman target / catalog rman11g/rman11g@cat11g

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 23 10:21:52 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: REB (DBID=2063200898)
connected to recovery catalog database
list backup of archivelog from logseq 382594 until logseq 382595;                                 <-
RMAN>


List of Backup Sets
===================


BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
128764956 6.50M SBT_TAPE 00:00:09 22-OCT-20
BP Key: 128764959 Status: AVAILABLE Compressed: NO Tag: TAG20201022T215336
Handle: al_73143_1_1054504417 Media: @aaabh

List of Archived Logs in backup set 128764956
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 382594 5576720225 22-OCT-20 5576727105 22-OCT-20
1 382595 5576727105 22-OCT-20 5576733606 22-OCT-20
  1. Then we try to RESYNC CATALOG
RMAN> RESYNC CATALOG
2>
3> ;

starting full resync of recovery catalog
full resync complete

RMAN> exit


Recovery Manager complete.
  1. Event then, we still can't find backup archive log info in local controlfile.
[opreb@srebdb01 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Oct 23 10:22:26 2020

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: REB (DBID=2063200898)

RMAN> list backup of archivelog from logseq 382594 until logseq 382595;                               <-

using target database control file instead of recovery catalog
specification does not match any backup in the repository

RMAN> exit

Thanks for your feedback.

Best Answer

If the backups are going straight to NetBackup, try specifying DEVICE TYPE SBT in your LIST command. The default may be DEVICE TYPE DISK. For example

list backup of archivelog all device type sbt;

HTH