随笔 - 369  文章 - 1  评论 - 15  阅读 - 52万

ORACLE--报错,ORA-38770

浏览器右上角查看导航按钮>>>>

一,问题描述

 

  背景说明,Dg备库需要恢复到三天前,但是期间没有开闪回,临时开始,出现了这个错误。原因分析:

复制代码
To enable Flashback Database, you configure a fast recovery area and set a flashback retention target. This retention target specifies how far back you can rewind a database with Flashback Database.

From that time onwards, at regular intervals, the database copies images of each altered block in every data file into the flashback logs. These block images can later be reused to reconstruct the data file contents for any moment at which logs were captured.

When you use Flashback Database to rewind a database to a past target time, the command determines which blocks changed after the target time and restores them from the flashback logs. The database restores the version of each block that is immediately before the target time. The database then uses redo logs to reapply changes that were made after these blocks were written to the flashback logs.

Redo logs on disk or tape must be available for the entire time period spanned by the flashback logs. For example, if the flashback retention target is 1 week, then you must ensure that online and archived redo logs that contain all changes for the past week are accessible. In practice, redo logs are typically needed much longer than the flashback retention target to support point-in-time recovery.

During the flashback operation, RMAN may need to restore archived redo logs from backup. Enter the following command to see whether channels are configured (sample output is included):
复制代码

  这个是官方文档说明了如果要恢复在指定时间点确保期间的重做日志存在,例如,如果闪回保留目标为1周,则必须确保可以访问包含过去一周所有更改的联机和归档重做日志。实际上,重做日志通常比闪回保留目标更长,以支持时间点恢复。所以出现的问题可能为归档丢失,或者闪回是临时开启,更本就没有存放任何恢复操作。

posted on   kingle-l  阅读(564)  评论(0编辑  收藏  举报
编辑推荐:
· 为什么说在企业级应用开发中,后端往往是效率杀手?
· 用 C# 插值字符串处理器写一个 sscanf
· Java 中堆内存和栈内存上的数据分布和特点
· 开发中对象命名的一点思考
· .NET Core内存结构体系(Windows环境)底层原理浅谈
阅读排行:
· 为什么说在企业级应用开发中,后端往往是效率杀手?
· DeepSeek 解答了困扰我五年的技术问题。时代确实变了!
· 本地部署DeepSeek后,没有好看的交互界面怎么行!
· 趁着过年的时候手搓了一个低代码框架
· 推荐一个DeepSeek 大模型的免费 API 项目!兼容OpenAI接口!
历史上的今天:
2018-08-14 单播,广播,组播
< 2025年2月 >
26 27 28 29 30 31 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 1
2 3 4 5 6 7 8

levels of contents
点击右上角即可分享
微信分享提示

目录导航