久久精品人人爽,华人av在线,亚洲性视频网站,欧美专区一二三

rhel6.4

125次閱讀
沒有評論

共計 10976 個字符，預計需要花費 28 分鐘才能閱讀完成。

這篇文章主要為大家展示了“rhel6.4-11.2.0.3-RAC 如何搭建單節點 DG”，內容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓丸趣 TV 小編帶領大家一起研究并學習一下“rhel6.4-11.2.0.3-RAC 如何搭建單節點 DG”這篇文章吧。

RAC 搭建單節點備庫 ADG(active data guard)
掌握 DG 的核心思想，不管是單節點 - 單節點、RAC- 單節點還是 RAC-RAC，都差不多，本質是一樣的，come on
1、/etc/hosts RAC 和備機保持一致即可
2、修改數據庫為強制日志模式
SQL select force_logging from v$database
SQL alter database force logging
3、修改數據庫處于歸檔模式
SQL select open_mode,log_mode from v$database;
4、在主庫上修改參數文件
——————————————————————————-
Primary Database: Primary Role Initialization Parameters
——————————————————————————-
DB_NAME=chicago
DB_UNIQUE_NAME=chicago
LOG_ARCHIVE_CONFIG= DG_CONFIG=(chicago,boston)
CONTROL_FILES= /arch2/chicago/control1.ctl , /arch3/chicago/control2.ctl
LOG_ARCHIVE_DEST_1=
  LOCATION=/arch2/chicago/
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=chicago
LOG_ARCHIVE_DEST_2=
  SERVICE=boston ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=boston
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
——————————————————————————-
Primary Database: Standby Role Initialization Parameters
——————————————————————————-
FAL_SERVER=boston
DB_FILE_NAME_CONVERT= boston , chicago
LOG_FILE_NAME_CONVERT=
  /arch2/boston/ , /arch2/chicago/ , /arch3/boston/ , /arch3/chicago/
STANDBY_FILE_MANAGEMENT=AUTO
——————————————————————————-

SQL alter system set LOG_ARCHIVE_CONFIG= DG_CONFIG=(ora11g,beiku)
SQL show parameter LOG_ARCHIVE_DEST_1
SQL alter system set LOG_ARCHIVE_DEST_1= LOCATION=+data/ora11g/archivelog/ #歸檔位置可人為指定 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora11g
SQL alter system set LOG_ARCHIVE_DEST_2= SERVICE=beiku ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=beiku
SQL alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=spfile;
SQL alter system set LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=spfile;
SQL alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE scope=spfile;
SQL show parameter LOG_ARCHIVE_FORMAT  #  靜態參數, 重啟生效
SQL alter system set LOG_ARCHIVE_MAX_PROCESSES=30 scope=spfile;
———————————————————–
SQL alter system set fal_server=beiku scope=spfile;
SQL alter system set fal_client=ora11g scope=spfile;  #  fal_client 設置本身,fal_server 是對方, 檢查歸檔是否斷檔
SQL ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=SPFILE;   
SQL ALTER SYSTEM SET DB_FILE_NAME_CONVERT= +data/ora11g/ , /oracle/app/beiku/ scope =spfile;  #靜態參數，重啟生效
SQL ALTER SYSTEM SET LOG_FILE_NAME_CONVERT= +data/ora11g/ , /oracle/app/beiku/ scope =spfile;  #靜態參數，重啟生效
5、配置監聽 lisener.ora、配置網絡服務名 tnsnames.ora
通常使用 netca 來進行配置, 特殊情況手工配置
主備機相互驗證 tnsping service_names
6、將主機 $ORACLE_HOME/dbs/ 下的密碼文件 orapwORACLE_SID 傳至備機, 可以用 ssh/ftp
7、在主機 /home/oracle 下創建控制文件并且傳至備機 /home/oracle
SQL alter database create standby controlfile as /home/oracle/control01.ctl
8、在主機 /tmp 下創建初始化參數文件, 并且傳至備機 $ORACLE_HOME/dbs/ 下
SQL create pfile= /tmp/initORACLE_SID.ora from spfile;
9、修改備機初始化參數文件
——————————————————————————-
Modifying Initialization Parameters for a Physical Standby Database
——————————————————————————-
DB_NAME=chicago
DB_UNIQUE_NAME=boston
LOG_ARCHIVE_CONFIG= DG_CONFIG=(chicago,boston)
CONTROL_FILES= /arch2/boston/control1.ctl , /arch3/boston/control2.ctl
DB_FILE_NAME_CONVERT= chicago , boston
LOG_FILE_NAME_CONVERT=
  /arch2/chicago/ , /arch2/boston/ , /arch3/chicago/ , /arch3/boston/
