ORACLE DG 搭建Word格式文档下载.docx
《ORACLE DG 搭建Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《ORACLE DG 搭建Word格式文档下载.docx(30页珍藏版)》请在冰豆网上搜索。
:
1
localhost6.localdomain6
localhost6
10.1.1.243
station243
10.1.1.172
station172
4,在主库上(primary)
修改force
logging
archivelog
mode
SQL>
shutdown
immediate
Database
closed.
dismounted.
ORACLE
instance
shut
down.
startup
mount
started.
Total
System
Global
Area
603979776
bytes
Fixed
Size
1268872
Variable
213910392
Buffers
381681664
Redo
7118848
mounted.
alter
database
force
logging;
altered.
archivelog;
open;
archive
log
list;
Archive
Mode
Automatic
archival
Enabled
destination
/u01/app/oracle/archivelog/emrep
Oldest
online
sequence
18
Next
to
20
Current
select
force_logging
from
v$database;
FOR
YES
create
pfile='
$ORACLE_HOME/dbs/initemrep.ora'
spfile;
File
created.
cd
/u01/app/oracle/product/10g/db_1/dbs修改参数配置文件
viminitemrep.ora
在最末尾添加:
db_unique_name='
pdb'
log_archive_config='
dg_config=(pdb,sdb)'
fal_server=sdb
fal_client=pdb/u01/app/oracle/product/10g/db_1/dbs
log_archive_dest_2='
service=sdblgwrsyncaffirm
valid_for=(online_logfile,primary_role)db_unique_name=sdb'
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ENABLE
standby_file_management=AUTO
如果主库与备库安装目录不一样:
db_file_name_convert='
/ora/oradata/emrep'
'
/oracle/app/oradata
/emrep'
log_file_name_convert='
/oracle/app/oradat
a/emrep'
先远程后本地
启动数据库到nomount的状态下
[oracle@station172~]$sqlplus/assysdba
startupnomountpfile='
;
ORACLEinstancestarted.
TotalSystemGlobalArea603979776bytes
FixedSize1268872bytes
VariableSize213910392bytes
DatabaseBuffers381681664bytes
RedoBuffers7118848bytes
createspfilefrompfile;
Filecreated.
alterdatabasemount;
Databasealtered.
alterdatabaseopen;
删除掉原来的监听和实例配置文件,然后重新配置
监听配置和tns配置:
使用netmgr通过图形配置
[root@station172~]#xhost+
[oracle@station172~]$netmgr
1)监听配置
点击“+”配置监听
输入监听名称:
LISTENER,点击OK
选择ListeningLocations,点击AddAddress,出现如下图所示
Host:
可以填写主机名,也可以是IP地址。
使用默认端口号1521。
然后在选择DatabaseServices。
点击AddDatabase,如下图所示:
输入数据库名称GlobalDatabaseNametestgc
oracle家目录OracleHomeDirectory
/u01/app/oracle/product/10g/db_1/
实例名称testgc
2)实例配置
点击ServiceNaming,配置主库实例
输入网络字符串名称NetServiceNamepdb,点击Next
选择TCP/IP协议,选择Next
输入HostName:
可以是主机名,也可以是IP地址。
使用默认端口
号1521。
点击Next
输入数据库实例名称,ConnectionType:
DedicatedServer。
选择点击Next
点击Finish,如下图所示:
然后配置从库实例。
点击ServiceNaming
输入网络字符串名称NetServiceNamesdb,点击Next
到此步时,保存退出即可完成监听和实例的配置。
以下两个为刚配
置的监听和实例的配置文件的内容
[oracle@station172~]$
cd/u01/app/oracle/product/10g/db_1/network/admin/
vimlistener.ora
#GeneratedbyOracleconfigurationtools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=emrep)
(ORACLE_HOME=/u01/app/oracle/product/10g/db_1)
(SID_NAME=emrep)
)
LISTENER=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.131)(PORT=1521))
vimtnsnames.ora
#tnsnames.oraNetworkConfigurationFile:
/u01/app/oracle/product
/10g/db_1/network/admin/tnsnames.ora
PDB=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.131)(PORT=
1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=pdb)
SDB=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.58)(PORT=
(SERVICE_NAME=sdb)
备份控制文件和数据库
[oracle@station172~]$rmantarget/
RecoveryManager:
Release10.2.0.4.0-ProductiononWedJun30
11:
40:
542010
Copyright(c)1982,2007,Oracle.Allrightsreserved.
connectedtotargetdatabase:
TESTGC(DBID=2576823561)
RMAN>
backupformat'
/u01/app/oracle/bak/bk_%U'
current
controlfileforstandby;
Startingbackupat30-JUN-10
usingtargetdatabasecontrolfileinsteadofrecoverycatalog
allocatedchannel:
ORA_DISK_1
channelORA_DISK_1:
sid=127devtype=DISK
ORA_DISK_2
channelORA_DISK_2:
sid=118devtype=DISK
startingfulldatafilebackupset
specifyingdatafile(s)inbackupset
includingstandbycontrolfileinbackupset
startingpiece1at30-JUN-10
finishedpiece1at30-JUN-10
piecehandle=/u01/app/oracle/bak/bk_4flhhb45_1_1
tag=TAG20100630T114157comment=NONE
backupsetcomplete,elapsedtime:
00:
00:
01
Finishedbackupat30-JUN-10
StartingControlFileAutobackupat30-JUN-10
piece
handle=/u01/app/oracle/flash_recovery_area/PDB/autobackup/20
10_06_30/o1_mf_n_723037318_62oh86y8_.bkpcomment=NONE
FinishedControlFileAutobackupat30-JUN-10
/u01/app/oracle/bak/back_%U'
database
plusarchivelog;
currentlogarchived
usingchannelORA_DISK_1
usingchannelORA_DISK_2
startingarchivelogbackupset
specifyingarchivelog(s)inbackupset
inputarchivelogthread=1sequence=113recid=101
stamp=723037395
piecehandle=/u01/app/oracle/bak/back_4hlhhb6k_1_1
tag=TAG20100630T114316comment=NONE
02
inputdatafilefno=00002
name=/u01/app/oracle/oradata/testgc/undotbs01.dbf
inputdatafilefno=00003
name=/u01/app/oracle/oradata/testgc/sysaux01.dbf
inputdatafilefno=00007
name=/u01/app/oracle/oradata/testgc/users2.dbf
inputdatafilefno=00010
name=/u01/app/oracle/oradata/testgc/tools.dbf
inputdatafilefno=00004
name=/u01/app/oracle/oradata/testgc/users01.dbf
inputdatafilefno=00012
name=/u01/app/oracle/oradata/testgc/t2_172.dbf
inputdatafilefno=00014
name=/u01/app/oracle/oradata/testgc/t4_172.dbf
inputdatafilefno=00016
name=/u01/app/oracle/oradata/testgc/tts_e1.dbf
inputdatafilefno=00017
name=/u01/app/oracle/oradata/testgc/tts_e2.dbf
inputdatafilefno=00001
name=/u01/app/oracle/oradata/testgc/system01.dbf
inputdatafilefno=00005
name=/u01/app/oracle/oradata/testgc/mgmt.dbf
inputdatafilefno=00009
name=/u01/app/oracle/oradata/testgc/undotbs02.dbf
inputdatafilefno=00006
name=/u01/app/oracle/oradata/testgc/mgmt_ecm_depot1.dbf
inputdatafilefno=00008
name=/u01/app/oracle/oradata/testgc/system02.dbf
inputdatafilefno=00011
name=/u01/app/oracle/oradata/testgc/t1_172.dbf
inputdatafilefno=00013
name=/u01/app/oracle/oradata/testgc/t3_172.dbf
inputdatafilefno=00015
name=/u01/app/oracle/oradata/testgc/t5_172.dbf
piecehandle=/u01/app/oracle/bak/back_4ilhhb6m_1_1
tag=TAG20100630T114318comment=NONE
25
piecehandle=/u01/app/oracle/bak/back_4jlhhb6m_1_1
50
inputarchivelogthread=1sequence=114recid=102
stamp=723037449
piecehandle=/u01/app/oracle/bak/back_4klhhb89_1_1
tag=TAG20100630T114409comment=NONE
10_06_30/o1_mf_n_723037451_62ohdd9t_.bkpcomment=NONE
5,在备库上:
[oracle@station243~]$mkdiradmin/testgc-p
[oracle@station243~]$cdadmin/
[oracle@station243admin]$ls
testgc
[oracle@station243admin]$cdtestgc/
[oracle@station243testgc]$mkdiradumpbdumpcdumpdpdump
pfileudump
[oracle@station243testgc]$ls
adumpbdumpcdumpdpdumppfileudump
[oracle@station243testgc]$cd
[oracle@station243~]$mkdirflash_recovery_area/TESTGC/-p
[oracle@station243~]$mkdiroradata/testgc-p
[oracle@station243~]$mkdirbak-p
[oracle@station243~]$mkdirarchivelog/testgc-p
6,在主库上:
[oracle@station172~]$cdbak/
[oracle@station172bak]$scp*10.1.1.243:
/u01/app/oracle/bak/
Theauthenticityofhost'
10.1.1.243(10.1.1.243)'
can'
tbe
established.
RSAkeyfingerprintisa1:
5c:
b0:
e8:
a1: