欧美一级特黄大片做受成人-亚洲成人一区二区电影-激情熟女一区二区三区-日韩专区欧美专区国产专区

Oracle12CRac到Rac搭建ADG

1、環(huán)境介紹
搭建一套ADG災(zāi)備環(huán)境。主庫環(huán)境為12.1.2.0 RAC，備庫同主庫，軟件補(bǔ)丁均已安裝。
2、配置步驟
2.1 歸檔

讓客戶滿意是我們工作的目標(biāo)，不斷超越客戶的期望值來自于我們對這個行業(yè)的熱愛。我們立志把好的技術(shù)通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領(lǐng)域值得信任、有價值的長期合作伙伴，公司提供的服務(wù)項目有：域名與空間、網(wǎng)頁空間、營銷軟件、網(wǎng)站建設(shè)、烏海網(wǎng)站維護(hù)、網(wǎng)站推廣。

 select log_mode from v$database;  #####是否為歸檔模式
 alter database force logging;           #####強(qiáng)制歸檔

2.2 主庫standby log

alter database add standby logfile thread 1 group 5  ('+DATADG') size 2048M;
alter database add standby logfile thread 1 group 6  ('+DATADG') size 2048M;
alter database add standby logfile thread 1 group 7  ('+DATADG') size 2048M;
alter database add standby logfile thread 1 group 8  ('+DATADG') size 2048M;
alter database add standby logfile thread 1 group 9  ('+DATADG') size 2048M;
alter database add standby logfile thread 1 group 10 ('+DATADG') size 2048M;
alter database add standby logfile thread 2 group 11    ('+DATADG') size 2048M;
alter database add standby logfile thread 2 group 12    ('+DATADG') size 2048M;
alter database add standby logfile thread 2 group 13    ('+DATADG') size 2048M;
alter database add standby logfile thread 2 group 14    ('+DATADG') size 2048M;
alter database add standby logfile thread 2 group 15    ('+DATADG') size 2048M;
alter database add standby logfile thread 2 group 16    ('+DATADG') size 2048M;

3、文件
3.1 密碼文件

拷貝主庫密碼文件到備庫，最開始放在$ORACLE_HOME/dbs目錄下，后續(xù)配置完成后，需要將密碼文件存放在ASM磁盤組中并進(jìn)行改名。
 scp orapwbmacdb IP: $ORACLE_HOME/dbs1
 ASMCMD> pwcopy /u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwbmacdb1 +datadg/bmacdbdg/password/orapwbmacdb
copying /u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwbmacdb1 -> +datadg/bmacdbdg/password/orapwbmacdb

3.2 參數(shù)文件

拷貝主庫參數(shù)文件到備庫，放在$ORACLE_HOME/dbs目錄下，恢復(fù)完成后，需要將參數(shù)文件存放在ASM磁盤組中，并通過pfile指定其位置。參數(shù)文件內(nèi)容如下：
*.audit_file_dest='/u01/app/oracle/admin/bmacdb/adump'
*.control_files='+DATADG/BMACDB/control01.ctl','+DATADG/BMACDB/control02.ctl'
*.db_file_name_convert='+DATADG/BMACDB/DATAFILE/','+DATADG/BMACDB/DATAFILE/','+SSDDG/BMACDB/DATAFILE/','+DATADG/BMACDB/DATAFILE/','+DATADG/bmacdb/','+DATADG/BMACDB/DATAFILE/'
*.db_unique_name='bmacdbdg'
*.log_archive_config='DG_CONFIG=(bmacdb,bmacdbdg)'
*.log_archive_dest_1='LOCATION=+ARCHDG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bmacdbdg'
*.log_archive_dest_2='SERVICE=BMACDB1 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=BMACDB'
*.log_file_name_convert='+SSDDG/bmacdb/','+LOGDG/BMACDB/ONLINELOG/'
*.fal_server='BMACDB'
以上參數(shù)時我們需要修改的地方。

3.3 目錄結(jié)構(gòu)

mkdir -p /u01/app/oracle/admin/bmacdb/adump
ASM：
+DATADG/BMACDB/DATAFILE
+LOGDG/BMACDB/ONLINELOG
創(chuàng)建完目錄結(jié)構(gòu)后，啟動數(shù)據(jù)庫到nomount狀態(tài)。
startup nomount

3.4 配置監(jiān)聽

在配置ADG開始階段，需要在備庫靜態(tài)注冊監(jiān)聽，搭建完成后，可以將靜態(tài)注冊信息刪掉。靜態(tài)注冊信息如下：/u01/app/12.1.0/grid/network/admin/listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = bmacdbdg)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
      (SID_NAME = bmacdb1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
    )
  )
配置完監(jiān)聽后啟動監(jiān)聽，靜態(tài)監(jiān)聽信息如下：
Service "bmacdbdg" has 1 instance(s).
  Instance "bmacdb1", status UNKNOWN, has 1 handler(s) for this service...
主庫連接串配置
主庫tnsnames.ora新增到備庫的連接串，并且在RAC兩個節(jié)點同時新增：
BMACDBDG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bmacdbdg)
    )
  )
