{"id":853,"date":"2013-05-12T21:01:35","date_gmt":"2013-05-12T13:01:35","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=853"},"modified":"2013-07-04T13:41:55","modified_gmt":"2013-07-04T05:41:55","slug":"racdgogg%e7%81%be%e5%a4%87%e4%b8%adogg%e5%ae%9e%e7%8e%b0%e9%83%a8%e5%88%86","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=853","title":{"rendered":"RAC+DG+OGG\u707e\u5907\u4e2dOGG\u5b9e\u73b0\u90e8\u5206"},"content":{"rendered":"

\u672c\u6587\u4e0d\u7275\u626f\u5177\u4f53\u64cd\u4f5c\u7cfb\u7edf\u53caoracle\u8f6f\u4ef6\u7684\u5b89\u88c5\uff0c\u5047\u5b9a\u5728\u5b9e\u65bd\u5b8c\u6bd5\u7684rac\u73af\u5883\u53ca\u5b89\u88c5\u597doracle\u8f6f\u4ef6\u7684\u5355\u673a\u5e73\u53f0\u4e0b\uff0c\u8bb2\u89e3\u5982\u4f55\u5b9e\u65bdRAC+DG+OGG\u6784\u5efa\u707e\u5907\u7cfb\u7edf\u4e2dOGG\u5b9e\u73b0\u90e8\u5206\uff0c\u5176\u4ed6\u90e8\u5206\u89c1\u6211\u4e4b\u524d\u7684\u76f8\u5173\u535a\u6587\u3002
\nRAC+DG+OGG\u7b80\u8981\u67b6\u6784\u5982\u4e0b\uff1a
\n\"rac+dg+ogg\"<\/a><\/p>\n

\u4ee5\u4e0b\u4e3a\u4e3b\u8981\u7684\u5b9e\u65bd\u8fc7\u7a0b\uff1a
\n\u4fee\u6539\u5b58\u50a8\u670d\u52a1\u5668\u4e2d\u5171\u4eab\u76d8\u7684\u8bbe\u7f6e<\/strong><\/p>\n

\r\n[root@openfiler rac_ogg]# cat \/etc\/exports\r\n\r\n# PLEASE DO NOT MODIFY THIS CONFIGURATION FILE!\r\n#       This configuration file was autogenerated\r\n#       by Openfiler. Any manual changes will be overwritten\r\n#       Generated at: Thu May 2 15:36:07 CST 2013\r\n\r\n\r\n# End of Openfiler configuration\r\n\r\n\/mnt\/rac_ogg\/rac_ogg  192.168.137.0\/24(rw,sync,no_root_squash,no_all_squash,no_subtree_check) \r\n\r\n\r\n<\/pre>\n
\u5728rac\u6240\u6709\u8282\u70b9\u6302\u8f7d<\/strong><\/p>\n
\r\nmount -t nfs  192.168.137.141:\/mnt\/rac_ogg\/rac_ogg\/rac_ogg \/u01\/app\/ogg\/11.1\r\n\r\n<\/pre>\n
\u4fee\u6539\u6240\u6709\u8282\u70b9\u5f00\u673a\u81ea\u52a8\u4fee\u6539\u9879\u76ee\u5f55\u5c5e\u7ec4<\/strong><\/p>\n
\r\n[root@11grac1 11.1]# cat \/etc\/rc.local \r\n#!\/bin\/sh\r\n#\r\n# This script will be executed *after* all the other init scripts.\r\n# You can put your own initialization stuff in here if you don't\r\n# want to do the full Sys V style init stuff.\r\n\r\ntouch \/var\/lock\/subsys\/local\r\n\r\nchown -R oracle:oinstall \/u01\/app\/ogg\/11.1\r\n\r\n<\/pre>\n
\u4fee\u6539rac2\u4e2a\u8282\u70b9\u7684\u5f00\u673a\u81ea\u52a8\u6302\u8f7d\u9879<\/strong><\/p>\n
\r\n[root@11grac2 11.1]# cat \/etc\/fstab \r\nLABEL=\/                 \/                       ext3    defaults        1 1\r\nLABEL=\/boot             \/boot                   ext3    defaults        1 2\r\ntmpfs                   \/dev\/shm                tmpfs   defaults        0 0\r\ndevpts                  \/dev\/pts                devpts  gid=5,mode=620  0 0\r\nsysfs                   \/sys                    sysfs   defaults        0 0\r\nproc                    \/proc                   proc    defaults        0 0\r\nLABEL=SWAP-sda2         swap                    swap    defaults        0 0\r\n\r\n\r\n#oralce set for ogg\r\n192.168.137.141:\/mnt\/rac_ogg\/rac_ogg\/rac_ogg \/u01\/app\/ogg\/11.1 nfs defaults 0 0\r\n\r\n<\/pre>\n
\u5728\u5171\u4eab\u7684nfs\u76ee\u5f55\u4e0b\u89e3\u538b\u5e76\u521b\u5efaogg\u76f8\u5173\u76ee\u5f55<\/strong><\/p>\n
\r\n[oracle@OELx64 app]$ mkdir -p ogg\/11.1\r\n[oracle@OELx64 11.1]$ tar -xvf \/tmp\/ggs_Linux_x64_ora11g_64bit_v11_1_1_0_0_078.tar \r\n<\/pre>\n
\u4fee\u6539ogg\u7528\u6237\u7684\u73af\u5883\u53d8\u91cf\uff08\u6b64\u5904\u7684ogg\u7528\u6237\u4e3aoracle\uff09
\n\u5728.bash_profile\u4e2d\u6dfb\u52a0\u4ee5\u4e0b\u6761\u76ee<\/strong><\/p>\n
\r\n#ogg set\r\nOGG_BASE=\/u01\/app\/ogg; export OGG_BASE\r\nOGG_HOME=$OGG_BASE\/11.1; export OGG_HOME\r\nPATH=$OGG_HOME:$PATH; export PATH\r\nexport LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$OGG_HOME:$LD_LIBRARY_PATH\r\n<\/pre>\n
\r\n\r\n[oracle@ora10gr2 11.1]$ pwd\r\n\/u01\/app\/ogg\/11.1\r\n[oracle@ora10gr2 11.1]$ ggsci\r\n\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 \r\nLinux, x86, 32bit (optimized), Oracle 10g on Oct  4 2011 23:54:04\r\n\r\nCopyright (C) 1995, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\n\r\n\r\nGGSCI (ora10gr2) 1> create subdirs\r\n\r\nCreating subdirectories under current directory \/u01\/app\/ogg\/11.1\r\n\r\nParameter files                \/u01\/app\/ogg\/11.1\/dirprm: created\r\nReport files                   \/u01\/app\/ogg\/11.1\/dirrpt: created\r\nCheckpoint files               \/u01\/app\/ogg\/11.1\/dirchk: created\r\nProcess status files           \/u01\/app\/ogg\/11.1\/dirpcs: created\r\nSQL script files               \/u01\/app\/ogg\/11.1\/dirsql: created\r\nDatabase definitions files     \/u01\/app\/ogg\/11.1\/dirdef: created\r\nExtract data files             \/u01\/app\/ogg\/11.1\/dirdat: created\r\nTemporary files                \/u01\/app\/ogg\/11.1\/dirtmp: created\r\nVeridata files                 \/u01\/app\/ogg\/11.1\/dirver: created\r\nVeridata Lock files            \/u01\/app\/ogg\/11.1\/dirver\/lock: created\r\nVeridata Out-Of-Sync files     \/u01\/app\/ogg\/11.1\/dirver\/oos: created\r\nVeridata Out-Of-Sync XML files \/u01\/app\/ogg\/11.1\/dirver\/oosxml: created\r\nVeridata Parameter files       \/u01\/app\/ogg\/11.1\/dirver\/params: created\r\nVeridata Report files          \/u01\/app\/ogg\/11.1\/dirver\/report: created\r\nVeridata Status files          \/u01\/app\/ogg\/11.1\/dirver\/status: created\r\nVeridata Trace files           \/u01\/app\/ogg\/11.1\/dirver\/trace: created\r\nStdout files                   \/u01\/app\/ogg\/11.1\/dirout: created\r\n\r\n<\/pre>\n
\u521b\u5efa\u6570\u636e\u5e93\u7528\u6237<\/strong><\/p>\n
\r\nSQL> select file_name from dba_data_files where rownum<10;\r\n\r\nFILE_NAME\r\n--------------------------------------------------------------------------------\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.432.812066619\r\n+DATA\/racdb\/yallonking_2.dbf\r\n\r\n7 rows selected.\r\n\r\nSQL> create tablespace ogg datafile '+DATA\/racdb\/ogg01.dbf' size 50m autoextend on;\r\n\r\nTablespace created.\r\n\r\nSQL> create user ogg identified by ogg default tablespace ogg quota unlimited on ogg temporary tablespace temp;\r\n\r\nUser created.\r\n\r\nSQL> grant dba to ogg;\r\n\r\nGrant succeeded.\r\n\r\n<\/pre>\n
\u4fee\u65392\u4e2a\u8282\u70b9\u7684\u76d1\u542c\u6587\u4ef6\u914d\u7f6e\uff0c\u9700\u8981\u6dfb\u52a0ASM\u670d\u52a1<\/strong>
\n\u6587\u4ef6\u4f4d\u7f6e\uff1a\/u01\/11.2.0\/grid\/network\/admin\/listener.ora
\n\u8282\u70b91\uff1a<\/p>\n
\r\nSID_LIST_LISTENER =\r\n  (SID_LIST =\r\n    (SID_DESC =\r\n      (GLOBAL_DBNAME = +ASM)\r\n      (ORACLE_HOME = \/u01\/11.2.0\/grid)\r\n      (SID_NAME = +ASM1)\r\n    )\r\n  )\r\n\r\n<\/pre>\n
\u8282\u70b92\uff1a<\/p>\n
\r\nSID_LIST_LISTENER =\r\n  (SID_LIST =\r\n    (SID_DESC =\r\n      (GLOBAL_DBNAME = +ASM)\r\n      (ORACLE_HOME = \/u01\/11.2.0\/grid)\r\n      (SID_NAME = +ASM2)\r\n    )\r\n  )\r\n<\/pre>\n
\u9a8c\u8bc1\u5982\u4e0b<\/strong><\/p>\n
\r\n[oracle@11grac1 ~]$ sqlplus sys\/oracle@192.168.137.165:1521\/+ASM as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 22 15:59:53 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\r\nWith the Real Application Clusters and Automatic Storage Management options\r\n\r\nSQL> \r\n[oracle@11grac1 ~]$ sqlplus sys\/oracle@192.168.137.166:1521\/+ASM as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 22 16:00:51 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\r\nWith the Real Application Clusters and Automatic Storage Management options\r\n\r\nSQL> \r\n<\/pre>\n
\u6ce8\u610f\uff1a\u53ef\u80fd\u9700\u8981\u65e9grid\u4e0b\u4fee\u6539sys\u5bc6\u7801<\/p>\n
\r\n[grid@11grac1 dbs]$ mv orapw+ASM orapw+ASM_bak\r\n[grid@11grac1 dbs]$ orapwd file=orapw+ASM password=oracle entries=10;\r\n\r\n<\/pre>\n
\u4fee\u65392\u4e2a\u8282\u70b9\u7684tnsname.ora<\/strong><\/p>\n
\r\n[oracle@11grac1 ~]$ tail -f \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\r\nASM =\r\n (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.165)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = +ASM)\r\n      (SID_NAME = +ASM1)\r\n    )\r\n  )\r\n\r\nRAC =\r\n(DESCRIPTION=\r\n      (ADDRESS_LIST =\r\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 11grac1-vip)(PORT = 1521))\r\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 11grac2-vip)(PORT = 1521))\r\n       )\r\n       (CONNECT_DATA =\r\n       (SERVER = DEDICATED)\r\n       (SERVICE_NAME = racdb)\r\n    )\r\n  )\r\n\r\n\r\nrac_ogg =\r\n(DESCRIPTION=\r\n      (ADDRESS_LIST =\r\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.174)(PORT = 1521))\r\n       )\r\n       (CONNECT_DATA =\r\n       (SERVER = DEDICATED)\r\n       (SID = rac_ogg)\r\n    )\r\n  )  \r\n\r\n[oracle@11grac2 ~]$ tail -f \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n\r\nASM =  \r\n (DESCRIPTION =  \r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.166)(PORT = 1521))  \r\n    (CONNECT_DATA =  \r\n      (SERVER = DEDICATED)  \r\n      (SERVICE_NAME = +ASM)  \r\n      (SID_NAME = +ASM2)  \r\n    )  \r\n  ) \r\nRAC =\r\n(DESCRIPTION=\r\n      (ADDRESS_LIST =\r\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 11grac1-vip)(PORT = 1521))\r\n        (ADDRESS = (PROTOCOL = TCP)(HOST = 11grac2-vip)(PORT = 1521))\r\n       )\r\n       (CONNECT_DATA =\r\n       (SERVER = DEDICATED)\r\n       (SERVICE_NAME = racdb)\r\n    )\r\n  )\r\n\r\n\r\n<\/pre>\n
\u5728\u4efb\u610f\u8282\u70b9\u914d\u7f6eDDL<\/strong><\/p>\n
\r\nSQL> alter system set recyclebin=off scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter database  add supplemental log data;  \r\nDatabase altered.  \r\n \r\nSQL> alter database  add supplemental log data (primary key) columns;  \r\nDatabase altered.  \r\n \r\nSQL> alter database  add supplemental log data (foreign key) columns;  \r\nDatabase altered.  \r\n \r\nSQL> alter database  add supplemental log data (unique) columns;  \r\nDatabase altered.  \r\n \r\nSQL> alter system archive log current;  \r\nSystem altered.  \r\n \r\nSQL> grant execute on utl_file to ogg;  \r\nGrant succeeded.  \r\n     \r\nSQL> @marker_setup.sql  \r\nSQL> @ddl_setup.sql  \r\nSQL> @role_setup.sql  \r\nSQL> grant ggs_ggsuser_role to ogg;  \r\nSQL> @ddl_enable.sql  \r\nSQL> @ddl_pin ogg \r\n  \r\n<\/pre>\n
\u8282\u70b91\u6784\u5efa\u6d4b\u8bd5\u6570\u636e<\/strong><\/p>\n
\r\nSQL> create tablespace test datafile '+DATA\/racdb\/test01.dbf' size 50m autoextend on;\r\n\r\nTablespace created.\r\n\r\nSQL> create user test identified by test default tablespace test quota unlimited on test temporary tablespace temp;\r\n\r\nUser created.\r\n\r\nSQL> grant resource,connect to test;\r\n\r\nGrant succeeded.\r\n\r\nSQL> conn test\/test\r\nConnected.\r\n\r\nSQL> create table yallonking (id number,name varchar2(20),my_date date);\r\n\r\nTable created.\r\n\r\nSQL> insert into yallonking values(1,'yallonking',sysdate);\r\n\r\n1 row created.\r\n\r\nSQL> commit;\r\n\r\nCommit complete.\r\n\r\nSQL> alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\nSQL> select * from yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 yallonking           2013\/05\/12 10:43:01\r\n\r\n<\/pre>\n
\u767b\u9646\u6e90\u5e93<\/strong><\/p>\n
\r\n[oracle@11grac1 ~]$ \/u01\/app\/ogg\/11.1\/ggsci\r\n\r\nOracle GoldenGate Command Interpreter for Oracle\r\nVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 \r\nLinux, x86, 32bit (optimized), Oracle 11g on Oct  4 2011 23:53:33\r\n\r\nCopyright (C) 1995, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\n\r\n\r\nGGSCI (11grac1) 1> DBLOGIN USERID ogg,PASSWORD ogg\r\nSuccessfully logged into database.\r\n<\/pre>\n
\u4e3b\u5907\u7aef\u914d\u7f6emgr\u8fdb\u7a0b
\n\u6b64\u5904\u6ce8\u610f\u521b\u5efa\u76f8\u5173\u76ee\u5f55<\/strong><\/p>\n
\r\nGGSCI (11grac1) 1> view params mgr\r\n\r\nport 7840\r\nautostart er *  \r\nautorestart er * \r\n\r\n\r\nGGSCI (11grac1) 2> info mgr\r\n\r\nManager is running (IP port 11grac1.7840).\r\n<\/pre>\n
\u6e90\u7aef\u914d\u7f6eextract\u8fdb\u7a0b<\/strong><\/p>\n
\r\nGGSCI (11grac1) 1> dblogin userid ogg,password ogg\r\nSuccessfully logged into database.\r\n\r\nGGSCI (11grac1) 2> add extract ext_test,tranlog,begin now,threads 2\r\nEXTRACT added.\r\n\r\n\r\nGGSCI (11grac1) 4> view params ext_test\r\n\r\nEXTRACT ext_test  \r\nSETENV (ORACLE_HOME = "\/u01\/app\/oracle\/product\/11.2.0\/db_1")  \r\nUSERID ogg@rac, PASSWORD ogg  \r\nTRANLOGOPTIONS ASMUSER sys@ASM,ASMPASSWORD oracle  \r\nTHREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000  \r\nEXTTRAIL \/u01\/app\/ogg\/11.1\/dirdat\/et  \r\nDYNAMICRESOLUTION  \r\nDDL INCLUDE ALL  \r\nTABLE test.*; \r\n\r\nGGSCI (11grac1) 53> add exttrail \/u01\/app\/ogg\/11.1\/dirdat\/et, extract ext_test  \r\nEXTTRAIL added. \r\n\r\n\r\nGGSCI (11grac1) 2> add extract pu_test,exttrailsource \/u01\/app\/ogg\/11.1\/dirdat\/et,begin now\r\nEXTRACT added.\r\n\r\n\r\nGGSCI (11grac1) 3> add rmttrail \/u01\/app\/ogg\/11.1\/dirdat\/rt,extract pu_test  \r\nRMTTRAIL added.\r\n \r\nGGSCI (11grac1) 5> view params pu_test\r\n\r\nEXTRACT pu_test  \r\nRMTHOST 192.168.137.174, MGRPORT 7840 \r\nRMTTRAIL \/u01\/app\/ogg\/11.1\/dirdat\/rt  \r\nPASSTHRU  \r\nTABLE test.*\r\n\r\n<\/pre>\n
\u6e90\u7aef\u914d\u7f6epump\u8fdb\u7a0b<\/strong><\/p>\n
\r\nGGSCI (11grac1) 22> view params pu_test\r\n\r\nextract pu_test\r\ndynamicresolution\r\npassthru\r\nrmthost 192.168.137.174,mgrport 7840,compress\r\nrmttrail \/u01\/app\/ogg\/11.1\/dirdat\/pt\r\ntable test.*;\r\n\r\n\r\nGGSCI (11grac1) 23> add extract pu_test ,exttrailsource \/u01\/app\/ogg\/11.1\/dirdat\/et\r\nERROR: EXTRACT PU_TEST already exists.\r\n\r\n\r\nGGSCI (11grac1) 24> delete pu_test\r\nDeleted EXTRACT PU_TEST.\r\n\r\n\r\nGGSCI (11grac1) 25> add extract pu_test,exttrailsource \/u01\/app\/ogg\/11.1\/dirdat\/et\r\nEXTRACT added.\r\n\r\n\r\nGGSCI (11grac1) 26> add rmttrail \/u01\/app\/ogg\/11.1\/dirdat\/pt,extract pu_test\r\nRMTTRAIL added.\r\n\r\n<\/pre>\n
\u6e90\u7aef\u8fdb\u7a0b\u72b6\u6001\uff1a<\/strong><\/p>\n
\r\nGGSCI (11grac1) 30> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nEXTRACT     RUNNING     EXT_TEST    00:00:01      00:00:00    \r\nEXTRACT     ABENDED     PU_TEST     00:00:00      00:01:33    \r\n<\/pre>\n
\u76ee\u6807\u7aef\u8fdb\u7a0b\u72b6\u6001\uff1a<\/strong><\/p>\n
\r\nGGSCI (x64_ogg) 5> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\n\r\n<\/pre>\n

