【YashanDB知识库】YAS-02547 there is a gap in the restored archived logs on instance 1, reason: start of restored archive 35 is greater than database last archive 21

简介: 【YashanDB知识库】YAS-02547 there is a gap in the restored archived logs on instance 1, reason: start of restored archive 35 is greater than database last archive 21

本文内容来自YashanDB官网,原文内容请见 https://www.yashandb.com/newsinfo/7849017.html?templateId=1718516

【标题】错误码处理

【问题分类】执行数据库归档注册时报错

【关键字】YAS-02547

【问题描述】执行restore archivelog sequence between xxx and yyy thread 1 from searchdir '/tmp/d1' ; 语句后触发报错。

【问题原因分析】

YAS-02547 there is a gap in the restored archived logs on instance 1, reason: start of restored archive 35 is greater than database last archive 21

由于数据库中当前注册的最新归档号为21,在恢复归档文件时,必须从下一个归档(22号归档)开始进行恢复。

在实际恢复中,指定的归档范围中最早的归档号为35,因此触发报错。

【解决/规避方法】按归档生成的顺序依次进行恢复,不能跳过更早的归档,直接恢复更新的归档。

【影响范围】-

【修复版本】-

相关文章
|
9月前
|
数据库
【YashanDB 知识库】YAS-02547
【YashanDB 知识库】YAS-02547
|
9月前
|
数据库
【YashanDB知识库】YAS-02547
【YashanDB知识库】执行restore archivelog sequence between xxx and yyy thread 1 from searchdir '/tmp/d1' ; 语句后触发报错。
|
9月前
|
数据库
【YashanDB知识库】YAS-02547 there is a gap in the restored archived logs on instance 1, reason: start of restored archive 35 is greater than database last archive 21
【YashanDB知识库】YAS-02547 there is a gap in the restored archived logs on instance 1, reason: start of restored archive 35 is greater than database last archive 21
|
9月前
|
数据库
【YashanDB知识库】安装共享集群时报错:YAS-05721 invalid input parameter, reason: node name invalid
【YashanDB知识库】安装共享集群时报错:YAS-05721 invalid input parameter, reason: node name invalid
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
455 2
|
Oracle 关系型数据库
19c 开启Oracle Database Vault
19c 开启Oracle Database Vault
331 1
|
SQL Oracle 关系型数据库
Connect to Autonomous Database Using Oracle Database Tools
Connect to Autonomous Database Using Oracle Database Tools
235 1
|
人工智能 Oracle 关系型数据库
一篇文章弄懂Oracle和PostgreSQL的Database Link
一篇文章弄懂Oracle和PostgreSQL的Database Link
|
Oracle 关系型数据库 Linux
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
186 0
|
SQL Oracle 安全
Oracle Database Vault Access Control Components
Oracle Database Vault Access Control Components
144 0