oracle11g dg备库启动,linux下oracle11G DG搭建（三）：环绕备库搭建操作

待我称王封你为后i 2023-01-18 15:30 28阅读 0赞

linux下oracle11G DG搭建(三)：环绕备库搭建操作

环境

名称

主库

备库

主机名

bjsrv

shsrv

软件版本号

RedHat Enterprise5.5、Oracle 11g 11.2.0.1

三、环绕备库操作：

1、备库-改动初始化參数文件

$cd$ORACLE\_HOME/dbs

$df -h

![7af922f794473ed581715188530edd15.png][]

$vi initshdb.ora

改动简要说明：

\*.audit\_file\_dest=‘/u01/app/oracle/admin/sh/adump‘

//审计文件存放的路径

\*.audit\_trail=‘db‘

\*.compatible=‘11.2.0.0.0‘

\*.control\_files=‘/u01/app/oracle/oradata/sh/sh\_control01.ctl‘

\*.db\_block\_size=8192

\*.db\_name=‘TestDB12‘

\*.db\_recovery\_file\_dest=‘/u01/app/oracle/fast\_recovery\_area‘

\*.db\_recovery\_file\_dest\_size=4322230272

\*.diagnostic\_dest=‘/u01/app/oracle‘

\*.dispatchers=‘(PROTOCOL=TCP) (SERVICE=TestDB12XDB)‘//用于共享，删除

\*.log\_archive\_format=‘arch\_%t\_%s\_%r.log‘

\*.memory\_target=642006528

\*.open\_cursors=300

\*.processes=150

\*.remote\_login\_passwordfile=‘EXCLUSIVE‘

\*.undo\_tablespace=‘UNDOTBS1‘

DB\_UNIQUE\_NAME=shdb

LOG\_ARCHIVE\_CONFIG=‘DG\_CONFIG=(bjdb,shdb)‘

LOG\_ARCHIVE\_DEST\_1=

‘LOCATION=/dsk4/arch\_sh

VALID\_FOR=(ALL\_LOGFILES,ALL\_ROLES)

DB\_UNIQUE\_NAME=shdb‘

LOG\_ARCHIVE\_DEST\_2=

‘SERVICE=bjdbASYNC             //应该是对方

VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE)

DB\_UNIQUE\_NAME=bjdb‘

LOG\_ARCHIVE\_DEST\_STATE\_1=ENABLE

LOG\_ARCHIVE\_DEST\_STATE\_2=ENABLE

LOG\_ARCHIVE\_MAX\_PROCESSES=3

FAL\_SERVER=bjdb

DB\_FILE\_NAME\_CONVERT=‘/u01/app/oracle/oradata/TestDB12‘,‘/u01/app/oracle/oradata/sh‘//先对方，后自己

LOG\_FILE\_NAME\_CONVERT=

‘/dsk1/oradata/bj‘,‘/dsk1/oradata/sh‘,‘/dsk2/oradata/bj‘,‘/dsk2/oradata/sh‘

STANDBY\_FILE\_MANAGEMENT=AUTO          //先对方，后自己

參考例子：

\*.audit\_file\_dest=‘/u01/app/oracle/admin/sh/adump‘

\*.audit\_trail=‘db‘

\*.compatible=‘11.2.0.0.0‘

\*.control\_files=‘/u01/app/oracle/oradata/sh/sh\_control01.ctl‘

\*.db\_block\_size=8192

\*.db\_name=‘TestDB12‘

\*.db\_recovery\_file\_dest=‘/u01/app/oracle/fast\_recovery\_area‘

\*.db\_recovery\_file\_dest\_size=4322230272

\*.diagnostic\_dest=‘/u01/app/oracle‘

\*.log\_archive\_format=‘arch\_%t\_%s\_%r.log‘

\*.memory\_target=642006528

\*.open\_cursors=300

\*.processes=150

\*.remote\_login\_passwordfile=‘EXCLUSIVE‘

\*.undo\_tablespace=‘UNDOTBS1‘

DB\_UNIQUE\_NAME=shdb

LOG\_ARCHIVE\_CONFIG=‘DG\_CONFIG=(bjdb,shdb)‘

LOG\_ARCHIVE\_DEST\_1=

‘LOCATION=/dsk4/arch\_sh

VALID\_FOR=(ALL\_LOGFILES,ALL\_ROLES)

DB\_UNIQUE\_NAME=shdb‘

LOG\_ARCHIVE\_DEST\_2=

‘SERVICE=bjdbASYNC

VALID\_FOR=(ONLINE\_LOGFILES,PRIMARY\_ROLE)

DB\_UNIQUE\_NAME=bjdb‘

LOG\_ARCHIVE\_DEST\_STATE\_1=ENABLE

LOG\_ARCHIVE\_DEST\_STATE\_2=ENABLE

LOG\_ARCHIVE\_MAX\_PROCESSES=3

FAL\_SERVER=bjdb

DB\_FILE\_NAME\_CONVERT=‘/u01/app/oracle/oradata/TestDB12‘,‘/u01/app/oracle/oradata/sh‘

LOG\_FILE\_NAME\_CONVERT=

‘/dsk1/oradata/bj‘,‘/dsk1/oradata/sh‘,‘/dsk2/oradata/bj‘,‘/dsk2/oradata/sh‘

STANDBY\_FILE\_MANAGEMENT=AUTO

2、主库-启备库前主库备份

备库启动之前。给主库做一个备份。

注意：DG下。养成在启动备库前为主库做备份的习惯。以供应对启动备库后产生的未知情况。

主库处于mount状态下：

SQL>selectstatus from v$instance;

![63889c43e79f22fdf12939956936ae03.png][]

$mkdir/dsk4/backup

$rmantarget /

![c2ff310ad9376bc2372f6d8ed544cf70.png][]

RMAN> backupdatabase format ‘/dsk4/backup/%d\_%s.bak‘;

![cea3dc78db7c83a8020dd047a0df0a51.png][]

3、主库、备库-网络配置

主库下：

$lsnrctlstart//启动监听

$cd/u01/app/oracle/product/11.2.0/dbhome\_1/network/admin

$ vilistener.ora

\# listener.oraNetwork Configuration File: /u01/app/oracle/product/11.2.0/dbhome\_1/network/admin/listener.ora

\# Generated byOracle configuration tools.

LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.71)(PORT = 1521))

)

ADR\_BASE\_LISTENER =/u01/app/oracle

$vi tnsnames.ora //手工创建tnsnames文件

\# tnsnames.oraNetwork Configuration File:/u01/app/oracle/product/11.2.0/dbhome\_1/network/admin/tnsnames.ora

\# Generated byOracle configuration tools.

bjdb =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.71)(PORT = 1521))

(CONNECT\_DATA =

(SERVER = DEDICATED)

(SERVICE\_NAME =bjdb)

)

shdb =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.72)(PORT = 1521))

(CONNECT\_DATA =

(SERVER = DEDICATED)

(SERVICE\_NAME = shdb)

)

备库下：

$lsnrctlstart  //启动监听

$cd/u01/app/oracle/product/11.2.0/dbhome\_1/network/admin

$ vilistener.ora//编辑监听

\# listener.oraNetwork Configuration File: /u01/app/oracle/product/11.2.0/dbhome\_1/network/admin/listener.ora

\# Generated byOracle configuration tools.

LISTENER =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.6.72)(PORT = 1521))

)

ADR\_BASE\_LISTENER =/u01/app/oracle

$vi tnsnames.ora    //手工创建tnsnames文件

BJDB =

(DESCRIPTION =

(ADDRESS\_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.71)(PORT = 1521))

)

(CONNECT\_DATA = (SERVER = DEDICATED)

(SERVICE\_NAME = bjdb)

)

SHDB =

(DESCRIPTION =

(ADDRESS\_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.72)(PORT = 1521))

)

(CONNECT\_DATA = (SERVER = DEDICATED)

(SERVICE\_NAME = shdb)

)

4、备库-网络測试：

![SouthEast][]

【补充】：oraclepassword改动

若oraclepassword未知。能够例如以下改动oraclepassword：

$cd /u01/app/oracle/product/11.2.0/dbhome\_1/dbs

$orapwd file=orapwTestDB12 password=oracle entries=3 force=y

$scp orapwTestDB12 shsrv:$ORACLE\_HOME/dbs/orapwshdb

//把主库改动完的password文件复制到备库中

![354493e6026ae4a8104de3236ba8545a.png][]

SQL>showparameter name

![63e194b54d4aa01b40647bb83608c0f2.png][]

主库监听状态：

$lsnrctlstatus

![3724b03dac8ae6c74a8cf9bc19d0cccb.png][]

备库监听状态：

$lsnrctlstatus

![SouthEast][SouthEast 1]

測试主库是否能ping通备库

$tnsping shdb

![dfeae9ca577f731984b90b06ee8dd099.png][]

备库启动实例

$exportORACLE\_SID=shdb

//或改动.bash\_profile

$sqlplus ‘/assysdba’

SQL>startupnomount;

SQL>showparameter pfile;//备库使用pfile启动

![SouthEast][SouthEast 2]

SQL>showparameter name。//看一下数据库參数是否正确

![857b4718166a2d866ce99eb4dd8a386c.png][]

SQL>showparameter archive；            //查询一下归档设置是否正确

![a2dd8c3d18be927a248a32b4b5eeaff5.png][]

![SouthEast][SouthEast 3]

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*未完待续\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

声明：

原创作品，出自 “深蓝的blog” 博客。同意转载。转载时请务必注明出处(http://blog.csdn.net/huangyanlong)。

关于涉及版权事宜，作者有权追究法律责任。

[7af922f794473ed581715188530edd15.png]: /images/20221021/bd3f20fc82fc41f29178d7c52a64a877.png
[63889c43e79f22fdf12939956936ae03.png]: /images/20221021/2a8ccb8b27464ea5adb9c804d47969db.png
[c2ff310ad9376bc2372f6d8ed544cf70.png]: /images/20221021/ba81ca4baa0a429a9c4ac8094c456829.png
[cea3dc78db7c83a8020dd047a0df0a51.png]: /images/20221021/435bd3338f2c4490922b3c46836fa315.png
[SouthEast]: /images/20221021/283ae25187514c809291967094af08dd.png?
[354493e6026ae4a8104de3236ba8545a.png]: /images/20221021/03c1d9c6f7ee47eca91774882cd76912.png
[63e194b54d4aa01b40647bb83608c0f2.png]: /images/20221021/a8fc0f41d1324d87a7e2ac48c645294f.png
[3724b03dac8ae6c74a8cf9bc19d0cccb.png]: /images/20221021/80f20018a4d14eb9a1fccbf178a60621.png
[SouthEast 1]: /images/20221021/c1c9d8444a634bada22b1c32b7753645.png?
[dfeae9ca577f731984b90b06ee8dd099.png]: /images/20221021/c4df19c52713485b85f579db10108d99.png
[SouthEast 2]: /images/20221021/8acd57789a1b498aa6b093d3478f5ad1.png?
[857b4718166a2d866ce99eb4dd8a386c.png]: /images/20221021/b3e4b0763b394045980862adbbef5828.png
[a2dd8c3d18be927a248a32b4b5eeaff5.png]: /images/20221021/2100f92f516c46c5a7c303e02fdbecac.png
[SouthEast 3]: /images/20221021/f111ef35d0bf4f7380d2a2feb5f480f8.png?