Oracle DG 搭建手册Word下载.docx
- 文档编号:22587672
- 上传时间:2023-02-04
- 格式:DOCX
- 页数:53
- 大小:152.82KB
Oracle DG 搭建手册Word下载.docx
《Oracle DG 搭建手册Word下载.docx》由会员分享,可在线阅读,更多相关《Oracle DG 搭建手册Word下载.docx(53页珍藏版)》请在冰豆网上搜索。
Generated
by
Oracle
configuration
tools.
9.
10.RACDB
=
11.
(DESCRIPTION
12.
(ADDRESS
(PROTOCOL
TCP)(HOST
racnode-cluster-scan)(PORT
1521))
13.
(CONNECT_DATA
14.
(SERVER
DEDICATED)
15.
(SERVICE_NAME
RACDB)
16.
)
17.
2.1.2检查数据库监听
1.[oracle@racnode1
lsnrctl
status
2.
3.LSNRCTL
for
Linux:
Version
11.2.0.3.0
-
Production
on
24-AUG-2015
13:
22:
18
4.
5.Copyright
(c)
1991,
2011,
Oracle.
All
rights
reserved.
6.
7.Connecting
to
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
8.STATUS
of
the
LISTENER
9.------------------------
10.Alias
11.Version
TNSLSNR
12.Start
Date
23-AUG-2015
18:
58:
20
13.Uptime
0
days
hr.
23
min.
58
sec
14.Trace
Level
off
15.Security
ON:
Local
OS
Authentication
16.SNMP
OFF
17.Listener
Parameter
File
/u01/app/11.2.0/grid/network/admin/listener.ora
18.Listener
Log
/u01/app/grid/diag/tnslsnr/racnode1/listener/alert/log.xml
19.Listening
Endpoints
Summary...
20.
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
21.
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.77.185)(PORT=1521)))
22.
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.77.187)(PORT=1521)))
23.Services
24.Service
"
+ASM"
has
1
instance(s).
25.
Instance
+ASM1"
READY,
handler(s)
this
service...
26.Service
RACDB"
27.
RACDB_1"
28.Service
RACDBXDB"
29.
30.The
command
completed
successfully
2.2查询SID并创建RMAN备份目录
sqlplus
/
as
sysdba
3.SQL*Plus:
Release
Mon
Aug
24
33
2015
1982,
7.
8.Connected
to:
9.Oracle
Database
11g
Enterprise
Edition
64bit
10.With
Partitioning,
Real
Application
Clusters,
Automatic
Storage
Management,
OLAP,
11.Data
Mining
and
Testing
options
13.SQL>
show
parameter
service
15.NAME
TYPE
VALUE
16.------------------------------------
-----------
------------------------------
17.service_names
string
RACDB
18.SQL>
exit
19.Disconnected
from
20.With
21.Data
22.[oracle@racnode1
mkdir
/rmanbak
23.mkdir:
cannot
create
directory
`/rmanbak'
:
Permission
denied
24.[oracle@racnode1
25.logout
2.3将RAC主库修改为归档模式,并开启forcelogging模式
由于事先已经将数据库置为归档模式,故在此只需要修改forcelogging模式即可。
2.SQL*Plus:
57
3.Copyright
4.Connected
5.Oracle
Productio
6.With
7.Data
8.SQL>
alter
database
force
logging;
9.Database
altered.
10.SQL>
11.Disconnected
12.With
13.Data
2.4主库全备,创建standbycontrolfile,生成pfile文件,复制密码文件。
然后将准备好的所有文件复制到备库所在目录(最好对应主库的备份目录,方便RMAN恢复。
)
1.[root@racnode1
~]#
2.[root@racnode1
chown
oracle:
oinstall
/rmanbak/
3.[root@racnode1
su
oracle
rman
target
5.Recovery
Manager:
27:
15
6.Copyright
and/or
its
affiliates.
7.connected
database:
(DBID=883515518)
8.<
span
style="
color:
#ff0000;
>
<
strong>
----------------------备份数据库和归档<
/strong>
/span>
9.RMAN>
run
{
10.2>
allocate
channel
c1
type
disk;
11.3>
c2
12.4>
c3
13.5>
c4
14.6>
backup
format
'
/rmanbak/FULL_%U.bak'
;
15.7>
archivelog
all
/rmanbak/ARC_%U.bak'
16.8>
release
c1;
17.9>
c2;
18.10>
c3;
19.11>
c4;
20.12>
}
21.released
channel:
ORA_DISK_1
22.allocated
23.channel
c1:
SID=155
instance=RACDB_1
device
type=DISK
24.allocated
25.channel
c2:
SID=24
26.allocated
27.channel
c3:
SID=29
28.allocated
29.channel
c4:
SID=158
30.Starting
at
24-AUG-15
31.channel
starting
full
datafile
set
32.channel
specifying
datafile(s)
in
33.input
file
number=00006
name=+DATADG/racdb/datafile/data01.269.886180153
34.channel
piece
35.channel
36.channel
37.input
number=00002
name=+DATADG/racdb/datafile/sysaux.261.885898927
38.input
number=00005
name=+DATADG/racdb/datafile/users.265.885899091
39.channel
40.channel
41.channel
42.input
number=00003
name=+DATADG/racdb/datafile/undotbs1.262.885898975
43.input
number=00007
name=+DATADG/racdb/datafile/index01.270.886180183
44.channel
45.channel
46.channel
47.input
number=00001
name=+DATADG/racdb/datafile/system.260.885898771
48.input
number=00004
name=+DATADG/racdb/datafile/undotbs2.264.885899061
49.channel
50.channel
finished
51.piece
handle=/rmanbak/FULL_0gqfdgi0_1_1.bak
tag=TAG20150824T134016
comment=NONE
52.channel
complete,
elapsed
time:
00:
02:
54
53.channel
54.channel
55.channel
56.piece
handle=/rmanbak/FULL_0fqfdgi0_1_1.bak
57.channel
03:
29
58.channel
59.channel
60.including
current
SPFILE
61.channel
62.channel
63.piece
handle=/rmanbak/FULL_0hqfdgi0_1_1.bak
64.channel
30
65.channel
66.piece
handle=/rmanbak/FULL_0iqfdgi6_1_1.bak
67.channel
48
68.channel
69.piece
handle=/rmanbak/FULL_0kqfdgoh_1_1.bak
70.channel
02
71.including
control
72.channel
73.channel
74.piece
handle=/rmanbak/FULL_0jqfdgni_1_1.bak
75.channel
01
76.Finished
77.Starting
78.current
log
archived
79.channel
80.channel
log(s)
81.input
thread=1
sequence=148
RECID=3
STAMP=888506477
82.input
thread=2
sequence=47
RECID=1
STAMP=888506297
83.input
sequence=48
RECID=2
STAMP=888506471
84.input
sequence=49
RECID=5
STAMP=888507728
85.input
sequence=149
RECID=4
STAMP=8885076
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle DG 搭建手册 搭建 手册
![提示](https://static.bdocx.com/images/bang_tan.gif)