用户和密码：

root/bayaim

bayaim/064286BAIbay

oracle/oracle

SID:orcl

sys/oracle

system/oracle

mpay/mpay

dx/dx

---------------------------------------------

linux #安装环境

export LANG=en_US

systemctl stop firewalld.service （停止防火墙，这是CentOS7的命令）

systemctl restart network //重启网卡-----------

vi /etc/yum.repos.d/rhel-source.repo

mount /dev/cdrom /mnt

 

cd /etc/sysconfig/network-scripts

[root@wwdb2 network-scripts]# cp ifcfg-eth0 ifcfg-eth0.bak

[root@wwdb2 network-scripts]# vi ifcfg-eth0.bak

把 HWADDR 删除掉，然后改一下 IPADDR

HWADDR=78:2B:CB:4A:15:93

[root@wwdb2 network-scripts]# mv ifcfg-eth0.bak ifcfg-eth0

mv: overwrite `ifcfg-eth0'? y

[root@wwdb2 network-scripts]# service network restart

[root@wwdb2 ~]# ifconfig

eth0 Link encap:Ethernet HWaddr 78:2B:CB:4A:15:93

inet addr:10.10.10.14 Bcast:10.10.10.255 Mask:255.255.255.0

inet6 addr: fe80::7a2b:cbff:fe4a:1593/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:397 errors:0 dropped:0 overruns:0 frame:0

TX packets:223 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:50334 (49.1 KiB) TX bytes:28565 (27.8 KiB)

Interrupt:114 Memory:d6000000-d6012800

lo Link encap:Local Loopback

inet addr:127.0.0.1 Mask:255.0.0.0

inet6 addr: ::1/128 Scope:Host

UP LOOPBACK RUNNING MTU:16436 Metric:1

RX packets:572939 errors:0 dropped:0 overruns:0 frame:0

TX packets:572939 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:215517488 (205.5 MiB) TX bytes:215517488 (205.5 MiB)

-----------------------------------------------------------

[root@localhost bai]# vi /etc/hosts

添加：

10.20.100.21 bay214

10.20.100.22 bay224

[root@wwdb2 ~]# vi /etc/sysconfig/network

NETWORKING=yes

NETWORKING_IPV6=no

HOSTNAME=wwdb2

[root@localhost bai]# hostname prodb

[root@localhost bai]# hostname

prodb

[root@localhost bai]# cat /etc/hostname

pordb

[root@localhost network-scripts]# cd /etc/sysconfig/network-scripts

[root@localhost network-scripts]# cp ifcfg-bond-bond0 ifcfg-bond-bond0.bak

[root@localhost network-scripts]# cat /etc/resolv.conf

# Generated by NetworkManager

nameserver 114.114.114.114

----------------------------------------------------------------

>>>bayaim10.0------配置oracle：>>>>>>>>

配合主库：

sqlplus / as sysdba

select log_mode,force_logging from v$database;

如果是非归档就要关闭数据库修改

shutdown immediate

startup mount

干净地关闭数据库再启动到mount状态

alter database archivelog;

alter database force logging;

select log_mode,force_logging from v$database;

archive log list

更改归档目录

!

mkdir /u01/oradata/prod/archivelog

ls -l /u01/oradata/prod

exit

alter system set log_archive_dest_1='location=/u01/oradata/prod/archivelog';

archive log list

alter database open;

>>>bayaim10.0------配置oracle：>>>>>>>>

1.0 创建pfile

create pfile from spfile;

[oracle@pordb ~]$ cd $ORACLE_HOME\dbs

[oracle@pordb dbs]$ pwd

/u01/app/oracle/11g/dbs

SQL> alter database create standby controlfile as '/u01/app/oracle/product/11.2.0/db_1/dbs/prodb.ctl';

[oracle@localhost ~]$orapwd file=$ORACLE_HOME/dbs/orapwprodb password=oracle entries=3

应用说明：

orapwd命令是用来创建口令文件的，所以需要明白什么时候需要这个口令文件，执行下列命令查看

-------------------------------------------------------------------------------------------

linux下查找某个文件位置的方法

find / -name tnsnames.ora

还可以用locate 来查找

locate tnsnames.ora

-------------------------------------------------------------------------------------------

把pfile文件、口令文件和备控制文件传输到standby

exit

cd /u01/app/oracle/11g/dbs

ls -lrt

scp orapwbay214 bay224:/u01/app/oracle/product/11.2.0/db_1/dbs

scp initbay214.ora bay224:/u01/app/oracle/product/11.2.0/db_1/dbs

scp prodb.ctl bay224:/u01/app/oracle/product/11.2.0/db_1/dbs

[oracle@pordb dbs]$ pwd

/u01/app/oracle/11g/dbs

[root@bay214 ~]# find / -name *control*.ctl

/u01/app/oracle/oradata/bay214/control01.ctl

/u01/app/oracle/fast_recovery_area/bay214/control02.ctl

[oracle@standby dbs]$ cp prodb.ctl /u01/app/oracle/oradata/bay214/control01.ctl

[oracle@standby dbs]$ mkdir -p /u01/app/oracle/fast_recovery_area/bay214

[oracle@standby dbs]$ cp prodb.ctl /u01/app/oracle/fast_recovery_area/bay214/control02.ctl

创建完后，数据库需要重启动，新的口令文件才能生效。

------------------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

发现问题：

在上面，由于在建 orapw 口令文件时，设定的 entries 值为2 ，故口令文件只能存放两条的记录，最后一条会被覆盖。

test 为最后面添加的，所以口令时存在的。

$strings orapwstudy

]\[Z

ORACLE Remote Password file

INTERNAL

D0EECC16A54101ED

B898A7F877F295DD

B0BE7F5D1FD7439A

TEST

7A0F2B316C212D67

F15C7D7DFC8C7D52

这是Linux重装或则openssh-server重装引起的，执行以下命令即可

ssh-keygen -R 10.10.10.14

把IP换成你要连的服务器就可以

操作：在执行scp命令的主机上执行：

vi ~/.ssh/known_hosts

删除IP为172.16.103.176 的行即可。

该现象在虚拟机删除之后重新建立的时候尤其明显，

要是因为原始主机已经存了一份了known_hosts了，需要更新。

 

 

[oracle@wwdb2 ~]$ env | grep ORA

[oracle@wwdb2 ~]$ vi .bash_profile

[oracle@wwdb2 ~]$ source .bash_profile

[oracle@standby dbs]$ mv orapwprodb orapwstandby

[oracle@standby dbs]$ mv initprodb.ora initstandby.ora

[oracle@standby dbs]$

#chown -R oracle:oinstall /oradata1

#chmod 775 /oradata1

[oracle@wwdb2 oradata1]$ mkdir standby

----------------------------------------------------------------------

把最上面几行去掉，然后把上面标注的prod都改成standby

注意db_name的prod值不要修改

[oracle@pordb prodb]$ pwd

/u01/app/oracle/oradata/prodb

mkdir -p /u01/app/oracle/oradata/bay214

mkdir -p /u01/app/oracle/fast_recovery_area

mkdir -p /u01/app/oracle/admin/bay214/adump

mkdir -p /u01/app/oracle/admin/bay214/cdump

mkdir -p /u01/app/oracle/admin/bay214/bdump

mkdir -p /u01/app/or-acle/admin/bay214/dpdump

mkdir -p /u01/app/oracle/admin/bay214/pfile

chown -R oracle:oinstall /u01/

cd /u01/app/oracle/product/11.2.0/db_1/dbs

vi initstandby.ora

添加如下参数：

*.db_unique_name='bay214'

*.db_file_name_convert='/u01/app/oracle/oradata/bay214','/u01/app/oracle/oradata/bay214'

*.log_file_name_convert='/u01/app/oracle/oradata/bay214','/u01/app/oracle/oradata/bay214'

*.log_archive_config='dg_config=(bay214,bay214)'

*.log_archive_dest_1='location=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=bay214'

*.log_archive_dest_2='service=bay214 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=bay214'

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.log_archive_max_processes=10

*.fal_server=bay214

*.fal_client=bay214

*.standby_file_management=auto

====================================================================================

startup nomount 报错 原因是 initstandby.ora 里面 的版本号输入错误：

[oracle@wwdb2 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 16 14:55:28 2014

Copyright (c) 182, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount

ORA-00401: the value for parameter compatible is not supported by this release

SQL> startup nomount

ORACLE instance started.

Total System Global Area 3120562176 bytes

Fixed Size 2929256 bytes

Variable Size 855641496 bytes

Database Buffers 2248146944 bytes

Redo Buffers 13844480 bytes

SQL>

==================================================================================

TNS 报错 ：原因是防火墙开着：

[oracle@wwdb1 admin]$ tnsping standby

最后发现是 主机A服务器防火墙已经关闭，而主机B上防火墙没有关闭进行如下操作

防火墙关闭后一切正常。

===============配置standby库的listener和静态服务名

>>>bayaim8.0------安装oracle：>>>>>>>>

#su - oracle

$source .bash_profile

$export DISPLAY=10.20.100.114:0.0

$export LANG=en_US

$xhost +

$xclock

$./runInstaller

netmgr

netca

tnsping prod

env | grep ORA

SQL> create spfile from pfile='?/dbs/initprodb.ora';

File created.

SQL> startup nomount

standby库的配置告一段落，重新回到prod库的配置

[oracle@bay224 admin]$ pwd

/u01/app/oracle/product/11.2.0/db_1/network/admin

=========================配置prod数据库======================

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.13)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = fjflww)))

TNS-12543: TNS:destination host unreachable

报这个错，其实百度又开始瞎扯淡了。。。

[root@standby admin]# service iptables stop

Flushing firewall rules: [ OK ]

Setting chains to policy ACCEPT: filter [ OK ]

Unloading iptables modules: [ OK ]

[root@standby admin]# su - oracle

[oracle@standby ~]$

配置prod库参数

sqlplus / as sysdba

alter system set log_archive_config='dg_config=(bay214,bay214)';

alter system set log_archive_dest_1='location=/u01/arch valid_for=(all_logfiles,all_roles) db_unique_name=bay214';

alter system set log_archive_dest_2='service=bay224 lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=bay214';

alter system set log_archive_dest_state_1=enable;

alter system set log_archive_dest_state_2=enable;

alter system set log_archive_max_processes=10;

alter system set fal_server=bay214;

alter system set fal_client=bay214;

alter system set standby_file_management=auto;

set pagesize 450

set linesize 440

show parameter log;

show parameter fal;

还有三需要重启才生效的参数也设置一下

alter system set db_unique_name='bay214' scope=spfile;

alter system set db_file_name_convert='/u01/app/oracle/oradata/bay214','/u01/app/oracle/oradata/bay214' scope=spfile;

alter system set log_file_name_convert='/u01/app/oracle/oradata/bay214','/u01/app/oracle/oradata/bay214' scope=spfile;

shutdown immediate

startup

-------------------------------------------------

备份prod库

[oracle@prod db]$ mkdir -p /bai/backupset

创建了备份目录

登陆到rman开始备份

rman target /

RMAN>

run

{

allocate channel d1 type disk ;

allocate channel d2 type disk ;

allocate channel d3 type disk ;

backup database format '/bai/backupset/%U';

release channel d1;

release channel d2;

release channel d3;

}

 

把备份集目录传输到standby的/u01目录下

exit

scp -r /bai/backupset/* standby:/bai/backupset/

可以在standby上检查一下

ls -l /u01

[oracle@prod backupset]$ scp -r /bai/backupset/* standby:/bai/backupset/

oracle@standby's password:

-----------------------------------------------------------------

开始克隆standby库，在prod上运行

[oracle@prod backupset]$ rman target / auxiliary sys/oracle@prodbdg

Recovery Manager: Release 11.2.0.1.0 - Production on Sun Nov 29 10:14:13 2015

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

connected to target database: FJFLWW (DBID=3823638492)

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges

解决: 口令文件，错误导致

------------------------------------------------------------

开始克隆standby库，在prod上运行 [ 雷哥 ]

rman target / auxiliary sys/oracle@standby

duplicate target database for standby from active database Nofilenamecheck dorecover;

 

开始克隆standby库，在prodb上运行

rman target / auxiliary sys/bayaim@bay224

connected to target database: PRODB (DBID=2396898227)

connected to auxiliary database: PRODB (not mounted)

run

{

allocate auxiliary channel d1 type disk;

allocate auxiliary channel d2 type disk;

allocate auxiliary channel d3 type disk;

duplicate target database for standby nofilenamecheck;

release channel d1;

release channel d2;

release channel d3;

}

此时：standby 上：

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/bay214/control01.ctl

/u01/app/oracle/fast_recovery_area/bay214/control02.ctl

查询 standby 上是否目录齐全，否则无法建立controlfile

还原了standby库！

============================配置standby数据库==============================

查询standby库状态

select status from v$instance;

现在数据库为mount状态

创建备库的standby日志

alter database add standby logfile ('/u01/app/oracle/oradata/bay214/standby01.log') size 50m;

alter database add standby logfile ('/u01/app/oracle/oradata/bay214/standby02.log') size 50m;

alter database add standby logfile ('/u01/app/oracle/oradata/bay214/standby03.log') size 50m;

 

日志大小和主库的一样都是50M，数量比主库多一组

在prod库切换几个日志

exit

sqlplus / as sysdba

set linesize 300;

set pagesize 300;

show parameter dest_1;

alter system switch logfile;

/

/

在standby库查看一下是否有归档日志了

exit

ls -l /arch

在从库上执行：

日志可以传输了就ok！

备库执行日志应用同步语句，开始运行物理DG

sqlplus / as sysdba

alter database recover managed standby database using current logfile disconnect from session;

因为有备重做日志，所以可以加using current logfile语句,实现实时应用

select sequence#, applied from v$archived_log where applied='YES' order by sequence#;

yes说明日志同步了

SQL> create spfile from pfile;

----------------------------------------------------------->>>>>>>>>>>>>>>

验证：

在prod库上执行:

conn scott/tiger

create table t(i int);

insert into t values(1);

commit;

conn / as sysdba

alter system switch logfile;

在standby库上执行:

alter database recover managed standby database cancel;

alter database open;

conn scot/tiger

select * from t;

SQL> select table_name from user_tables;

SQL> select instance_name,status from v$instance;

SQL> alter database recover managed standby database using current logfile disconnect from session;

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

数据已经同步，物理DG搭建成功！

----------------------------------------------------->>>>>>>>>>>>>>>>

此时standby :

看一下数据库的open状态

conn / as sysdba

select open_mode from v$database;

READ ONLY

此时prod ：

READ WRITE

alter database recover managed standby database using current logfile disconnect from session;

select open_mode from v$database;

启动数据同步语句后，数据库又变为mounted状态

注意：在测试数据同步的时候请不要用sys用户，不然可能同步不了，这里测试都是用scott用户

SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;

---------------------------------------------------------------------------

完整的一次启停：

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 839282688 bytes

Fixed Size 2217992 bytes

Variable Size 595593208 bytes

Database Buffers 239075328 bytes

Redo Buffers 2396160 bytes

Database mounted.

SQL> alter database open read only;

Database altered.

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

standby OPEN

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

standby OPEN

SQL> conn scott/tiger

Connected.

SQL> select * from t_5;

I

----------

21212

222

4442

5655

SQL>

====================================================================================

startup nomount 报错 原因是 initstandby.ora 里面 的版本号输入错误：