ORA-38787: Creating the first guaranteed restore point requires mount mode when flashback database is off. ORACLE 报错 故障修复 远程处理
文档解释
ORA-38787: Creating the first guaranteed restore point requires mount mode when flashback database is off.
Cause: While flashback database is not on, an attempt was made to create the first guaranteed restore point while the database is open.
Action: Mount the database and retry.
ORA-38787是由于flashback database未打开时创建第一个guaranteed restore point时需要mount模式。
官方解释
当flashback database关闭时,创建第一个guaranteed restore point(GRP)必须在实例的挂载模式下进行操作。ORA-38787发生,如果在关闭状态下试图创建第一个GRP。
常见案例
ORA-38787发生,当使用操作“ALTER DATABASE CREATE GUARANTEED RESTORE POINT ”时时flashback database关闭。
一般处理方法及步骤
1.以sysdba身份登录数据库实例;
2.运行“ALTER DATABASE MOUNT” 命令以将数据库实例设置为挂载模式;
3.执行“ALTER DATABASE CREATE GUARANTEED RESTORE POINT ”。