\n\u4ee5\u4e0b\u4e3a\u6e90\u5e93\u5230\u76ee\u6807\u5e93\u7684\u590d\u5236\u8fc7\u7a0b
\n\u4fee\u6539\u76ee\u6807\u7aef\u7684\u5bc6\u7801\u6587\u4ef6<\/strong><\/p>\n
\r\n[oracle@11grac1 dbs]$ scp orapwracdb1 192.168.137.172:\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs\/orapwrac_ogg\r\norapwracdb1                                                                                       100% 2048     2.0KB\/s   00:00 \r\n\r\n<\/pre>\n
\u4fee\u6539\u76ee\u6807\u7aef\u7684\u76d1\u542c\u6587\u4ef6<\/strong><\/p>\n
\r\n[oracle@x64_ogg ~]$ cat \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/listener.ora\r\nSID_LIST_LISTENER =\r\n  (SID_LIST =\r\n    (SID_DESC =\r\n      (GLOBAL_DBNAME = racdb)\r\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/db_1)\r\n      (SID_NAME = rac_ogg)\r\n    )\r\n  )\r\n\r\nLISTENER =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.174)(PORT = 1521))\r\n  )\r\n\r\nADR_BASE_LISTENER = \/u01\/app\/oracle\r\n\r\n<\/pre>\n
\u6784\u5efa\u5bf9\u7aef\u6570\u636e\u5e93\u53c2\u6570\u6587\u4ef6<\/strong><\/p>\n
\r\n[oracle@x64_ogg ~]$ cat \/tmp\/pfile_ogg \r\n*.__db_cache_size=360710144\r\n*.__java_pool_size=4194304\r\n*.__large_pool_size=4194304\r\n*.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\r\n*.__pga_aggregate_target=213909504\r\n*.__sga_target=633339904\r\n*.__shared_io_pool_size=0\r\n*.__shared_pool_size=255852544\r\n*.__streams_pool_size=0\r\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/racdb\/adump'\r\n*.audit_trail='db'\r\n*.compatible='11.2.0.0.0'\r\n*.control_files='\/u01\/app\/oracle\/oradata\/control01.ctl','\/u01\/app\/oracle\/oradata\/control02.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_file_name_convert='+DATA\/racdb\/datafile','\/u01\/app\/oracle\/oradata','+DATA\/racdb\/tempfile','\/u01\/app\/oracle\/oradata'\r\n*.db_name='rac_ogg'\r\n*.db_recovery_file_dest='\/u01\/app\/oracle'\r\n*.db_recovery_file_dest_size=4039114752\r\n*.diagnostic_dest='\/u01\/app\/oracle'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'\r\n*.instance_number=1\r\n#*.log_archive_dest_1='\/u01\/app\/oracle\/arch'\r\n#*.log_file_name_convert='\/u01\/app\/oracle\/oradata','+DATA\/racdb','+DATA\/racdb\/tempfile',\r\n*.open_cursors=300\r\n*.pga_aggregate_target=210763776\r\n*.processes=150\r\n*.remote_login_passwordfile='exclusive'\r\n*.sga_target=632291328\r\n*.thread=1\r\n*.undo_tablespace='UNDOTBS1'\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u5728\u5bf9\u7aef\u521b\u5efa\u5fc5\u8981\u7684\u76ee\u5f55
\n
\n\u5c06\u53c2\u6570\u6587\u4ef6\u590d\u5236\u5230\u4e3b\u8282\u70b91\u76f8\u540c\u76ee\u5f55<\/strong><\/p>\n
\r\n[oracle@x64_ogg tmp]$ scp pfile_ogg 192.168.137.165:\/tmp\/\r\nThe authenticity of host '192.168.137.165 (192.168.137.165)' can't be established.\r\nRSA key fingerprint is 69:c3:cb:7f:5b:dd:59:a9:5c:94:4e:33:fa:5b:0c:70.\r\nAre you sure you want to continue connecting (yes\/no)? yes\r\nWarning: Permanently added '192.168.137.165' (RSA) to the list of known hosts.\r\noracle@192.168.137.165's password: \r\npfile_ogg                                                                                         100% 1157     1.1KB\/s   00:00  \r\n\r\n<\/pre>\n
\u4f7f\u7528rman\u521d\u59cb\u5316ogg\u76ee\u6807\u5e93<\/strong><\/p>\n
\u6ce8\u610f\u4e3b\u8282\u70b9\u548c\u707e\u5907\u8282\u70b9ogg\u8fdb\u7a0b\u72b6\u6001
\n\u4e3b\u8282\u70b9\uff1a<\/p>\n
\r\nGGSCI (11grac2) 50> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nEXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:00    \r\nEXTRACT     RUNNING     PU_TEST     00:00:00      00:00:04 \r\n<\/pre>\n
\u5907\u8282\u70b9\uff1a\uff08\u6ce8\u610f\u4e0d\u8981\u542f\u52a8replica\u8fdb\u7a0b\uff09<\/strong><\/p>\n
\r\nGGSCI (x64_ogg) 4> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nREPLICAT    STOPPED     REP1        00:00:00      00:00:01\r\n<\/pre>\n
\u5907\u4efd\u4e3b\u6570\u636e\u5e93\uff08\u6ce8\u610f\u9a8c\u8bc1\u5907\u4efd\u53ef\u7528\u6027,\u4ee5\u53ca\u5907\u4efd\u671f\u95f4\u4e3b\u8282\u70b9\u6293\u53d6\u8fdb\u7a0b\u4e0d\u80fd\u6389\uff09<\/strong><\/p>\n
\u67e5\u770b\u6700\u65b0\u7684\u4e8b\u7269\u7684\u5f00\u59cb\u65f6\u95f4\uff0c\u786e\u4fdd\u5907\u4efd\u5728\u8be5\u65f6\u95f4\u4e4b\u540e\u3002<\/strong><\/p>\n
\r\nSQL> select min(to_char(START_TIME,'yyyy\/mm\/dd hh24:mi:ss')) from gv$transaction;\r\n\r\nMIN(TO_CHAR(START_TIME,'YYYY\/MM\/DDHH24:MI:SS'))\r\n--------------------------------------------------------------------------------\r\n\r\n\r\nrun{\r\nallocate channel a1 type disk;\r\nallocate channel a2 type disk;\r\nallocate channel a3 type disk;\r\nbackup full database format '\/tmp\/dbfullbak_%u_%s_%p_%T.bak'; \r\nsql 'ALTER SYSTEM switch logfile';\r\nsql 'ALTER SYSTEM ARCHIVE LOG CURRENT';\r\nbackup archivelog all format '\/tmp\/arc_%T_%s.bak';\r\nbackup current controlfile format '\/tmp\/ctl_%T_%s.bak';\r\nrelease channel a1;\r\nrelease channel a2;\r\nrelease channel a3;\r\n}\r\n\r\n\r\nRMAN> restore database validate;\r\n\r\nStarting restore at 05-MAY-13\r\nusing channel ORA_DISK_1\r\n\r\nchannel ORA_DISK_1: starting validation of datafile backup set\r\nchannel ORA_DISK_1: reading from backup piece +DATA\/racdb\/backupset\/2013_05_05\/nnndf0_tag20130505t111935_0.287.814619979\r\nchannel ORA_DISK_1: piece handle=+DATA\/racdb\/backupset\/2013_05_05\/nnndf0_tag20130505t111935_0.287.814619979 tag=TAG20130505T111935\r\nchannel ORA_DISK_1: restored backup piece 1\r\nchannel ORA_DISK_1: validation complete, elapsed time: 00:00:26\r\nFinished restore at 05-MAY-13\r\n\r\nRMAN> exit\r\n\r\n\r\nRecovery Manager complete.\r\n<\/pre>\n
\u4f20\u8f93\u5907\u4efd\u6587\u4ef6\u5230\u5bf9\u7aef\u76f8\u540c\u76ee\u5f55\u4e0b<\/strong><\/p>\n
\r\n[oracle@11grac1 dbs]$ pwd\r\n\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\r\n[oracle@11grac1 dbs]$ ls -ltr\r\ntotal 16\r\n-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora\r\n-rw-r----- 1 oracle oinstall 1536 May  9 23:03 orapwracdb1\r\n-rw-r----- 1 oracle oinstall   37 May  9 23:07 initracdb1.ora\r\n-rw-rw---- 1 oracle asmadmin 1544 May 12 13:14 hc_racdb1.dat\r\n[oracle@11grac1 dbs]$ scp orapwracdb1 192.168.137.174:\/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwrac_ogg\r\nThe authenticity of host '192.168.137.174 (192.168.137.174)' can't be established.\r\nRSA key fingerprint is 69:c3:cb:7f:5b:dd:59:a9:5c:94:4e:33:fa:5b:0c:70.\r\nAre you sure you want to continue connecting (yes\/no)? yes\r\nWarning: Permanently added '192.168.137.174' (RSA) to the list of known hosts.\r\noracle@192.168.137.174's password: \r\norapwracdb1                                                                                       100% 1536     1.5KB\/s   00:00    \r\n[oracle@11grac1 dbs]$ cd\r\n[oracle@11grac1 ~]$ scp \/tmp\/*.bak 192.168.137.174:\/tmp\/\r\noracle@192.168.137.174's password: \r\ncontrolfile.bak                                                                                   100%   18MB  18.0MB\/s   00:01    \r\ndbfullbak_0ho9evi8_17_1_20130512.bak                                                              100%  604MB   8.2MB\/s   01:14    \r\ndbfullbak_0io9evia_18_1_20130512.bak                                                              100%  421MB   5.7MB\/s   01:14    \r\ndbfullbak_0jo9evia_19_1_20130512.bak                                                              100%   14MB   4.6MB\/s   00:03    \r\ndbfullbak_0lo9evsj_21_1_20130512.bak                                                              100%   96KB  96.0KB\/s   00:00  \r\n\r\n\r\n<\/pre>\n
\u4f7f\u7528\u65b0\u7684\u53c2\u6570\u6587\u4ef6\u5c06\u5bf9\u7aef\u5e93\u542f\u52a8\u5230nomount\u72b6\u6001<\/strong><\/p>\n
\r\n[oracle@x64_ogg ~]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Sun May 12 14:29:25 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL> startup nomount pfile='\/tmp\/pfile_ogg';\r\nORACLE instance started.\r\n\r\nTotal System Global Area  630501376 bytes\r\nFixed Size                  2230992 bytes\r\nVariable Size             264242480 bytes\r\nDatabase Buffers          360710144 bytes\r\nRedo Buffers                3317760 bytes\r\n<\/pre>\n
\u4e3b\u5e93\u590d\u5236\u5230\u5907\u5e93<\/strong><\/p>\n
\r\n[oracle@11grac1 ~]$ rman target \/ auxiliary sys\/oracle@rac_ogg\r\n\r\nRecovery Manager: Release 11.2.0.3.0 - Production on Sun May 12 15:06:43 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.\r\n\r\nconnected to target database: RACDB (DBID=812624383)\r\nconnected to auxiliary database: RAC_OGG (not mounted)\r\n\r\nRMAN> duplicate target database to rac_ogg pfile='\/tmp\/pfile_ogg' logfile\r\n2> '\/u01\/app\/oracle\/oradata\/redo01.dbf' size 50m,\r\n3> '\/u01\/app\/oracle\/oradata\/redo02.dbf' size 50m,\r\n4> '\/u01\/app\/oracle\/oradata\/redo03.dbf' size 50m;\r\n\r\nStarting Duplicate Db at 12-MAY-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_AUX_DISK_1\r\nchannel ORA_AUX_DISK_1: SID=20 device type=DISK\r\n\r\ncontents of Memory Script:\r\n{\r\n   sql clone "create spfile from memory";\r\n}\r\nexecuting Memory Script\r\n\r\nsql statement: create spfile from memory\r\n\r\ncontents of Memory Script:\r\n{\r\n   shutdown clone immediate;\r\n   startup clone nomount;\r\n}\r\nexecuting Memory Script\r\n... ...\r\nExecuting: alter database add supplemental log data\r\nExecuting: alter database add supplemental log data(PRIMARY KEY, UNIQUE, FOREIGN KEY) columns\r\n\r\ncontents of Memory Script:\r\n{\r\n   Alter clone database open resetlogs;\r\n}\r\nexecuting Memory Script\r\n\r\ndatabase opened\r\nFinished Duplicate Db at 12-MAY-13\r\n\r\nRMAN> exit                   \r\n\r\n\r\nRecovery Manager complete.\r\n\r\n\r\n<\/pre>\n
\u5728\u76ee\u6807\u7aef\u67e5\u9a8c\u590d\u5236\u540e\u7684\u7ed3\u679c<\/strong><\/p>\n
\r\nSQL> alter session set nls_date_format='yyyy\/mm\/dd hh24:mi:ss';\r\n\r\nSession altered.\r\n\r\nSQL> show parameter db_name\r\n\r\nNAME                                 TYPE        VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_name                              string      rac_ogg\r\nSQL> select * from test.yallonking;\r\n\r\n        ID NAME                 MY_DATE\r\n---------- -------------------- -------------------\r\n         1 yallonking           2013\/05\/12 10:43:01\r\n\r\n<\/pre>\n
\u67e5\u770b\u590d\u5236\u540e\u7684scn<\/strong><\/p>\n
\r\nSQL> select CHECKPOINT_CHANGE#, FILE# from v$datafile;\r\n\r\nCHECKPOINT_CHANGE#      FILE#\r\n------------------ ----------\r\n           1320159          1\r\n           1320159          2\r\n           1320159          3\r\n           1320159          4\r\n           1320159          5\r\n           1320159          6\r\n           1320159          7\r\n\r\n7 rows selected.\r\n\r\n<\/pre>\n
\u6ce8\u610f\uff1a\u6b64\u5904\u7684scn\uff1a 1320159\u9700\u8981\u5728ogg\u4e2d\u5f00\u542freplica\u8fdb\u7a0b\u65f6\u4f7f\u7528\u3002<\/strong><\/p>\n
\u5728\u76ee\u6807\u7aef\u6dfb\u52a0checkpoint\u5217\u8868<\/strong><\/p>\n
\r\nGGSCI (OELx64) 1> edit params .\/GLOBALS\r\n\r\n\r\nCHECKPOINTTABLE ogg.checkpoint\r\n~\r\nGGSCI (OELx64) 2> dblogin userid ogg\r\nPassword: \r\nSuccessfully logged into database.\r\n\r\nGGSCI (OELx64) 3> add checkpointtable ogg.checkpoint\r\n\r\nSuccessfully created checkpoint table OGG.CHECKPOINT.\r\n<\/pre>\n
\u76ee\u6807\u7aef\u914d\u7f6ereplicat\u8fdb\u7a0b<\/strong><\/p>\n
\r\nGGSCI (x64_ogg) 14> view params rep1\r\n\r\nreplicat rep1\r\nuserid ogg,password ogg\r\nassumetargetdefs\r\nreperror default,discard\r\ndiscardfile \/u01\/app\/ogg\/11.1\/dirrpt\/rep1.dsc,append,megabytes 50\r\ndynamicresolution\r\nmap test.test, target test.test;\r\nmap test.yallonking, target test.yallonking;\r\n\r\nGGSCI (x64_ogg) 12> add replicat rep1,exttrail \/u01\/app\/ogg\/11.1\/dirdat\/pt,checkpointtable ogg.checkpoint\r\nREPLICAT added.\r\n<\/pre>\n
\u6e90\u7aef\u4fe1\u606f<\/strong><\/p>\n
\r\nGGSCI (11grac1) 8> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nEXTRACT     RUNNING     EXT_TEST    00:00:00      00:00:03    \r\nEXTRACT     RUNNING     PU_TEST     00:00:00      00:00:05\r\n\r\n<\/pre>\n
\u76ee\u7684\u7aef\u4fe1\u606f<\/strong><\/p>\n
\r\nGGSCI (x64_ogg) 18> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nREPLICAT    STOPPED     REP1        00:00:00      01:34:41    \r\n\r\nGGSCI (x64_ogg) 14> dblogin userid ogg\r\nPassword: \r\nSuccessfully logged into database.\r\n\r\n\r\nGGSCI (x64_ogg) 16> add checkpointtable ogg.checkpoint\r\n\r\nSuccessfully created checkpoint table OGG.CHECKPOINT.\r\n\r\nGGSCI (x64_ogg) 17> delete replicat rep1\r\nDeleted REPLICAT REP1.\r\n\r\n\r\nGGSCI (x64_ogg) 18> add replicat rep1,exttrail \/u01\/app\/ogg\/11.1\/dirdat\/pt,checkpointtable ogg.checkpoint\r\nREPLICAT added.\r\n\r\n\r\nGGSCI (x64_ogg) 19> start REP1,aftercsn 1320159\r\n\r\nSending START request to MANAGER ...\r\nREPLICAT REP1 starting\r\n\r\n\r\nGGSCI (x64_ogg) 20> info all\r\n\r\nProgram     Status      Group       Lag           Time Since Chkpt\r\n\r\nMANAGER     RUNNING                                           \r\nREPLICAT    RUNNING     REP1        00:00:00      00:00:04    \r\n<\/pre>\n
\u81f3\u6b64\uff0c\u6d4b\u8bd5\u73af\u5883\u5168\u90e8OK\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u672c\u6587\u4e0d\u7275\u626f\u5177\u4f53\u64cd\u4f5c\u7cfb\u7edf\u53caoracle\u8f6f\u4ef6\u7684\u5b89\u88c5\uff0c\u5047\u5b9a\u5728\u5b9e\u65bd\u5b8c\u6bd5\u7684rac\u73af\u5883\u53ca\u5b89\u88c5\u597doracle\u8f6f\u4ef6\u7684\u5355\u673a\u5e73\u53f0\u4e0b […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":[],"categories":[35],"tags":[43],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/853"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=853"}],"version-history":[{"count":10,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/853\/revisions"}],"predecessor-version":[{"id":1464,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/853\/revisions\/1464"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=853"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}