ORA-01107: database must be mounted for media recovery

文档解释

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;

你可能感兴趣的