温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

RMAN-06820: WARNING: failed to archive current log at primary database

发布时间:2020-07-07 03:22:05 来源:网络 阅读:4774 作者:bin321 栏目:大数据

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  )

 

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI