• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

bay——安装_Oracle 12C-单实例-Centos7 -DG.txt

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

 

用户和密码:

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 里面 的版本号输入错误:

 


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C++读取XML,tinyXml的使用发布时间:2022-07-13
下一篇:
c3p0-数据库连接池原理发布时间:2022-07-13
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap