最新下载
热门教程
- 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>
相关文章
- 《道友请留步》冬傲雪新变装图片及获得方法有哪些 06-16
- 2025盘点正规虚拟币交易平台前十-最火数字资产交易所币安app推荐 06-16
- 《歧路旅人:大陆的霸者》肥沃土壤快速获取指南 06-16
- 《交错战线》岗岩技能好用吗 06-16
- ChainCatcher 深度参与韩国加密盛会,助力 Web3 生态发展 06-16
- 安全可靠全球交易所加密货币APP排行-最安全现货交易所币安推荐 06-16