ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > oracle 9i 搭建DG

oracle 9i 搭建DG

原创 Oracle 作者：xiaowuhexiaoli 时间：2021-12-27 10:43:27 0 删除 编辑

oracle 9i 搭建DG

ORACLE_SID=ora9ibpm
ORACLE_BASE=/opt/orcl9i
ORACLE_HOME=/opt/orcl9i/product/9.2.4

有原來備庫存在，可以只拷貝原來備庫的數據文件和archivelog到相同目錄下，在主庫生成控制文件pfile密碼文件拷貝到現備庫，直接將數據庫啟到nomount狀態，再生成spfile，啟到mount，開服務即可。

備庫
[oracle@twwfdg admin]$ cat listener.ora
# LISTENER.ORA Network Configuration File: /opt/orcl9i/product/9.2.4/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/orcl9i/product/9.2.4)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora9ibpm)
      (ORACLE_HOME = /opt/orcl9i/product/9.2.4)
      (SID_NAME = ora9ibpm)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.123)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )

[oracle@localhost admin]$ cat tnsnames.ora
ORA9STD166=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.166)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora9ibpm)
    )
  )

ORA9PRI=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.147)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ora9ibpm)
    )
  )

[oracle@localhost admin]$ tnsping ORA9STD166
[oracle@localhost admin]$ tnsping ORA9PRI

主庫註冊監聽
SQL> alter system register;

*********
主庫：
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO' scope=both;
ALTER SYSTEM SET fal_server='ORA9STD166' scope=both;
ALTER SYSTEM SET fal_client='ORA9PRI' scope=both;
ALTER SYSTEM SET log_archive_dest_1='location=/arch' scope=both;
ALTER SYSTEM SET log_archive_dest_2='SERVICE=ORA9STD166 REOPEN=60' scope=both;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1='ENABLE' scope=both;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2='ENABLE' scope=both;
ALTER SYSTEM SET standby_archive_dest='LOCATION=/opt/oradata/arch' scope=both;
************

主庫：
ALTER SYSTEM SET fal_server='ORA9STD166' scope=both;
ALTER SYSTEM SET log_archive_dest_2='SERVICE=ORA9STD166 REOPEN=60' scope=both;

ALTER SYSTEM SET fal_server='ORA9STD1' scope=both;
ALTER SYSTEM SET log_archive_dest_2='SERVICE=ORA9STD REOPEN=60' scope=both;

SQL> alter system set log_archive_dest_state_2=defer;
SQL> alter system set log_archive_dest_state_2=enable;

備庫：
ALTER SYSTEM SET fal_server='ORA9PRI' scope=both;
ALTER SYSTEM SET fal_client='ORA9STD166' scope=both;
ALTER SYSTEM SET log_archive_dest_2='SERVICE=ORA9PRI REOPEN=60' scope=both;
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2='defer' scope=both;

*.fal_server='ORA9PRI'    
*.fal_client='ORA9STD166'
*.log_archive_dest_1='LOCATION=/opt/oradata/arch'
*.log_archive_dest_2='SERVICE=ORA9PRI REOPEN=60'
*.standby_archive_dest='LOCATION=/opt/oradata/arch'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='DEFER'

主庫
alter database create standby controlfile as '/opt/control01.ctl' reuse;
[oracle@BPMTESTDB opt]$ scp control01.ctl oracle@10.39.7.166:/opt/orcl9i/oradata/ora9ibpm

orapwd file='/opt/orcl9i/product/9.2.4/dbs/orapwora9ibpm' password=ora9ibpm_8# entries=10 force=y
orapwd file=/opt/orcl9i/product/9.2.4/dbs/orapw$ORACLE_SID password=ora9ibpm_8# entries=5


原備庫，拷貝原來備庫的數據文件以及archivelog到相同目錄下
[oracle@twwfdg ora9ibpm]$ scp * oracle@10.39.7.166:/opt/orcl9i/oradata/ora9ibpm
[oracle@twwfdg arch]$ scp * oracle@10.39.7.166:/opt/oradata/arch

