oracle 9i 搭建DG

来源：这里教程网时间：2026-03-03 17:21:19 作者：

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

编辑推荐：

返回列表

oracle 9i 搭建DG

编辑推荐：

相关推荐

excel表格怎样在数字前输入0

excel表格里怎么替换数据

excel表格里面如何插入圆形

excel表格里怎么添加表格数据透视表

excel表格中怎么添加线边框

excel表格里怎样设置条件自动排序

excel表格例怎样导入数据库

Excel表格如何设置数据排序

excel表格里怎么选择性粘贴快捷键

excel表格怎么插入分隔符号

excel表格怎么设置多行多列数据内容排序

Excel表格如何设置行和列相互转换

excel表格连接公式怎么使用

excel表格怎样链接到cad中

雷神推出 MIX PRO II 迷你主机：基于 Ultra 200H，玻璃上盖 + ARGB 灯效

制造商 Musnap 推出彩色墨水屏电纸书 Ocean C：支持手写笔、第三方安卓应用

最新软件资讯

热文推荐

天极热推