12C dataguard备库备份archivelog出现报错
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 备库的状态 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(备库)备份archivelog时会报RMAN-06820，ORA-17629，ORA-17627的错,但是最后归档还是备份成功了。 [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
解决方法：
在备库上以sys用户登录
rman target sys/password
可以参考以下文档：
RMAN-06820 ORA-17629 ORA-17627 ORA-01034 ORA-27101 During Backup of a Standby Database ( )
RMAN-06820 ORA-17629 During Backup at Standby Site ( )
RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database ( )