重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-10456:无法打开备用数据库 [打印本页]

作者: mahan 时间: 2022-5-13 17:40
标题: ORA-10456:无法打开备用数据库
rman完成主库到备库的恢复后，在备库运行alter database open；报错：ORA-10456: cannot open standby database;

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-10456: cannot open standby database;media recovery session may be in

progress

解决办法：

1.停止备库的日志应用

SQL> alter database recover managedstandby database cancel;

Database altered.

2.打开备库

SQL> alter database open;

Database altered.

3.备库应用日志

SQL> Alter database recover managedstandby database using current logfile disconnect from session;

Database altered.

4.查看备库状态

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)