Shulou(Shulou.com)06/03 Report--

12C dataguard 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

The status of the reserve 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

A RMAN-06820,ORA-17629,ORA-17627 error is reported when standby (standby library) backs up archivelog, but in the end, the archive backup is successful.

[oracle@localhost ~] $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 current 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

Solution:

Log in as sys on the slave library

Rman target sys/password

You can refer to the following documentation:

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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.