備庫
startup nomount pfile='$ORACLE_HOME/dbs/initora9ibpm.ora';         initECARDCKZ.ora  **備庫***
CREATE SPFILE FROM PFILE='$ORACLE_HOME/dbs/initora9ibpm.ora';
 
特殊的9i版本：SQL> startup nomount;
              SQL> alter database mount standby database;
              
              
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 ('/opt/orcl9i/oradata/ora9ibpm/redo06.log') SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 ('/opt/orcl9i/oradata/ora9ibpm/redo07.log') SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 8 ('/opt/orcl9i/oradata/ora9ibpm/redo08.log') SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 9 ('/opt/orcl9i/oradata/ora9ibpm/redo09.log') SIZE 100M;
ALTER DATABASE ADD STANDBY LOGFILE GROUP 10 ('/opt/orcl9i/oradata/ora9ibpm/redo10.log') SIZE 100M;


9i DG參數配置示例：
主庫10.39.7.147
備庫10.39.7.123

備庫
[oracle@twwfdg admin]$ cat listener.ora
# LISTENER.ORA Network Configuration File: /opt/orcl9i/product/9.2.4/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/orcl9i/product/9.2.4)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora9ibpm)
      (ORACLE_HOME = /opt/orcl9i/product/9.2.4)
      (SID_NAME = ora9ibpm)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.123)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
  )

[oracle@twwfdg admin]$ cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /opt/orcl9i/product/9.2.4/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORA9PRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.147)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora9ibpm)
    )
  )

ORA9STD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.123)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora9ibpm)
    )
  )

 
[oracle@twwfdg dbs]$ cat initora9ibpm.ora
*.background_dump_dest='/opt/orcl9i/admin/ora9ibpm/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/orcl9i/oradata/ora9ibpm/control01.ctl','/opt/orcl9i/oradata/ora9ibpm/control02.ctl','/opt/orcl9i/oradata/ora9ibpm/control03.ctl'
*.core_dump_dest='/opt/orcl9i/admin/ora9ibpm/cdump'
*.db_block_size=8192
*.db_cache_size=6442450944
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/opt/orcl9i/oradata/ora9ibpm','/opt/orcl9i/oradata/ora9ibpm'
*.db_name='ora9ibpm'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora9ibpmXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='ora9ibpm'
*.java_pool_size=115343360
*.job_queue_processes=0
*.large_pool_size=134217728
*.log_archive_dest_1='LOCATION=/opt/oradata/arch'
*.log_archive_dest_2=''
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='DEFER'
*.log_archive_start=TRUE
*.open_cursors=1000
*.open_links=20
*.open_links_per_instance=20
*.pga_aggregate_target=3221225472
*.processes=4000
*.query_rewrite_enabled='FALSE'
*.remote_archive_enable='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=838860800
*.sort_area_size=1048576
*.standby_archive_dest='LOCATION=/opt/oradata/arch'
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=21600
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/orcl9i/admin/ora9ibpm/udump'
*.UTL_FILE_DIR='/opt/logminer'


SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/opt/orcl9i/oradata/ora9ibpm/system01.dbf

SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/opt/orcl9i/oradata/ora9ibpm/redo01.log
/opt/orcl9i/oradata/ora9ibpm/redo02.log
/opt/orcl9i/oradata/ora9ibpm/redo03.log
/opt/orcl9i/oradata/ora9ibpm/redo04.log
/opt/orcl9i/oradata/ora9ibpm/redo04B.log
/opt/orcl9i/oradata/ora9ibpm/redo05.log
/opt/orcl9i/oradata/ora9ibpm/redo05B.log
/opt/orcl9i/oradata/ora9ibpm/redo01B.log
/opt/orcl9i/oradata/ora9ibpm/redo02B.log
/opt/orcl9i/oradata/ora9ibpm/redo03B.log



主庫

