DG搭建物理备库 - 数据库编程

搭建过程难免会出现各种错误，所以之前最好做一个备份！！！

service iptables stop 关闭防火墙

[root@localhost ~]# setenforce 0

[root@localhost ~]# getenforce

Permissive

主库

[root@localhost ~]# su - oracle

[oracle@localhost ~]$ db11g

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production onThu Nov 6 14:24:01 2014

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 626327552 bytes

Fixed Size 2230952 bytes

Variable Size 268436824 bytes

Database Buffers 352321536 bytes

Redo Buffers 3338240 bytes

Database mounted.

Database opened.

SQL> show parameter db_uni

NAME TYPE VALUE

----------------------------------------------- ------------------------------

db_unique_name string jadl11g

SQL> alter system set db_unique_name='pjadl11g'scope=spfile; ----更改主库的db_unique_name

System altered.

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled ---归档模式

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 9

Next log sequence to archive 11

Current log sequence 11

增加主库静态注册：

<??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+W29yYWNsZUBsb2NhbGhvc3Qgfl0kIGFzbTwvcD4KPHA+W29yYWNsZUBsb2NhbGhvc3Qgfl0kIDxzdHJvbmc+c3J2Y3RsIHN0b3AgbGlzdGVuZXI8L3N0cm9uZz48L3A+CjxwPltvcmFjbGVAbG9jYWxob3N0IH5dJCBzcnZjdGwgc3RhcnQgbGlzdGVuZXI8L3A+CjxwPltvcmFjbGVAbG9jYWxob3N0IH5dJDxzdHJvbmc+IGxzbnJjdGwgc3RhdHVzPC9zdHJvbmc+PC9wPgo8cD5MU05SQ1RMIGZvciBMaW51eDogVmVyc2lvbiAxMS4yLjAuMy4wIC1Qcm9kdWN0aW9uIG9uIDA2LU5PVi0yMDE0IDE0OjM3OjUwPC9wPgo8cD5Db3B5cmlnaHQgKGMpIDE5OTEsIDIwMTEsIE9yYWNsZS4gIEFsbCByaWdodHMgcmVzZXJ2ZWQuPC9wPgo8cD5Db25uZWN0aW5nIHRvKERFU0NSSVBUSU9OPShBRERSRVNTPShQUk9UT0NPTD1UQ1ApKEhPU1Q9bG9jYWxob3N0KShQT1JUPTE1MjEpKSk8L3A+CjxwPlNUQVRVUyBvZiB0aGUgTElTVEVORVI8L3A+CjxwPi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLTwvcD4KPHA+QWxpYXMgICAgICAgICAgICAgICAgICAgICBMSVNURU5FUjwvcD4KPHA+VmVyc2lvbiAgICAgICAgICAgICAgICAgICBUTlNMU05SIGZvciBMaW51eDogVmVyc2lvbjExLjIuMC4zLjAgLSBQcm9kdWN0aW9uPC9wPgo8cD5TdGFydCBEYXRlICAgICAgICAgICAgICAgIDA2LU5PVi0yMDE0IDE0OjM3OjMyPC9wPgo8cD5VcHRpbWUgICAgICAgICAgICAgICAgICAgIDAgZGF5cyAwIGhyLiAwIG1pbi4gMTggc2VjPC9wPgo8cD5UcmFjZSBMZXZlbCAgICAgICAgICAgICAgIG9mZjwvcD4KPHA+U2VjdXJpdHkgICAgICAgICAgICAgICAgICBPTjogTG9jYWwgT1MgQXV0aGVudGljYXRpb248L3A+CjxwPlNOTVAgICAgICAgICAgICAgICAgICAgICAgT0ZGPC9wPgo8cD5MaXN0ZW5lciBQYXJhbWV0ZXIgRmlsZSAgIC91MDEvZ3JpZC8xMWcvbmV0d29yay9hZG1pbi9saXN0ZW5lci5vcmE8L3A+CjxwPkxpc3RlbmVyIExvZyBGaWxlICAgICAgICAvdTAxL29yYWNsZS9kaWFnL3Ruc2xzbnIvbG9jYWxob3N0L2xpc3RlbmVyL2FsZXJ0L2xvZy54bWw8L3A+CjxwPkxpc3RlbmluZyBFbmRwb2ludHMgU3VtbWFyeS4uLjwvcD4KPHA+IChERVNDUklQVElPTj0oQUREUkVTUz0oUFJPVE9DT0w9dGNwKShIT1NUPWxvY2FsaG9zdCkoUE9SVD0xNTIxKSkpPC9wPgo8cD4gKERFU0NSSVBUSU9OPShBRERSRVNTPShQUk9UT0NPTD1pcGMpKEtFWT1FWFRQUk9DMTUyMSkpKTwvcD4KPHA+U2VydmljZXMgU3VtbWFyeS4uLjwvcD4KPHA+U2VydmljZSAmcXVvdDtqYWRsMTFnJnF1b3Q7IGhhcyAxaW5zdGFuY2UocykuPC9wPgo8cD4gSW5zdGFuY2UgJnF1b3Q7amFkbDExZyZxdW90Oywgc3RhdHVzIFVOS05PV04sIGhhcyAxIGhhbmRsZXIocykgZm9yIHRoaXNzZXJ2aWNlLi4uPC9wPgo8cD5TZXJ2aWNlICZxdW90O3BqYWRsMTFnJnF1b3Q7IGhhcyAxaW5zdGFuY2UocykuPC9wPgo8cD4gSW5zdGFuY2UgJnF1b3Q7amFkbDExZyZxdW90Oywgc3RhdHVzIFVOS05PV04sIGhhcyAxIGhhbmRsZXIocykgZm9yIHRoaXNzZXJ2aWNlLi4uPC9wPgo8cD5TZXJ2aWNlICZxdW90O3BqYWRsMTFnX0RHTUdSTCZxdW90OyBoYXMgMWluc3RhbmNlKHMpLjwvcD4KPHA+IEluc3RhbmNlICZxdW90O2phZGwxMWcmcXVvdDssIHN0YXR1cyBVTktOT1dOLCBoYXMgMSBoYW5kbGVyKHMpIGZvciB0aGlzc2VydmljZS4uLjwvcD4KPHA+VGhlIGNvbW1hbmQgY29tcGxldGVkIHN1Y2Nlc3NmdWxseTwvcD4KPHA+W29yYWNsZUBsb2NhbGhvc3Qgfl0kIGRiMTFnPC9wPgo8cD5bb3JhY2xlQGxvY2FsaG9zdCB+XSQgPHN0cm9uZz5ybWFuIHRhcmdldCAvPC9zdHJvbmc+PC9wPgo8cD5SZWNvdmVyeSBNYW5hZ2VyOiBSZWxlYXNlIDExLjIuMC4zLjAgLVByb2R1Y3Rpb24gb24gVGh1IE5vdiA2IDE0OjM4OjU4IDIwMTQ8L3A+CjxwPkNvcHlyaWdodCAoYykgMTk4MiwgMjAxMSwgT3JhY2xlIGFuZC9vciBpdHNhZmZpbGlhdGVzLiAgQWxsIHJpZ2h0cyByZXNlcnZlZC48L3A+CjxwPmNvbm5lY3RlZCB0byB0YXJnZXQgZGF0YWJhc2U6IEpBREwxMUcoREJJRD0yMDg4NzUyOTA3KTwvcD4KPHA+Uk1BTiZndDs8c3Ryb25nPiBiYWNrdXAgZGF0YWJhc2U7LS0tsbi33db3v+I8L3N0cm9uZz48L3A+CjxwPlN0YXJ0aW5nIGJhY2t1cCBhdCAwNi1OT1YtMTQ8L3A+CjxwPnVzaW5nIHRhcmdldCBkYXRhYmFzZSBjb250cm9sIGZpbGUgaW5zdGVhZG9mIHJlY292ZXJ5IGNhdGFsb2c8L3A+CjxwPmFsbG9jYXRlZCBjaGFubmVsOiBPUkFfRElTS18xPC9wPgo8cD5jaGFubmVsIE9SQV9ESVNLXzE6IFNJRD00MSBkZXZpY2UgdHlwZT1ESVNLPC9wPgo8cD5jaGFubmVsIE9SQV9ESVNLXzE6IHN0YXJ0aW5nIGZ1bGwgZGF0YWZpbGViYWNrdXAgc2V0PC9wPgo8cD5jaGFubmVsIE9SQV9ESVNLXzE6IHNwZWNpZnlpbmcgZGF0YWZpbGUocylpbiBiYWNrdXAgc2V0PC9wPgo8cD5pbnB1dCBkYXRhZmlsZSBmaWxlIG51bWJlcj0wMDAwMW5hbWU9L3UwMS9vcmFjbGUvb3JhZGF0YS9qYWRsMTFnL3N5c3RlbTAxLmRiZjwvcD4KPHA+aW5wdXQgZGF0YWZpbGUgZmlsZSBudW1iZXI9MDAwMDJuYW1lPS91MDEvb3JhY2xlL29yYWRhdGEvamFkbDExZy9zeXNhdXgwMS5kYmY8L3A+CjxwPmlucHV0IGRhdGFmaWxlIGZpbGUgbnVtYmVyPTAwMDA1bmFtZT0vdTAxL29yYWNsZS9vcmFkYXRhL2phZGwxMWcvZXhhbXBsZTAxLmRiZjwvcD4KPHA+aW5wdXQgZGF0YWZpbGUgZmlsZSBudW1iZXI9MDAwMDNuYW1lPS91MDEvb3JhY2xlL29yYWRhdGEvamFkbDExZy91bmRvdGJzMDEuZGJmPC9wPgo8cD5pbnB1dCBkYXRhZmlsZSBmaWxlIG51bWJlcj0wMDAwNG5hbWU9L3UwMS9vcmFjbGUvb3JhZGF0YS9qYWRsMTFnL3VzZXJzMDEuZGJmPC9wPgo8cD5jaGFubmVsIE9SQV9ESVNLXzE6IHN0YXJ0aW5nIHBpZWNlIDEgYXQwNi1OT1YtMTQ8L3A+CjxwPmNoYW5uZWwgT1JBX0RJU0tfMTogZmluaXNoZWQgcGllY2UgMSBhdDA2LU5PVi0xNDwvcD4KPHA+cGllY2VoYW5kbGU9L3UwMS9vcmFjbGUvZmFzdF9yZWNvdmVyeV9hcmVhL0pBREwxMUcvYmFja3Vwc2V0LzIwMTRfMTFfMDYvbzFfbWZfbm5uZGZfVEFHMjAxNDExMDZUMTQzOTE4X2I1cDV3cmtiXy5ia3B0YWc9VEFHMjAxNDExMDZUMTQzOTE4IGNvbW1lbnQ9Tk9ORTwvcD4KPHA+Y2hhbm5lbCBPUkFfRElTS18xOiBiYWNrdXAgc2V0IGNvbXBsZXRlLGVsYXBzZWQgdGltZTogMDA6MDE6Mjc8L3A+CjxwPmNoYW5uZWwgT1JBX0RJU0tfMTogc3RhcnRpbmcgZnVsbCBkYXRhZmlsZWJhY2t1cCBzZXQ8L3A+CjxwPmNoYW5uZWwgT1JBX0RJU0tfMTogc3BlY2lmeWluZyBkYXRhZmlsZShzKWluIGJhY2t1cCBzZXQ8L3A+CjxwPmluY2x1ZGluZyBjdXJyZW50IGNvbnRyb2wgZmlsZSBpbiBiYWNrdXBzZXQ8L3A+CjxwPmluY2x1ZGluZyBjdXJyZW50IFNQRklMRSBpbiBiYWNrdXAgc2V0PC9wPgo8cD5jaGFubmVsIE9SQV9ESVNLXzE6IHN0YXJ0aW5nIHBpZWNlIDEgYXQwNi1OT1YtMTQ8L3A+CjxwPmNoYW5uZWwgT1JBX0RJU0tfMTogZmluaXNoZWQgcGllY2UgMSBhdDA2LU5PVi0xNDwvcD4KPHA+cGllY2VoYW5kbGU9L3UwMS9vcmFjbGUvZmFzdF9yZWNvdmVyeV9hcmVhL0pBREwxMUcvYmFja3Vwc2V0LzIwMTRfMTFfMDYvbzFfbWZfbmNzbmZfVEFHMjAxNDExMDZUMTQzOTE4X2I1cDV6aGN5Xy5ia3B0YWc9VEFHMjAxNDExMDZUMTQzOTE4IGNvbW1lbnQ9Tk9ORTwvcD4KPHA+Y2hhbm5lbCBPUkFfRElTS18xOiBiYWNrdXAgc2V0IGNvbXBsZXRlLGVsYXBzZWQgdGltZTogMDA6MDA6MDE8L3A+CjxwPkZpbmlzaGVkIGJhY2t1cCBhdCAwNi1OT1YtMTQ8L3A+CjxwPlJNQU4mZ3Q7IGV4aXQ8L3A+CjxwPiA8L3A+CjxwPlJlY292ZXJ5IE1hbmFnZXIgY29tcGxldGUuPC9wPgo8cD5bb3JhY2xlQGxvY2FsaG9zdCB+XSQgPHN0cm9uZz5zcWxwbHVzIC8gYXMgc3lzZGJhPC9zdHJvbmc+PC9wPgo8cD5TUUwqUGx1czogUmVsZWFzZSAxMS4yLjAuMy4wIFByb2R1Y3Rpb24gb25UaHUgTm92IDYgMTQ6NDE6NDcgMjAxNDwvcD4KPHA+Q29weXJpZ2h0IChjKSAxOTgyLCAyMDExLCBPcmFjbGUuICBBbGwgcmlnaHRzIHJlc2VydmVkLjwvcD4KPHA+Q29ubmVjdGVkIHRvOjwvcD4KPHA+T3JhY2xlIERhdGFiYXNlIDExZyBFbnRlcnByaXNlIEVkaXRpb25SZWxlYXNlIDExLjIuMC4zLjAgLSA2NGJpdCBQcm9kdWN0aW9uPC9wPgo8cD5XaXRoIHRoZSBQYXJ0aXRpb25pbmcsIE9yYWNsZSBMYWJlbFNlY3VyaXR5LCBPTEFQLCBEYXRhIE1pbmluZyw8L3A+CjxwPk9yYWNsZSBEYXRhYmFzZSBWYXVsdCBhbmQgUmVhbCBBcHBsaWNhdGlvblRlc3Rpbmcgb3B0aW9uczwvcD4KPHA+U1FMJmd0OyA8c3Ryb25nPmNyZWF0ZSBwZmlsZSBmcm9tIHNwZmlsZTsgLS20tL2oss7K/c7EvP48L3N0cm9uZz48L3A+CjxwPkZpbGUgY3JlYXRlZC48L3A+CjxwPlNRTCZndDsgZXhpdDwvcD4KPHA+RGlzY29ubmVjdGVkIGZyb20gT3JhY2xlIERhdGFiYXNlIDExZ0VudGVycHJpc2UgRWRpdGlvbiBSZWxlYXNlIDExLjIuMC4zLjAgLSA2NGJpdCBQcm9kdWN0aW9uPC9wPgo8cD5XaXRoIHRoZSBQYXJ0aXRpb25pbmcsIE9yYWNsZSBMYWJlbFNlY3VyaXR5LCBPTEFQLCBEYXRhIE1pbmluZyw8L3A+CjxwPk9yYWNsZSBEYXRhYmFzZSBWYXVsdCBhbmQgUmVhbCBBcHBsaWNhdGlvblRlc3Rpbmcgb3B0aW9uczwvcD4KPHA+W29yYWNsZUBsb2NhbGhvc3Qgfl0kIDxzdHJvbmc+Y2QgL3UwMS9vcmFjbGUvMTFnL2Ricy88L3N0cm9uZz48L3A+CjxwPltvcmFjbGVAbG9jYWxob3N0IGRic10kIGxzPC9wPgo8cD5oY19qYWRsMTFnLmRhdCAgIGluaXQub3JhICBvcmFwd2phZGwxMWcgICAgIHNwZmlsZWphZGwxMWcub3JhPC9wPgo8cD5pbml0amFkbDExZy5vcmEgIGxrSkFETDExRyBzbmFwY2ZfamFkbDExZy5mPC9wPgo8cD5bb3JhY2xlQGxvY2FsaG9zdCBkYnNdJDxzdHJvbmc+IHNjcCBvcmFwd2phZGwxMWcgaW5pdGphZGwxMWcub3JhMTkyLjE2OC4xLjE4NDovdTAxL29yYWNsZS8xMWcvZGJzLy0tuLTWxtb3v+K1xMPcwuvOxLz+us2yzsr9zsS8/rW9sbi/4jwvc3Ryb25nPjwvcD4KPHA+VGhlIGF1dGhlbnRpY2l0eSBvZiBob3N0IA=="192.168.1.184(192.168.1.184)' can't be established.