配置完成后，進(jìn)行連通性測試：
sqlplus sys/password@BMACDBDG as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 18 14:28:16 2019
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

備庫連接串配置
備庫tnsnames.ora新增到主庫的連接串，并且在RAC兩個節(jié)點同時新增：
BMACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = bmacdb)
    )
  )
配置完成后，進(jìn)行連通性測試：
sqlplus sys/password@BMACDB as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jun 18 14:29:29 2019
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

4、恢復(fù)備庫

source /home/oracle/.profile 
rman target sys/password@BMACDB auxiliary sys/password@BMACDBDG <<EOF
run
{
allocate channel cl1 type disk;
allocate auxiliary channel c1 type disk;
duplicate target database for standby from active database nofilenamecheck;
release channel c1;
release channel cl1;
}
EOF
給腳本授予執(zhí)行權(quán)限并執(zhí)行腳本：
chmod +x dg.sh
nohup ./dg.sh &

5、修改主庫參數(shù)

alter system set log_archive_config='dg_config=(bmacdb,bmacadg,bmacdg,bmacdbdg)';
alter system set log_archive_dest_4='service=BMACDBDG async valid_for=(online_logfiles,primary_role) db_unique_name=bmacdbdg';

6、備庫spfile

SQL> create spfile ='+datadg/bmacdbdg/spfilebmacdb.ora' from pfile;

File created.
oracle@bmacdrdb1:/home/oracle>cd $ORACLE_HOME/dbs
oracle@bmacdrdb1:/u01/app/oracle/product/12.1.0/dbhome_1/dbs>cat initbmacdb1.ora
spfile ='+datadg/bmacdbdg/spfilebmacdb.ora'

7、備庫RAC添加資源

srvctl add database -db bmacdbdg -dbname bmacdb -oraclehome /u01/app/oracle/product/12.1.0/dbhome_1 -dbtype RAC -role PHYSICAL_STANDBY
srvctl add instance -db bmacdbdg -instance bmacdb1 -node bmacdrdb1 
srvctl add instance -db bmacdbdg -instance bmacdb2 -node bmacdrdb2 
srvctl modify database -db bmacdbdg -spfile '+datadg/bmacdbdg/spfilebmacdb.ora' -pwfile '+datadg/bmacdbdg/password/orapwbmacdb'
srvctl modify database -db bmacdbdg -diskgroup DATADG,LOGDG
備庫配置信息：
oracle@bmacdrdb1:/home/oracle>srvctl config database -d bmacdbdg
Database unique name: bmacdbdg
Database name: bmacdb
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +datadg/bmacdbdg/spfilebmacdb.ora
Password file: +datadg/bmacdbdg/password/orapwbmacdb
Domain: 
Start options: open
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATADG,LOGDG
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: oper
Database instances: bmacdb1,bmacdb2
Configured nodes: bmacdrdb1,bmacdrdb2
Database is administrator managed

8、應(yīng)用日志

alter database recover managed standby database disconnect from session;
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect;
select open_Mode,DATABASE_ROLE from v$database;

OPEN_MODE            DATABASE_ROLE
-------------------- ----------------
READ ONLY WITH APPLY PHYSICAL STANDBY

網(wǎng)站標(biāo)題：Oracle12CRac到Rac搭建ADG
當(dāng)前網(wǎng)址：http://aaarwkj.com/article18/isgedp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站建設(shè)、品牌網(wǎng)站設(shè)計、品牌網(wǎng)站制作、網(wǎng)站設(shè)計、移動網(wǎng)站建設(shè)、網(wǎng)頁設(shè)計公司

廣告

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

成都定制網(wǎng)站建設(shè)
午夜性色福利在线播放| 中文字幕丝袜精品久久| 中文字幕二区三区av| 丰满人妻中出av在线| 最新日韩精品电影在线网| 亚洲欧美午夜不卡视频| 成人午夜福利影院在线| 中文字幕在线看二区不卡| 高清一区二区三区不卡视频| 亚洲成人自拍视频在线观看| 99久久中文字幕伊人| 成年人免费在线观看毛片| 午夜丁香婷婷爽少妇av| 日本高清视频免费一区| 亚洲国产精品有码专区| 加勒比在线观看欧美一区| 白白色成人在线免费视频| 最新天堂av资源在线观看| 国产三级一区二区不卡| 国产伦人偷精品免费视频| 四虎精品视频在线免费| 麻豆av久久一区二区| 免费看真人性生活视频| 欧美伊人色综合久久天天| 国产自愉自愉免费精品七| 午夜激情视频在线网站| 久久九九亚洲欧美中文字幕| 色呦呦视频在线免费看| 精品少妇一区二区三区| 国产精品深夜在线观看| 午夜最新福利在线视频| 视频一区视频二区在线| 国产乱子一区二区三区| 日韩美女后入式在线视频| 黄片在线免费观看欧美中文| 久草免费人妻视频在线| 国产精品日韩av一区二区| 日韩精品第一区第二区| 免费在线观看做性小视频| 日本成人午夜电影网站| 精品久久一区麻豆香蕉|