IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    flashback standby database

    小荷发表于 2016-06-15 05:42:03
    love 0

    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>


沪ICP备19023445号-2号
友情链接