RSA key fingerprint is62:02:82:d1:dd:a3:f3:96:71:e5:c7:38:3c:fa:b4:c8.

Are you sure you want to continueconnecting (yes/no)? yes

Warning: Permanently added '192.168.1.184'(RSA) to the list of known hosts.

oracle@192.168.1.184's password:

Permission denied, please try again.

oracle@192.168.1.184's password:

orapwjadl11g 100%1536 1.5KB/s 00:00

initjadl11g.ora 100% 984 1.0KB/s 00:00

主库增加备库日志：

[oracle@localhost dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production onThu Nov 6 15:05:21 2014

Connected to:

Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,

Oracle Database Vault and Real ApplicationTesting options

SQL> alter database add standby logfile group 10;---增加个数为：（线程数+1）*2

Database altered.

SQL> c/10/11

1* alter database addstandby logfile group 11

SQL> /

Database altered.

SQL> alterdatabase add standby logfile group 12;

Database altered.

SQL> alterdatabase add standby logfile group 13;

Database altered.

SQL> exit

Disconnected from Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Oracle LabelSecurity, OLAP, Data Mining,

Oracle Database Vault and Real ApplicationTesting options

主库配置本地命名：

[oracle@localhost dbs]$ cat/u01/oracle/11g/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File:/u01/oracle/11g/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

JADL11G =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = jadl11g)

)

PJADL11G =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = jadl11g)

)

SJADL11G =

(DESCRIPTION =

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

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = jadl11g)

)

备库配置监听：

Netmgr

[oracle@localhost dbs]$ asm

[oracle@localhost dbs]$ srvctl stoplistener

[oracle@localhost dbs]$ srvctl startlistener

[oracle@localhost dbs]$ lsnrctl status

LSNRCTL for Linux: Versio

DG搭建物理备库(一)