LOG_ARCHIVE_FORMAT=log%t_%s_%r.arc
LOG_ARCHIVE_DEST_1=
  LOCATION=/arch2/boston/
  VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
  DB_UNIQUE_NAME=boston
LOG_ARCHIVE_DEST_2=
  SERVICE=chicago ASYNC
  VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
  DB_UNIQUE_NAME=chicago
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=chicago
——————————————————————————-
*.audit_file_dest= /oracle/app/admin/beiku/adump
*.audit_trail= db
*.cluster_database=false
*.compatible= 11.2.0.0.0
*.control_files= /oracle/app/beiku/control01.ctl , /oracle/app/beiku/control02.ctl
*.db_block_size=8192
*.db_domain=
*.db_name= ora11g
*.diagnostic_dest= /oracle/app
*.log_archive_max_processes=30
*.memory_target=1264582656
*.open_cursors=300
*.processes=150
*.remote_listener= node-scan:1521
*.remote_login_passwordfile= EXCLUSIVE
undo_tablespace= UNDOTBS1
DB_UNIQUE_NAME=beiku
LOG_ARCHIVE_CONFIG= DG_CONFIG=(ora11g,beiku)
DB_FILE_NAME_CONVERT= +data/ora11g/ , /oracle/app/beiku/
LOG_FILE_NAME_CONVERT= +data/ora11g/ , /oracle/app/beiku/
LOG_ARCHIVE_FORMAT=log%t_%s_%r.arc
LOG_ARCHIVE_DEST_1= LOCATION=/arch2/beiku/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=beiku
LOG_ARCHIVE_DEST_2= SERVICE=ora11g ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora11g
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=ora11g
——————————————————————————-
10、在主機做數據庫的備份集并且把備份集傳至備機 /home/oracle
[oracle@node2 ~]$ rman target /

Recovery Manager: Release 11.2.0.3.0 – Production on Fri Jul 10 15:21:21 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORA11G (DBID=4275958693)

RMAN backup database format  /home/oracle/racfull_%s_%p
11、在備機用 RMAN 做復制 STANDBY 數據庫操作
注：要用用戶名和密碼 (sys/oracle) 連接主庫和備庫
[oracle@jason ~]$ rman target sys/oracle@ora11g auxiliary sys/oracle

Recovery Manager: Release 11.2.0.3.0 – Production on Fri Jul 10 14:13:15 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORA11G (DBID=4275958693)
connected to auxiliary database: ORA11G (not mounted) #備庫啟到 nomount 階段，實例已經起來

RMAN duplicate target database for standby;

Starting Duplicate Db at 10-JUL-15
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK

contents of Memory Script:
{
  restore clone standby controlfile;
}
executing Memory Script

Starting restore at 10-JUL-15
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/racfull_8_1
channel ORA_AUX_DISK_1: piece handle=/home/oracle/racfull_8_1 tag=TAG20150710T122559
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/oracle/app/beiku/control01.ctl
output file name=/oracle/app/beiku/control02.ctl
Finished restore at 10-JUL-15

