一聚教程网:一个值得你收藏的教程网站

热门教程

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>

热门栏目