{"id":456,"date":"2020-02-22T17:47:40","date_gmt":"2020-02-22T09:47:40","guid":{"rendered":"http:\/\/www.821121.com\/?p=456"},"modified":"2020-12-11T09:59:43","modified_gmt":"2020-12-11T01:59:43","slug":"oracle11gracfor%e5%8d%95%e5%ae%9e%e4%be%8bdg%e6%90%ad%e5%bb%ba","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=456","title":{"rendered":"oracle11gRACfor\u5355\u5b9e\u4f8bDG\u642d\u5efa"},"content":{"rendered":"
\u4e3b\u5e93\uff1a\n\u8282\u70b91\uff1a\nip\uff1a192.168.174.144     \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11gRAC    sys\u5bc6\u7801\uff1a123456  \ndb_name=racdb,\u5373instance_name\u3001db_unique_name \u3001service_name\u90fd\u4e3aracdb\n\n\u8282\u70b92\uff1a\nip\uff1a192.168.174.145     \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11gRAC    sys\u5bc6\u7801\uff1a123456  \ndb_name=racdb,\u5373instance_name\u3001db_unique_name \u3001service_name\u90fd\u4e3aracdb\n\n\u5907\u5e93\uff1a\nip\uff1a192.168.174.158     \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11g\u5355\u5b9e\u4f8b    sys\u5bc6\u7801\uff1a123456 \n\n\u642d\u5efa\u524d\u51c6\u5907\uff1a\n\u9700\u8981\u5728158\u4e24\u53f0\u670d\u52a1\u5668\u5148\u884c\u5b89\u88c5\u597doracle11g\u6570\u636e\u5e93\uff0c\u4e14\u90fd\u672a\u521b\u5efa\u5b9e\u4f8b\uff0c\u5907\u5e93\u7684db_name\u4e00\u5b9a\u4e0e\u4e3b\u5e93\u4e00\u81f4\uff0cdb_unique_name\uff0c3\u4e2a\u5e93\u9700\u8981\u4e00\u5b9a\u4e0d\u4e00\u6837\uff0c\u5176\u4f59\u968f\u610f<\/code><\/pre>\n
1\u3001\u642d\u5efadataguard<\/h1>\n
\u5224\u65ad\u4e3b\u5e93DG\u662f\u5426\u5df2\u7ecf\u5b89\u88c5\uff1a\nselect * from v$option where parameter = 'Oracle Data Guard';\n\u5982\u679c\u662ftrue\u8868\u793a\u5df2\u7ecf\u5b89\u88c5\u53ef\u4ee5\u914d\u7f6e\uff0c\u5426\u5219\u9700\u8981\u5b89\u88c5\u76f8\u5e94\u7ec4\u4ef6\u3002\n\u5982\u679c\u4e0d\u77e5\u9053\u4e3b\u5e93sys\u5bc6\u7801\uff0c\u5219\u4fee\u6539\u4e3b\u5e93sys\u7528\u6237\u5bc6\u7801\uff1a\nalter user sys identified by 123456;\n\n\u786e\u8ba4\u4e3b\u5e93\u662f\u5426\u5f00\u542farchivelog\u4e0eforce log\n   startup  mount\nalter database force logging;\/\/\u4fee\u6539\u6570\u636e\u5e93\u4e3a\u5f3a\u5236\u8bb0\u65e5\u5fd7\uff0c\u8fd9\u662f\u5fc5\u987b\u7684\u64cd\u4f5c\uff0c\u4e3b\u5e93\u7684\u6bcf\u4e00\u6b65\u64cd\u4f5c\u90fd\u5f97\u8bb0\u5f55\u5230\u65e5\u5fd7\u4e2d\u53bb\u3002??\narchive log list;\/\/--\u4fee\u6539\u6570\u636e\u5e93\u4e3a\u5f52\u6863\u6a21\u5f0f\uff0c\u56e0\u4e3adg\u662f\u901a\u8fc7\u4f20\u9001\u5f52\u6863\u65e5\u5fd7\u5230\u5907\u5e93\u7136\u540e\u5e94\u7528\u6765\u4fdd\u8bc1\u4e3b\u5907\u5e93\u4e00\u81f4\u7684\u3002??\nselect log_mode,force_logging from v$database; --\u68c0\u67e5\nalter database force logging; --\u5f00\u542f\n\narchive log list;\nalter database archivelog;<\/code><\/pre>\n
2\u3001\u914d\u7f6e\u4e3b\u3001\u5907\u5e93\u76d1\u542c\uff0ctns\u8fde\u63a5\u4e32<\/h1>\n
\u914d\u7f6e\u4e3b\u5e93\u76d1\u542c\uff0c2\u4e2a\u8282\u70b9\u90fd\u9700\uff1a\uff08\u4e3b\u5e93\u7684\u76d1\u542c\u53ef\u4e0d\u52a8\uff0c\u751f\u4ea7\u73af\u5883\u5c3d\u91cf\u4e0d\u52a8\uff09\n\ncd $ORACLE_HOME\/network\/admin\n vi listener.ora\n\n\u52a0\u5165\u4ee5\u4e0b\u5185\u5bb9\n\u8282\u70b91\uff1a\nSID_LIST_LISTENER=\n  (SID_LIST=\n       (SID_DESC=\n         (GLOBAL_DBNAME= racdb)\n         (ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/)\n         (SID_NAME = racdb1) \/\/\u5b9e\u4f8b\u540d\n        )\n)\nsrvctl stop listener -n rac1(\u4e3b\u673a\u540d)\nsrvctl start listener -n rac1\nlsnrctl status\n\n\u8282\u70b92\uff1a\nSID_LIST_LISTENER=\n  (SID_LIST=\n      (SID_DESC=\n         (GLOBAL_DBNAME= racdb)\n         (ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/)\n         (SID_NAME = racdb2)\n        )\n       )\n      )\nsrvctl stop listener -n rac2\nsrvctl start listener -n rac2\nlsnrctl status\n\n\u5907\u5e93:\u5fc5\u987b\u662f\u9759\u6001\u76d1\u542c\nsu - oracle\ncd $ORACLE_HOME\/network\/admin\nvi listener.ora\n\u52a0\u4e0a\u5982\u4e0b\u8bed\u53e5\uff1a\nSID_LIST_LISTENER =\n  (SID_LIST =\n    (SID_DESC =\n      (GLOBAL_DBNAME = orcl)\n      (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0.4\/db_1)\n      (SID_NAME = orcl)\n    )\n  )\n\nLISTENER =\n  (DESCRIPTION_LIST =\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))\n    )\n    (DESCRIPTION =\n      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))\n    )\n  )\n\nADR_BASE_LISTENER = \/u01\/app\/oracle\n\n\u91cd\u542f\u5907\u5e93\u76d1\u542c\nlsnrctl reload \n\u7136\u540e\u518d\u67e5\u770b\u76d1\u542c\u72b6\u6001\nlsnrctl status <\/code><\/pre>\n
\u4e3b\u5907\u5e93\u90fd\u914d\u7f6etnsnames.ora(\u5747\u4e3aoracle\u7528\u6237\uff0c\u4e3b\u5e932\u4e2a\u8282\u70b9\u90fd\u8981)\nsu - oracle\ncd $ORACLE_HOME\/network\/admin\nvi tnsnames.ora\nracdb =\n (DESCRIPTION =\n   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.144)(PORT = 1521))\n   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.145)(PORT = 1521))\n   (CONNECT_DATA =\n    (SERVER = DEDICATED)\n    (SERVICE_NAME =racdb)\n    )\n  )\norcl =\n  (DESCRIPTION =\n    (ADDRESS_LIST =\n      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.174.158)(PORT = 1521))\n    )\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = orcl)\n)\n\uff09<\/code><\/pre>\n
3\u3001\u914d\u7f6e\u4e3b\u5e93standby redo log\uff0c\u5e76\u9a8c\u8bc1\u7ed3\u679c<\/h1>\n
\u67e5\u770b\u662f\u5426\u5df2\u7ecf\u5b58\u5728standby redo log\nselect group#, thread#, sequence#, archived, status from v$standby_log;\n\u5b58\u5728\u5c31\u4e0d\u7528\u6309\u7167\u4ee5\u4e0b\u5185\u5bb9\u521b\u5efa\u3002\n\n\u6839\u636e\u4ee5\u4e0bsql\u67e5\u8be2\u7684\u7ed3\u679c\uff0c\u521b\u5efastandby redo log\u3002\nselect GROUP#,THREAD#,BYTES from v$log ;\nselect MEMBER from v$logfile;  \/\/\u6ce8\u610f\u65e5\u5fd7\u6587\u4ef6\u7684\u6240\u6709\u8def\u5f84\uff0c\u6240\u6709\u65e5\u5fd7\u90fd\u8981\u62f7\u8fc7\u6765\n\u6839\u636e\u4ee5\u4e0a\u67e5\u8be2\u7ed3\u679c\u521b\u5efastandby redo log\uff0c\u521b\u5efa\u539f\u5219thread\u8981\u4e00\u6837\u591a\uff0c\u540c\u4e2athread\u4e2d\u8981\u6bd4redo\u591a\u4e00\u4e2agroup\uff1a\nALTER DATABASE ADD STANDBY LOGFILE thread 1 '+DATA2\/racdb\/onlinelog\/stbredo11.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 1 '+DATA2\/racdb\/onlinelog\/stbredo12.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 1 '+DATA2\/racdb\/onlinelog\/stbredo13.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 2 '+DATA2\/racdb\/onlinelog\/stbredo14.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 2 '+DATA2\/racdb\/onlinelog\/stbredo15.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 2 '+DATA2\/racdb\/onlinelog\/stbredo16.log' SIZE 50m;\n\n\u68c0\u67e5\u521b\u5efastandby redo log\u7ed3\u679c\nselect group#, thread#, sequence#, archived, status from v$standby_log;<\/code><\/pre>\n
4\u3001\u914d\u7f6e\u4e3b\u5e93\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6<\/h1>\n
\u4e3b\u5e93\uff1a\n\nalter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(racdb, orcl)' scope=both;\nALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DATA2\/racdb\/  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=racdb' scope=both;\nALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl' scope=both;\nALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=ENABLE scope=both;\nALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE scope=both;\nALTER SYSTEM SET FAL_SERVER = orcl scope=both;\nalter system set STANDBY_FILE_MANAGEMENT='AUTO'scope=both;<\/code><\/pre>\n
5\u3001\u5907\u5e93\u7684\u76f8\u5e94\u914d\u7f6e<\/h1>\n
\u5c06\u4e3b\u5e93\u7684\u5bc6\u7801\u6587\u4ef6\u3001pfile\u62f7\u8d1d\u5230\u5907\u5e93\u3002\n\nPfile\u751f\u6210\uff1a\ncreate pfile='\/tmp\/racdb.ora' from spfile;\n\u5c06pfile\u6587\u4ef6\u62f7\u8d1d\u5230\u5907\u5e93\uff1a\/tmp\n\u5c06\u5bc6\u7801\u6587\u4ef6\u62f7\u8d1d\u5230\u5907\u5e93\uff1a$ORACLE_HOME\/dbs \/\/\/12C\u7684\u5bc6\u7801\u6587\u4ef6\u8981\u53bbasm\u7ba1\u7406\u4e2d\u53bb\u627e\u3002\n\u5728\u5907\u5e93oracle\u7528\u6237\u6267\u884c\nscp @192.168.174.144:\/tmp\/racdb.ora  \/tmp\nscp @192.168.174.144:$ORACLE_HOME\/dbs\/orapwracdb1 $ORACLE_HOME\/dbs\n\n\u5bc6\u7801\u6587\u4ef6\u62f7\u8d1d\u5230\u5907\u5e93\u540e\uff0c\u9700\u8981\u4fee\u6539\u6587\u4ef6\u540d\u3002\u683c\u5f0f\u4e3aorapw+ORACLE_SID\n\u4e3b\u5907\u5e93\u90fd\u6d4b\u8bd5\u8054\u901a\u6027\uff1a\nsqlplus sys\/123456@racdb as sysdba\nsqlplus sys\/123456@orcl as sysdba<\/code><\/pre>\n
6.pfile\u7684\u53c2\u6570\u914d\u7f6e<\/h1>\n
\u5907\u5e93\uff1a\u7f16\u8f91\/tmp\/orcl.ora\uff0c\u4fee\u6539\u4e3a\u4ee5\u4e0b\u5185\u5bb9\uff1a\uff08\u6a21\u677f\uff09\n*.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\/\/oracle\u57fa\u76ee\u5f55\n*.audit_file_dest='\/u01\/topprddg\/adump'\/\/\u5ba1\u8ba1\u76ee\u5f55\n*.audit_trail='db'  \/\/\u5ba1\u8ba1\u8ddf\u8e2a\n*.compatible='12.2.0'  \/\/\u7248\u672c\u53f7\n*.control_files='\/u01\/topprddg\/controlfile\/control01.ctl','\/u01\/topprddg\/controlfile\/control02.ctl','\/u01\/topprddg\/controlfile\/control03.ctl'#Restore Controlfile  \/\/\u63a7\u5236\u6587\u4ef6\u76ee\u5f55\uff0c\u6ce8\u610f\/u01\u7684\u8def\u5f84\n*.db_file_name_convert='+DATA\/topprd\/datafile\/','\/u01\/topprddg\/datafile\/'  \/\/\u6570\u636e\u6587\u4ef6\u76ee\u5f55\uff0c\u524d\u4e3b\u5e93\uff0c\u540e\u5907\u5e93\n*.db_block_size=8192  \/\/\u5757\u5927\u5c0f\n*.db_name='topprd'  \/\/\u4e3b\u5e93\u540d\n*.db_unique_name='topprddg'   \/\/\u5907\u5e93\u540d\n*.diagnostic_dest='\/u01\/app\/oracle' \/\/\u5b9e\u4f8b\u3001asm\u3001\u76d1\u542c\u65e5\u5fd7\u8def\u5f84\n*.fal_client='topprddg'  \/\/\u5907\u5e93\n*.fal_server='topprd'    \/\/\u4e3b\u5e93\n*.log_archive_config='DG_CONFIG=(topprddg, topprd)'  \/\/\u914dDG,\u524d\u4e3b\u7aef\uff0c\u540e\u5bf9\u7aef\u3002\n*.log_archive_dest_1='LOCATION=\/u01\/topprddg\/archivelog\/  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=topprddg'  \/\/\u5f52\u6863\u6587\u4ef6\u8def\u5f84\n*.log_archive_dest_2='SERVICE=topprd LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=topprd'   \/\/\u5bf9\u7aef\u7684\u8fde\u63a5\u4e32\uff0c\u5bf9\u7aef\u7684\u670d\u52a1\u540d\n*.log_file_name_convert='+DATA\/TOPPRD\/ONLINELOG\/','\/u01\/topprddg\/logfile1\/','+DATA\/TOPPRD\/DATAFILE\/','\/u01\/topprddg\/logfile2\/'     \/\/\u65e5\u5fd7\u6587\u4ef6\u76ee\u5f55\uff0c\u8981\u5168\u62f7\u8fc7\u6765\uff0c\u8981\u6ce8\u610f\u770b\u6709\u51e0\u4e2a\u8def\u5f84\u3002\n*.log_archive_dest_state_2='ENABLE'   \n*.standby_file_management='AUTO'<\/code><\/pre>\n
\u5907\u5e93pifle\u53c2\u6570\uff1a\n*.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\n*.audit_file_dest='\/orcl\/adump'\n*.audit_trail='db'  \n*.compatible='11.2.0.4.0'\n*.control_files='\/orcl\/controlfile\/control01.ctl','\/orcl\/controlfile\/control02.ctl','\/orcl\/controlfile\/control03.ctl'#Restore Controlfile\n*.db_file_name_convert='+DATA2\/racdb\/datafile\/','\/orcl\/datafile\/' \n*.db_block_size=8192  \n*.db_name='racdb'  \n*.db_unique_name='orcl'   \n*.diagnostic_dest='\/u01\/app\/oracle'\n*.fal_client='orcl'\n*.fal_server='racdb'\n*.log_archive_config='DG_CONFIG=(orcl, racdb)'\n*.log_archive_dest_1='LOCATION=\/orcl\/archivelog\/  VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'\n*.log_archive_dest_2='SERVICE=racdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdb'\n*.log_file_name_convert='+DATA\/racdb\/onlinelog\/','\/orcl\/logfile1\/','+DATA2\/racdb\/onlinelog\/','\/orcl\/logfile2\/'\n*.log_archive_dest_state_2='ENABLE'\n*.standby_file_management='AUTO'\n\ncp \/tmp\/racdb.ora\u6587\u4ef6\u540d\u4e3a \/tmp\/racdb_bak.ora\n\u4fee\u6539\/tmp\/racdb.ora\u6587\u4ef6\u540d\u4e3a\/tmp\/orcl.ora\n\u7528oracle\u7528\u6237\u5728\u5907\u5e93\u521b\u5efa\u4e0a\u9762\u6d89\u53ca\u5230\u7684\u8def\u5f84\uff0c\u5728\u5b9e\u9645\u73af\u5883\u4e2d\u4e00\u5b9a\u67e5\u770b\u597d\u5b9e\u4f53\u673a\u7684\u78c1\u76d8\u5927\u5c0f\uff0c\u9009\u597d\u8db3\u591f\u5927\u7684\u8def\u5f84\u78c1\u76d8\u3002\uff08\u76f8\u5173\u7684\u8def\u5f84\u914d\u7f6e\uff0c\u53ef\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u4fee\u6539\uff09\nmkdir -p \/orcl\/adump\nmkdir -p \/orcl\/controlfile\nmkdir -p \/orcl\/datafile\nmkdir -p \/orcl\/archivelog\nmkdir -p \/orcl\/logfile1\nmkdir -p \/orcl\/logfile2<\/code><\/pre>\n
7\u3001\u5907\u5e93\uff1a\u4ee5pfile\u521b\u5efaspfile\u5e76\u542f\u52a8\u6570\u636e\u5e93\u5230nomount\uff1a<\/h1>\n
create spfile from pfile='\/tmp\/orcl.ora';\nstartup nomount<\/code><\/pre>\n
8\u3001\u590d\u5236\u6570\u636e<\/h1>\n
\u5907\u5e93vi duplicate.sh\u540e\u53f0\u8fd0\u884c\uff1a\n\nvi \/home\/oracle\/duplicate.sh\nrman target sys\/123456@racdb auxiliary sys\/123456@orcl nocatalog> duplicate.log <<EOF\nduplicate target database for standby from active database nofilenamecheck;\nEOF\n\ncd ~\nchmod a+x duplicate.sh\nnohup .\/duplicate.sh &\nsar -n DEV 1 100\niostat -xdk\n\u89c2\u5bdf\u65e5\u5fd7duplicate.log\u7b49\u5f85\u5b8c\u6210\u3002\n\n\u4ee5\u4e0b\u4e3a\u540c\u6b65\u5f52\u6863\uff0c\u9884\u8ba1\u65f6\u95f4\u6bd4\u8f83\u4e45\uff0c\u53ef\u4ee5\u5148\u505a\u540e\u9762\u7684\u6b65\u9aa4\nSQL> alter database recover managed standby database disconnect from session;<\/code><\/pre>\n
9\u3001\u5f00\u542fdg_broker<\/h1>\n
\u4e3b\u5e93\uff1a\nalter system set dg_broker_start=false scope=bothsid='*';\nalter system set dg_broker_config_file1='+MESDG2\/dr1EPIMES.dat' sid='*';\nalter system set dg_broker_config_file2='+MESDG2\/dr2EPIMES.dat' sid='*';\nalter system set dg_broker_start=true scope=bothsid='*';\n\n\u5907\u5e93\uff1a\nalter system set dg_broker_start=true scope=both;\n\n\u4e3b\u5e93\uff0c\u914d\u7f6edgmgrl\n[oracle@dbsource admin]$ dgmgrl \/\nDGMGRL for Linux: Version 11.2.0.2.0 - 64bit Production\n\nCopyright (c) 2000, 2009, Oracle. All rights reserved.\n\nWelcome to DGMGRL, type "help" for information.\nConnected.\nDGMGRL> CREATE CONFIGURATION dg_epimesas  PRIMARY DATABASE IS EPIMES  CONNECT IDENTIFIER IS EPIMES;\nConfiguration "dg_epimes" created with primary database "epimes"\nDGMGRL> enable CONFIGURATION\nEnabled.\nDGMGRL> add database EPIMESDG  as  CONNECT IDENTIFIER IS EPIMESDG;\nDatabase "epimesdg" added\nDGMGRL> show database verbose EPIMESDG<\/code><\/pre>\n
10\u3001\u67e5\u770b\u5f52\u6863\u662f\u5426\u540c\u6b65\u5b8c\u6210<\/h1>\n
\u4e3b\u5e93\uff1a\nSQL> select * from ( select sequence#,applied from v$archived_log where dest_id=2 order by first_time  desc) where rownum<=10;\n\n SEQUENCE# APPLIED\n---------- ---------\n        22 YES\n        23 YES\n        24 IN-MEMORY\n\n\u5907\u5e93\uff1a\nSQL> select * from ( select sequence#,applied from v$archived_log where dest_id=1 order by first_time desc) where rownum<=10;<\/code><\/pre>\n
11\u3001\u4f7f\u752811G Data Guard\u65b0\u7279\u6027\uff0cArchive Data Guard<\/h1>\n
\u5728\u5907\u5e93\u8fd0\u884c\uff1a\nSQL> recover managed standby database cancel; \nMedia recovery complete.\n\nSQL> alter database open read only;\n\nDatabase altered.\n\nSQL> alter database recover managed standby database using current logfile disconnect from session;\n\nDatabase altered.\n\n\u5728\u4e3b\u5e93\u8fd0\u884c\uff0c\u786e\u8ba4\u662f\u5426\u6709\u65ad\u5c42\n\nSQL> select STATUS, GAP_STATUS from V$ARCHIVE_DEST_STATUS where DEST_ID = 2;\n\nSTATUS    GAP_STATUS\n--------- ------------------------\nVALID     NO GAP\n<\/code><\/pre>\n
12\u3001\u4e3b\u5e93\u521b\u5efa\u4e34\u65f6\u8868\u786e\u8ba4\u662f\u5426\u6b63\u5e38\u540c\u6b65<\/h1>\n
\u4e3b\u5e93\uff1a\ncreate table test as select * from dual;\n\n\u5907\u5e93\uff1a\nselect * from test;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u4e3b\u5e93\uff1a \u8282\u70b91\uff1a ip\uff1a192.168.174.1<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,37,40],"tags":[],"class_list":["post-456","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=456"}],"version-history":[{"count":2,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/456\/revisions"}],"predecessor-version":[{"id":459,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/456\/revisions\/459"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=456"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}