国产xxxx99真实实拍_久久不雅视频_高清韩国a级特黄毛片_嗯老师别我我受不了了小说

資訊專欄INFORMATION COLUMN

19C_ADG_數據網絡_搭建思路

IT那活兒 / 1581人閱讀
19C_ADG_數據網絡_搭建思路

點擊上方“IT那活兒”,關注后了解更多內容,不管IT什么活兒,干就完了!!!





配置數據網絡




1. 配置監聽

1.1 主庫
[root@pdg ~]# su - grid
[grid@pdg ~]$ vim /oracle/19.0.0/grid/network/admin/listener.ora
LISTENER_DG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1525))
)
)
)
SID_LIST_LISTENER_DG =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oracle/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = test)
(GLOBAL_DBNAME = test)
)
)
開啟靜態監聽(grid用戶):
lsnrctl start LISTENER_DG

lsnrctl status LISTENER_DG
1.2 備庫
LISTENER_DG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.21)(PORT = 1525))
)
)
)

SID_LIST_LISTENER_DG =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /oracle/app/oracle/product/19.0.0/dbhome_1)
(SID_NAME = test)
(GLOBAL_DBNAME = test)
)
)
開啟靜態監聽(grid用戶):
lsnrctl start LISTENER_DG

lsnrctl status LISTENER_DG
2. tns配置
2.1 主庫
[root@pdg ~]# su - oracle
[oracle@pdg ~]$ vim /oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
pdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

sdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.21)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(UR=A)
)
)
2.2 備庫
[root@sdg ~]# su – oracle
[oracle@sdg ~]$ vim /oracle/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
pdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.11)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)

sdg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.21)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
(UR=A)
)
)
2.3 測試tns
tnsping pdg
tnsping sdg


注:配置數據網絡時提前配置好第二張網卡。







主庫配置



1. 開啟歸檔
SQL> shutdown immediate;

SQL>
 startup mount;

SQL>
 alter system set log_archive_dest_1=location=+data/arch;

SQL>
 alter database archivelog;

SQL>
 alter database open;
2. 開啟強制歸檔
SQL> select name,log_mode,force_logging from v$database;
NAME LOG_MODE FORCE_LOGGING
--------- ------------ ---------------------------------------
TEST ARCHIVELOG NO
SQL>  alter database force logging;
Database altered.
SQL> select name,log_mode,force_logging from v$database;
NAME LOG_MODE FORCE_LOGGING
--------- ------------ ---------------------------------------
TEST ARCHIVELOG YES
3. 主庫添加standby日志
alter database add standby logfile group 11 +data/test/onlinelog/stb01.log size 200M;
alter database add standby logfile group 12 +data/test/onlinelog/stb02.log size 200M;
alter database add standby logfile group 13 +data/test/onlinelog/stb03.log size 200M;
alter database add standby logfile group 14 +data/test/onlinelog/stb04.log size 200M;

SQL> select group#,bytes/1024/1024 from v$standby_log;
4. 主庫修改參數
alter system set db_unique_name=test scope=spfile;
alter system set log_archive_config=dg_config=(test,sdg);
alter system set log_archive_dest_1=LOCATION=+data/arch valid_for=(all_logfiles,all_roles) db_unique_name=test;
alter system set log_archive_dest_2=service=sdg lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=sdg;
alter system set log_archive_dest_state_1=enable;
alter system set log_archive_dest_state_2=enable;
alter system set fal_client=test;
alter system set fal_server=sdg;
alter system set standby_file_management=AUTO;
alter system set db_file_name_convert=+data/test/adg,+data/test/adgscope=spfile;
alter system set log_file_name_convert=+data/test/adg,+data/test/adgscope=spfile;
5. 創建pfile,傳送pfile和密碼文件
create pfile=/oracle/app/oracle/product/19.0.0/dbhome_1/dbs/pfile.ora

scp pfile.ora oracle@192.168.168.21: /oracle/app/oracle/product/19.0.0/dbhome_1/dbs/pfile.ora

scp orapwtest oracle@192.168.168.21: /oracle/app/oracle/product/19.0.0/dbhome_1/dbs/orapwtest






備庫操作



1. 修改備庫參數
*.db_file_name_convert=+data/test,+data/test
*.db_name=test
*.db_unique_name=sdg
*.fal_client=sdg
*.fal_server=test
*.log_archive_config=dg_config=(sdg,test)
*.log_archive_dest_1=LOCATION=+data/arch valid_for=(all_logfiles,all_roles) db_unique_name=sdg
*.log_archive_dest_2=service=test lgwr sync valid_for=(online_logfile,primary_role) db_unique_name=test
*.log_archive_dest_state_1=enable
*.log_archive_dest_state_2=enable
*.log_file_name_convert=+data/test,+data/test
2. 備庫啟動到nomount狀態
SQL> startup nomount pfile=/oracle/app/oracle/product/19.0.0/dbhome_1/dbs/pfile.ora;
ORACLE instance started.
Total System Global Area 2516581464 bytes
Fixed Size 8899672 bytes
Variable Size 536870912 bytes
Database Buffers 1962934272 bytes
Redo Buffers 7876608 bytes
3. 創建與主庫相同的路徑
4. 測試聯通性
[oracle@sdg dbs]$ rman target=sys/oracle@pdg auxiliary sys/oracle@sdg
5. 同步主庫
duplicate target database for standby nofilenamecheck from active database;






啟動備庫



1. 開啟備庫
啟動日志應用:
alter database recover managed standby database disconnect from session;
取消日志應用:
recover managed standby database cancel;
開啟備庫:
alter database open;
啟動事實應用:
ALTER DATABASE recover managed standby database using current logfile disconnect;
2. 檢查備庫當前狀態
SQL> select database_role,open_mode,switchover_status from v$database;
DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS
---------------- -------------------- --------------------
PHYSICAL STANDBY READ ONLY NOT ALLOWED




本文作者:胡曉明

本文來源:IT那活兒(上海新炬王翦團隊)

文章版權歸作者所有,未經允許請勿轉載,若此文章存在違規行為,您可以聯系管理員刪除。

轉載請注明本文地址:http://specialneedsforspecialkids.com/yun/129603.html

相關文章

  • 深入理解Redis系列之單機Redis環境搭建

    摘要:序言在實際開發項目過程中如果說要用到緩存那么第一個想到的一定是但是為什么選大多數人都不會去了解也不會去思考只知道它能當緩存使用比數據庫快一點恰巧我也是這樣的一個人所以當我想寫一篇關于介紹的時候我竟然無從說起這也是對于以及主流內存數據庫不熟的 showImg(https://segmentfault.com/img/bVbi2tN?w=240&h=80); 序言 在實際開發項目過程中,...

    PrototypeZ 評論0 收藏0
  • TensorFlow實戰:Neural Style

    摘要:作者使用實現了,并將其開源放在了上。在年的兩個問題上分別取得了第一名和第二名。的獲取方式是第層,形狀為,的獲取方式是第層,形狀為。每個卷積核可以看做是圖形的一種特征抽取。相關性的描述使用余弦相似性,而余弦相似性又正比于兩種特征的點積。 showImg(https://segmentfault.com/img/bVPmNA?w=1056&h=707); Neural Style是一個非常...

    stackfing 評論0 收藏0

發表評論

0條評論

IT那活兒

|高級講師

TA的文章

閱讀更多
最新活動
閱讀需要支付1元查看
<