DG查詢/切換的相關(guān)命令

 查看數(shù)據(jù)庫可進(jìn)行的角色轉(zhuǎn)換

創(chuàng)新互聯(lián)專注于企業(yè)成都全網(wǎng)營銷推廣、網(wǎng)站重做改版、平武網(wǎng)站定制設(shè)計(jì)、自適應(yīng)品牌網(wǎng)站建設(shè)、HTML5建站、商城建設(shè)、集團(tuán)公司官網(wǎng)建設(shè)、外貿(mào)網(wǎng)站制作、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁設(shè)計(jì)等建站業(yè)務(wù)，價(jià)格優(yōu)惠性價(jià)比高，為平武等各大城市提供網(wǎng)站開發(fā)制作服務(wù)。

1.    $sqlplus / as sysdba

2.    SQL> select switchover_status from gv$database;

查詢主備庫同步情況

3.    select unique thread# as thread,max(sequence#) over(partition by thread#) as last from gv$archived_log;

4.    select thread# ,low_sequence#,high_sequence# from gv$archive_gap;

將主庫切換為備庫

5.    alter database commit to switchover to physical standby with session shutdown ;

6.     select switchover_status from gv$database;

將備庫切換為主庫

7.    select open_mode from gv$database;

8.    select switchover_status from gv$database;

9.    select unique thread# as thread,max(sequence#) over(partition by thread#) as last from gv$archived_log;

10   $ srvctl stop instance –i ebiz2 –d ebizsh

11.SQL> alter database commit to switchover to primary with

session shutdown ;

12. alter database open;

13. $ srvctl start instance –i ebiz2 –d ebizsh

原主庫轉(zhuǎn)備庫后開始應(yīng)用日志

14. SQL> alter database recover managed  standby database using current logfile disconnect from session;

15. $ srvctl start instance -d ebiz -i ebiz2

16. SQL> select open_mode from gv$database;

（7） Oracle登錄數(shù)據(jù)庫服務(wù)器，原同城備庫需要在黑龍江和上海主備切換后重新啟動日志應(yīng)用

17. SQL> alter database recover managed  standby database

using current logfile disconnect from session;

18.  SQL> select status from v$managed_standby where

process like 'MRP%';

只DG 查詢/切換的相關(guān)命令啟動數(shù)據(jù)庫節(jié)點(diǎn)1實(shí)例

19.  $ srvctl start instance –i ebiz1 –d ebiz

20.  $ srvctl stop instance –i ebiz2 –d ebiz

繼續(xù)進(jìn)行redo apply

21. SQL> alter database recover managed standby database

using current logfile disconnect;

直至日志同步完畢,SCN號不變，同時(shí)檢查 gv$archived_log視圖，序列號達(dá)到源端最大值

22.  SQL> select  current_scn from  gv$database;

23. SQL>select unique thread# as thread,max(sequence#)

over(partition by thread#) as last from gv$archived_log;

24.  $asmcmd

25. Cp +DATA_DG/ebiz/archivelog/YYYYMMDD/XXXX 

/rman/backup/ --拷貝至文件系統(tǒng)

ftp或scp至上海

注冊歸檔日志文件

26. SQL >  ALTER DATABASE REGISTER PHYSICAL LOGFILE

'XXXX';

27. Database altered.

然后進(jìn)行redo apply

28. SQL> alter database recover managed standby database using current logfile disconnect;

29. SQL> alter database commit to switchover to primary with

session shutdown ;

30. SQL> alter database open; SQL> select open_mode from

gv$database;

31.  SQL>  select switchover_status from gv$database;

32. $ srvctl start instance –i ebiz2 –d ebizsh


分享名稱：DG查詢/切換的相關(guān)命令
轉(zhuǎn)載來源：http://bm7419.com/article14/jdsdde.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供做網(wǎng)站、企業(yè)網(wǎng)站制作、營銷型網(wǎng)站建設(shè)、網(wǎng)站策劃、Google、網(wǎng)頁設(shè)計(jì)公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)

手機(jī)網(wǎng)站建設(shè)