contents of Memory Script:
{
  sql clone alter database mount standby database
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
  set newname for tempfile  1 to
  /oracle/app/beiku/temp01.dbf
  switch clone tempfile all;
  set newname for datafile  1 to
  /oracle/app/beiku/system01.dbf
  set newname for datafile  2 to
  /oracle/app/beiku/sysaux01.dbf
  set newname for datafile  3 to
  /oracle/app/beiku/undotbs01.dbf
  set newname for datafile  4 to
  /oracle/app/beiku/users01.dbf
  set newname for datafile  5 to
  /oracle/app/beiku/undotbs02.dbf
  set newname for datafile  6 to
  /oracle/app/beiku/jason01.dbf
  restore
  clone database
  ;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /oracle/app/beiku/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 10-JUL-15
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /oracle/app/beiku/system01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00002 to /oracle/app/beiku/sysaux01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00003 to /oracle/app/beiku/undotbs01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /oracle/app/beiku/users01.dbf
channel ORA_AUX_DISK_1: restoring datafile 00005 to /oracle/app/beiku/undotbs02.dbf
channel ORA_AUX_DISK_1: restoring datafile 00006 to /oracle/app/beiku/jason01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/racfull_7_1
channel ORA_AUX_DISK_1: piece handle=/home/oracle/racfull_7_1 tag=TAG20150710T122559
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 10-JUL-15

contents of Memory Script:
{
  switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=10 STAMP=884700883 file name=/oracle/app/beiku/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=11 STAMP=884700883 file name=/oracle/app/beiku/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=12 STAMP=884700883 file name=/oracle/app/beiku/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=13 STAMP=884700883 file name=/oracle/app/beiku/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=14 STAMP=884700883 file name=/oracle/app/beiku/undotbs02.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=15 STAMP=884700883 file name=/oracle/app/beiku/jason01.dbf
Finished Duplicate Db at 10-JUL-15

RMAN
結束后會自動將備庫啟到 mount 狀態
SQL select instance_name,status from v$instance;

INSTANCE_NAME  STATUS
—————- ————
beiku  MOUNTED
打開備庫, 此時備庫正處在最大性能模式
SQL alter database open read only;  #11gDG 已經可以在 open 的狀態下應用歸檔

Database altered.

SQL select protection_mode,database_role,open_mode from v$database;

PROTECTION_MODE  DATABASE_ROLE  OPEN_MODE
——————– —————- ——————–
MAXIMUM PERFORMANCE  PHYSICAL STANDBY READ ONLY

SQL alter database recover managed standby database disconnect from session;

Database altered.

SQL select sequence#,thread#,applied from v$archived_log;  #在主庫雙節點分別切換日志 alter system switch logfile, 在備庫顯示如下,DG 已運行正常

 SEQUENCE#  THREAD# APPLIED
———- ———- ———
  121  1 YES
  119  1 YES
  120  1 YES
  118  1 YES
  122  1 YES
  151  2 YES
  149  2 YES
  150  2 YES
  152  2 YES
  153  2 YES
  154  2 YES

 SEQUENCE#  THREAD# APPLIED
———- ———- ———
  155  2 YES
  156  2 YES
  157  2 YES
  123  1 YES
  158  2 YES
  159  2 YES
  160  2 YES
  161  2 YES
  162  2 YES
  163  2 YES
  164  2 YES

 SEQUENCE#  THREAD# APPLIED
———- ———- ———
  124  1 YES
  125  1 YES
  126  1 YES
  165  2 YES
  127  1 YES
  128  1 YES
12、配置 DG 為最大可用模式
在備庫要創建 STANDBY REDO LOGFILE
SQL select group#,member from v$logfile;

  GROUP# MEMBER
———- ————————————————–
  2 /oracle/app/beiku/redo02.log
  1 /oracle/app/beiku/redo01.log
  3 /oracle/app/beiku/redo03.log
  4 /oracle/app/beiku/redo04.log
SQL alter database add standby logfile group 5 (/oracle/app/beiku/standby_redo05.log)  size 50m;
SQL alter database add standby logfile group 6 (/oracle/app/beiku/standby_redo06.log)  size 50m;
SQL alter database add standby logfile group 7 (/oracle/app/beiku/standby_redo07.log)  size 50m;
SQL alter database add standby logfile group 8 (/oracle/app/beiku/standby_redo08.log)  size 50m;
SQL alter database add standby logfile group 9 (/oracle/app/beiku/standby_redo09.log)  size 50m;
SQL alter database set standbydatabase to maximize availability;
SQL alter database recover managedstandby database using current logfile disconnect from session;  #啟動實時恢復
SQL alter database recover managed standby database cancel;

以上是“rhel6.4-11.2.0.3-RAC 如何搭建單節點 DG”這篇文章的所有內容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內容對大家有所幫助，如果還想學習更多知識，歡迎關注丸趣 TV 行業資訊頻道！

正文完
發表至： 數據庫
2023-07-19
 
丸趣
版權聲明：本站原創文章，由 丸趣 2023-07-19發表，共計10976字。
轉載說明：除特殊說明外本站除技術相關以外文章皆由網絡搜集發布，轉載請注明出處。
評論（沒有評論）
主站蜘蛛池模板： 崇信县| 宁蒗| 长武县| 高邮市| 高邑县| 鲁山县| 松滋市| 闽清县| 海阳市| 洪泽县| 绿春县| 固镇县| 凤城市| 红安县| 乌海市| 商洛市| 吴江市| 黄梅县| 惠东县| 大理市| 长乐市| 安阳县| 高密市| 花垣县| 咸丰县| 普定县| 旬邑县| 正安县| 汶上县| 揭东县| 丹阳市| 家居| 榆林市| 罗江县| 松溪县| 台北市| 信宜市| 梁河县| 耿马| 商城县| 赞皇县|