最新下载
热门教程
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
oracle中flashback standby database解决办法
时间:2022-06-29 09:37:00 编辑:袖梨 来源:一聚教程网
Flashback之后的standby database如何打开,操作如下:
SQL> flashback database to restore point myrs1;
Flashback complete.
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 356517912 bytes
Database Buffers 159383552 bytes
Redo Buffers 3780608 bytes
Database mounted.
SQL>
SQL> alter database recover managed standby database using current logfile disconnect;
alter database recover managed standby database using current logfile disconnect
*
ERROR at line 1:
ORA-01665: control file is not a standby control file
SQL>
SQL>
SQL> alter database convert to physical standby;
Database altered.
SQL>
SQL>
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 356517912 bytes
Database Buffers 159383552 bytes
Redo Buffers 3780608 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
SQL>
相关文章
- 得物网购平台怎么下单 得物怎么下单方法 08-10
- AI写作助手,它是你的创意背后的“魔法师”吗 08-10
- AI写作助手,未来的创意伙伴还是潜在的威胁 08-10
- 颠覆写作界的文档AI助手,一场革命还是噱头 08-10
- 秀秀漫画免费漫画页面在线看漫画网站-秀秀漫画在线阅读页面免费入口页面秋蝉 08-10
- 新浪微博网页版登录入口-新浪微博网页版登录 08-10