您好,登录后才能下订单哦!
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 ( 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 )
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。