dataguard的启动与关闭

来源:互联网 发布:圆方软件视频教程 编辑:程序博客网 时间:2024/05/18 03:23
DG dataguard启动关闭顺序
 启动 (1)启动监听
        先启从库再起主库
        #lsnrctl start
       2)启动数据库
          先启从库:
         sql>startup nomount
         sql>alter database mount standby database;
         sql>alter database recover managed standby database using current logfile disconnect from session;
          在启主库
         sql>startup
   
   如果是ACTIVE STANDBY DATABASE 则
     备库:#lsnrctl start
      sql>startup nomount
  sql>alter database mount standby database;
  sql>alter database open;
  sql>alter database recover managed standby database using current logfile disconnect from session;
   在启主库
           sql>startup   
      
关闭:和开启正好相反
     先关主库数据库:
    sql>shutdown immediate
    再关从库:
    sql>alter database recover managed standby database cancel;
    sql>shutdown immediate;
0 0