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>
enconvo-enconvo,AI助手,让你在任何软件中使用ChatGPT
小米路由器mesh怎么设置两个wifi信号(小米路由器mesh设置两个wifi信号方法)
小米路由器mesh组网怎么桥接(小米路由器mesh组网桥接方法)
小米路由器4q怎么用手机控制(小米路由器4q手机控制使用方法)
小米路由器4q支持5g吗怎么设置(小米路由器4q支持5g设置方法)
小米路由器4q刷机包怎么安装(小米路由器4q刷机包安装方法)