ORACLE DG 搭建.docx
《ORACLE DG 搭建.docx》由会员分享,可在线阅读,更多相关《ORACLE DG 搭建.docx(30页珍藏版)》请在冰豆网上搜索。
ORACLEDG搭建
ORACLEDG搭建
dataguard:
DG(同步数据)--从主机上把归档传输到备机上,分为:
物理:
把物理的归档日志文件备份过来了,使用recover恢复。
逻辑:
把归档日志逻辑上备份过来,先做日志挖掘,把SQL语句
选择出来,再选择。
搭建DG(我这里的主库和备库的目录是一样的)
1,主从的ORACLE的版本要一致
2,主从的环境变量要一致
3,配置hosts文件
vim /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
:
:
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.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1268872 bytes
Variable Size 213910392 bytes
Database Buffers 381681664 bytes
Redo Buffers 7118848 bytes
Database mounted.
SQL> alter database force logging;
Database altered.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/archivelog/emrep
Oldest online log sequence 18
Next log sequence to archive 20
Current log sequence 20
SQL> select force_logging from v$database;
FOR
YES
SQL> create pfile='$ORACLE_HOME/dbs/initemrep.ora' from spfile;
File created.
SQL> shutdown immediate
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='/ora/oradata/emrep','/oracle/app/oradat
a/emrep'
先远程后本地
启动数据库到nomount的状态下
[oracle@station172~]$sqlplus/assysdba
SQL>startupnomountpfile='$ORACLE_HOME/dbs/initemrep.ora';
ORACLEinstancestarted.
TotalSystemGlobalArea603979776bytes
FixedSize1268872bytes
VariableSize213910392bytes
DatabaseBuffers381681664bytes
RedoBuffers7118848bytes
SQL>createspfilefrompfile;
Filecreated.
SQL>alterdatabasemount;
Databasealtered.
SQL>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
选择TCP/IP协议,选择Next
输入HostName:
可以是主机名,也可以是IP地址。
使用默认端口
号1521。
点击Next
输入数据库实例名称,ConnectionType:
DedicatedServer。
选择点击Next
点击Finish,如下图所示:
到此步时,保存退出即可完成监听和实例的配置。
以下两个为刚配
置的监听和实例的配置文件的内容
[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
#GeneratedbyOracleconfigurationtools.
PDB=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.131)(PORT=
1521))
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=pdb)
)
)
SDB=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.58)(PORT=
1521))
)
(CONNECT_DATA=
(SERVER=DEDICATED)
(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
allocatedchannel:
ORA_DISK_2
channelORA_DISK_2:
sid=118devtype=DISK
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
includingstandbycontrolfileinbackupset
channelORA_DISK_1:
startingpiece1at30-JUN-10
channelORA_DISK_1:
finishedpiece1at30-JUN-10
piecehandle=/u01/app/oracle/bak/bk_4flhhb45_1_1
tag=TAG20100630T114157comment=NONE
channelORA_DISK_1:
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
RMAN>backupformat'/u01/app/oracle/bak/back_%U'database
plusarchivelog;
Startingbackupat30-JUN-10
currentlogarchived
usingchannelORA_DISK_1
usingchannelORA_DISK_2
channelORA_DISK_1:
startingarchivelogbackupset
channelORA_DISK_1:
specifyingarchivelog(s)inbackupset
inputarchivelogthread=1sequence=113recid=101
stamp=723037395
channelORA_DISK_1:
startingpiece1at30-JUN-10
channelORA_DISK_1:
finishedpiece1at30-JUN-10
piecehandle=/u01/app/oracle/bak/back_4hlhhb6k_1_1
tag=TAG20100630T114316comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
02
Finishedbackupat30-JUN-10
Startingbackupat30-JUN-10
usingchannelORA_DISK_1
usingchannelORA_DISK_2
channelORA_DISK_1:
startingfulldatafilebackupset
channelORA_DISK_1:
specifyingdatafile(s)inbackupset
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
channelORA_DISK_1:
startingpiece1at30-JUN-10
channelORA_DISK_2:
startingfulldatafilebackupset
channelORA_DISK_2:
specifyingdatafile(s)inbackupset
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
channelORA_DISK_2:
startingpiece1at30-JUN-10
channelORA_DISK_1:
finishedpiece1at30-JUN-10
piecehandle=/u01/app/oracle/bak/back_4ilhhb6m_1_1
tag=TAG20100630T114318comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
25
channelORA_DISK_2:
finishedpiece1at30-JUN-10
piecehandle=/u01/app/oracle/bak/back_4jlhhb6m_1_1
tag=TAG20100630T114318comment=NONE
channelORA_DISK_2:
backupsetcomplete,elapsedtime:
00:
00:
50
Finishedbackupat30-JUN-10
Startingbackupat30-JUN-10
currentlogarchived
usingchannelORA_DISK_1
usingchannelORA_DISK_2
channelORA_DISK_1:
startingarchivelogbackupset
channelORA_DISK_1:
specifyingarchivelog(s)inbackupset
inputarchivelogthread=1sequence=114recid=102
stamp=723037449
channelORA_DISK_1:
startingpiece1at30-JUN-10
channelORA_DISK_1:
finishedpiece1at30-JUN-10
piecehandle=/u01/app/oracle/bak/back_4klhhb89_1_1
tag=TAG20100630T114409comment=NONE
channelORA_DISK_1:
backupsetcomplete,elapsedtime:
00:
00:
02
Finishedbackupat30-JUN-10
StartingControlFileAutobackupat30-JUN-10
piece
handle=/u01/app/oracle/flash_recovery_area/PDB/autobackup/20
10_06_30/o1_mf_n_723037451_62ohdd9t_.bkpcomment=NONE
FinishedControlFileAutobackupat30-JUN-10
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:
00:
b0:
e8:
a1: