rman-06820:warning:failed to archive-log at primary database

12C Dataguard Standby Backup Archivelog Error

Problem Description
---------------------------------------------------
Sql> select * from Product_component_version;

PRODUCT VERSION STATUS
---------------------------------------- ---------- ----------------------------------------
Nlsrtl 12.1.0.2.0 Production
Oracle Database 12c Enterprise Edition 12.1.0.2.0 64bit Production
PL/SQL 12.1.0.2.0 Production
TNS for linux:12.1.0.2.0 Production

State of the Standby library
Sql> select Open_mode,protection_mode,database_role from V$database;

Open_mode Protection_mode Database_role
-------------------- -------------------- ----------------
READ only with APPLY MAXIMUM performance physical STANDBY

Sql> Select thread#, sequence#,applied from V$archived_log where applied= ' NO ';

No rows selected

Standby (Standby) backup archivelog will be reported rman-06820,ora-17629,ora-17627 error, but the final archive or backup succeeded.

[[Email protected] ~] $rman target/

rman> backup Archivelog all;

Starting backup at 02-oct-15
Using target database control file instead of recovery catalog
rman-06820:warning:failed to archive-log at primary database
ORACLE error from Target database:
Ora-17629:cannot connect to the remote database server
Ora-17627:ora-00942:table or view does not exist

Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=1156 Device Type=disk
Channel ora_disk_1:starting archived log backup set
Channel ora_disk_1:specifying archived log (s) in backup set
Input archived log thread=2 sequence=132 recid=135 stamp=891367439
Input archived log thread=1 sequence=172 recid=134 stamp=891367438
......
Piece HANDLE=/OPT/ORACLE/ORADATA/MXCNSTB/BACKUPSET/2015_10_02/O1_MF_ANNNN_TAG20151002T144942_C0WBBDW1_.BKP tag= tag20151002t144942 Comment=none
Channel Ora_disk_1:backup set complete, elapsed time:00:00:07
Finished backup at 02-oct-15

Workaround:

Log on as SYS user on the standby library

Rman Target Sys/password

You can refer to the following documents:

RMAN-06820 ORA-17629 ORA-17627 ORA-01034 ORA-27101 During Backup of a Standby Database ( Doc ID 2042148.1 )

RMAN-06820 ORA-17629 During Backup at Standby Site ( Doc ID 1616074.1 )

RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database ( Doc ID 2025142.1 )

This article is from the "SYSDBA" blog, make sure to keep this source http://sysdba.blog.51cto.com/10492366/1700917

rman-06820:warning:failed to archive-log at primary database