激情五月天婷婷,亚洲愉拍一区二区三区,日韩视频一区,a√天堂中文官网8

<ul id="buwfs"><strike id="buwfs"><strong id="buwfs"></strong></strike></ul>
    <output id="buwfs"></output>
  • <dfn id="buwfs"><source id="buwfs"></source></dfn>
      <dfn id="buwfs"><td id="buwfs"></td></dfn>
      <div id="buwfs"><small id="buwfs"></small></div>
      <dfn id="buwfs"><source id="buwfs"></source></dfn>
      1. <dfn id="buwfs"><td id="buwfs"></td></dfn>
        始創(chuàng)于2000年 股票代碼:831685
        咨詢熱線:0371-60135900 注冊有禮 登錄
        • 掛牌上市企業(yè)
        • 60秒人工響應(yīng)
        • 99.99%連通率
        • 7*24h人工
        • 故障100倍補(bǔ)償
        全部產(chǎn)品
        您的位置: 網(wǎng)站首頁 > 幫助中心>文章內(nèi)容

        配置Oracle 11g R2 Datagurad出現(xiàn)ORA-10458錯誤

        發(fā)布時間:  2012/8/27 17:18:41

        備庫:
        SQL> alter database open read only;
        alter database open read only
        *
        ERROR at line 1:
        ORA-10458: standby database requires recovery
        ORA-01152: file 1 was not restored from a sufficiently old backup
        -
         

        ORA-01110: data file 1: '/u01/app/Oracle/oradata/bhoms/system01.dbf'


        查看備庫:
        SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

        SWITCHOVER_STATUS
        --------------------
        TO PRIMARY


        查看主庫:
        SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

        SWITCHOVER_STATUS
        --------------------
        NOT ALLOWED

        再次查看主庫的參數(shù):
        SQL> show parameter LOG_ARCHIVE_DEST_2

        NAME                                 TYPE        VALUE
        ------------------------------------ ----------- ------------------------------
        log_archive_dest_2                   string      service=standby lgwr async noa
                                                         ffirm
        原來這里設(shè)置錯誤:
        SQL> alter system set log_archive_dest_2='service=bhoms02 async valid_for=(online_logfiles,primary_role) db_unique_name=bhoms02';

        再查主庫:
        SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;

        SWITCHOVER_STATUS
        --------------------
        TO STANDBY

        查看備庫:
        SQL> show parameter LOG_ARCHIVE_DEST_2

        NAME                                 TYPE        VALUE
        ------------------------------------ ----------- ------------------------------
        log_archive_dest_2                   string      service=standby lgwr async noa
                                                         ffirm
        原來這里設(shè)置錯誤:
        SQL> alter system set log_archive_dest_2='service=bhoms01 async valid_for=(online_logfiles,primary_role) db_unique_name=bhoms01';

        重啟備庫,解決問題:
        SQL> shutdown immediate;
        ORA-01109: database not open

        Database dismounted.
        Oracle instance shut down.
        SQL> startup nomount
        Oracle instance started.

        Total System Global Area 6747725824 bytes
        Fixed Size                  2213976 bytes
        Variable Size            5100275624 bytes
        Database Buffers         1610612736 bytes
        Redo Buffers               34623488 bytes
        SQL> alter database mount standby database;

        Database altered.

        SQL> alter database open read only;

        Database altered.

        SQL> alter database recover managed standby database disconnect from session;

        Database altered.


        本文出自:億恩科技【mszdt.com】

        服務(wù)器租用/服務(wù)器托管中國五強(qiáng)!虛擬主機(jī)域名注冊頂級提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM]

      2. 您可能在找
      3. 億恩北京公司:
      4. 經(jīng)營性ICP/ISP證:京B2-20150015
      5. 億恩鄭州公司:
      6. 經(jīng)營性ICP/ISP/IDC證:豫B1.B2-20060070
      7. 億恩南昌公司:
      8. 經(jīng)營性ICP/ISP證:贛B2-20080012
      9. 服務(wù)器/云主機(jī) 24小時售后服務(wù)電話:0371-60135900
      10. 虛擬主機(jī)/智能建站 24小時售后服務(wù)電話:0371-60135900
      11. 專注服務(wù)器托管17年
        掃掃關(guān)注-微信公眾號
        0371-60135900
        Copyright© 1999-2019 ENKJ All Rights Reserved 億恩科技 版權(quán)所有  地址:鄭州市高新區(qū)翠竹街1號總部企業(yè)基地億恩大廈  法律顧問:河南亞太人律師事務(wù)所郝建鋒、杜慧月律師   京公網(wǎng)安備41019702002023號
          0
         
         
         
         

        0371-60135900
        7*24小時客服服務(wù)熱線