aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-16827: Flashback Database is disabled

ORA-16827: Flashback Database is disabled
Cause: The broker detected that the Flashback Database feature was disabled. With Flashback Database disabled, the broker would not be able to:
- reinstate a database that required reinstatement.

- convert a physical standby database to a snapshot standby database.

- convert a snapshot standby database to a physical standby database. Flashback Database may been disabled manually with the ALTER DATABASE FLASHBACK DATABASE OFF command or automatically by the database in the event of an error.

Action: Check the database alert log to determine whether Flashback Database was disabled due to errors and then correct the problem. If Flashback Database had been manually disabled, reenable Flashback Database with the ALTER DATABASE FLASHBACK DATABASE ON command. If, after enabling Flashback Database, the database still cannot be reinstated or converted, you must re-create the database from a copy of the primary database.

请先 登录 后评论

1 个回答

小智
ORA-16827:禁用闪回数据库,
.原因:代理检测到闪回数据库功能已禁用。禁用闪回数据库后,代理将无法:,
.- 恢复需要恢复的数据库。,
.,
.- 将物理备用数据库转换为快照备用数据库。,
.,
.- 将快照备用数据库转换为物理备用数据库。闪回数据库可能已使用ALTER DATABASE FLASHBACK DATABASE OFF命令手动禁用,或在发生错误时由数据库自动禁用。,
.,
.操作:检查数据库警报日志以确定是否由于错误而禁用了闪回数据库,然后更正问题。如果已手动禁用闪回数据库,请使用ALTER DATABASE FLASHBACK DATABASE ON命令重新启用闪回数据库。如果在启用闪回数据库后,数据库仍无法恢复或转换,则必须从主数据库的副本重新创建数据库。,
.
请先 登录 后评论