[oracle@BPMTESTDB admin]$ cat listener.ora
# LISTENER.ORA Network Configuration File: /opt/orcl9i/product/9.2.4/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/orcl9i/product/9.2.4)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ora9ibpm)
      (ORACLE_HOME = /opt/orcl9i/product/9.2.4)
      (SID_NAME = ora9ibpm)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.39.7.147)(PORT = 1521))
    )
  )

[oracle@BPMTESTDB dbs]$ cat initora9ibpm.ora
*.audit_trail='DB'
*.background_dump_dest='/opt/orcl9i/admin/ora9ibpm/bdump'
*.compatible='9.2.0.0.0'
*.control_file_record_keep_time=31
*.control_files='/opt/orcl9i/oradata/ora9ibpm/control01.ctl','/opt/orcl9i/oradata/ora9ibpm/control02.ctl','/opt/orcl9i/oradata/ora9ibpm/control03.ctl'
*.core_dump_dest='/opt/orcl9i/admin/ora9ibpm/cdump'
*.db_block_size=8192
*.db_cache_size=6442450944
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_file_name_convert='/opt/orcl9i/oradata/ora9ibpm','/opt/orcl9i/oradata/ora9ibpm'
*.db_name='ora9ibpm'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora9ibpmXDB)'
*.fal_client='ORA9PRI'
*.fal_server='ORA9STD'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='ora9ibpm'
*.java_pool_size=115343360
*.job_queue_processes=20
*.large_pool_size=134217728
*.log_archive_dest_1='location=/arch'
*.log_archive_dest_2='SERVICE=ORA9STD REOPEN=60'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=TRUE
*.open_cursors=1000
*.open_links=20
*.open_links_per_instance=20
*.pga_aggregate_target=3221225472
*.processes=4000
*.query_rewrite_enabled='FALSE'
*.remote_archive_enable='TRUE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=838860800
*.sort_area_size=1048576
*.standby_archive_dest='/opt/orcl9i/arch'
*.standby_file_management='AUTO'
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=21600
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/opt/orcl9i/admin/ora9ibpm/udump'
*.utl_file_dir='/iscsi/logminer'

刪除日誌腳本
30 07 * * *     /bin/sh /opt/orcl9i/scripts/arcive_del.sh

[oracle@twwfdg arch]$ cat  /opt/orcl9i/scripts/arcive_del.sh
#!/bin/bash

ORACLE_SID=ora9ibpm; export ORACLE_SID
ORACLE_BASE=/opt/orcl9i; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/9.2.4; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=$PATH:$ORACLE_HOME/bin:/usr/sbin; export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib; export LD_LIBRARY_PATH
del_time=`date +%F`;

$ORACLE_HOME/bin/rman target / log /opt/orcl9i/scripts/log/del_$del_time.log <<EOF
run {
crosscheck archivelog all;
delete noprompt archivelog all completed before 'sysdate-2';
}
exit
EOF


[oracle@BPMTESTDB 9.2.4]$ cat /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
ONBOOT=yes
BOOTPROTO=none
IPADDR=10.39.7.147
NETMASK=255.255.248.0
GATEWAY=10.39.1.1
TYPE=Ethernet
USERCTL=no
IPV6INIT=no
PEERDNS=yes


[oracle@localhost ~]$ cat /etc/sysconfig/network-scripts/ifcfg-eth0
TYPE=ethernet
NM_CONTROLLED=no
DEVICE=eth0
BOOTPROTO=static
DEFROUTE=YES
ZONE=public
ONBOOT=yes
IPADDR=10.39.7.166
NETMASK=255.255.248.0
GATEWAY=10.39.1.1


[oracle@twwfdg ~]$ cat /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=static
HWADDR=00:50:56:89:21:11
ONBOOT=yes
TYPE=Ethernet
IPADDR=10.39.7.123
NETMASK=255.255.248.0
GATEWAY=10.39.1.1


来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/69978530/viewspace-2849453/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： oracle DG案例测试
下一篇： 备库删除日志脚本
请登录后发表评论 登录
全部评论
xiaowuhexiaoli

注册时间：2020-07-06

  • 博文量
    14
  • 访问量
    14544

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593