文档解释
ORA-01107: database must be mounted for media recovery
Cause: An attempt to perform media recovery was made but the database is not mounted.
Action: Mount the database.
ORA-01107: database must be mounted for media recovery
详细说明:
ORA-01107: 恢复媒体操作之前,数据库必须是mount状态。这是说明oracle数据库必须被mount到数据库节点才能进行恢复媒体操作。
官方解释
ORA-01107: database must be mounted for media recovery is an informational message. It states that the database must be mounted before a media recovery of an offline database can be performed.
常见案例
ORA-01107在RMAN媒体恢复时会出现,如果数据库已经关闭,无法正常恢复,此时会显示ORA-01107: database must be mounted for media recovery.
正常处理方法及步骤
1. 使用控制台会话启动数据库:
SQL> Startup mount
2. 启动RMAN恢复会话。
RMAN> recover database;
3. 完成重做日志恢复后,解除mount状态:
SQL> alter database open;