{"id":621,"date":"2019-05-18T08:30:08","date_gmt":"2019-05-18T00:30:08","guid":{"rendered":"http:\/\/www.hefeiyu.com\/?p=621"},"modified":"2019-05-18T08:35:19","modified_gmt":"2019-05-18T00:35:19","slug":"tiptop-%e7%9b%b8%e5%85%b3oracle%e9%83%a8%e5%88%86%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/www.hefeiyu.com\/?p=621","title":{"rendered":"TIPTOP \u76f8\u5173Oracle\u90e8\u5206\u64cd\u4f5c"},"content":{"rendered":"

(\u7ea2\u8272\u4e3a\u8f93\u5165\u547d\u4ee4\uff0c\u84dd\u8272\u4e3a\u89e3\u91ca\u8bf4\u660e\uff0c\u9ed1\u8272\u4e3a\u7cfb\u7edf\u663e\u793a\u3002\u4ee5\u4e0b\u540c)<\/h1>\n

\u4e00\u3001\u767b\u5165Oracle<\/h1>\n\n\n\n\n
[root@TTP-2 ~]# su – oracle<\/span> <<\u5207\u6362\u4e3aoracle\u7528\u6237<\/span><\/strong><\/p>\n

<\/u2\/oracle\/product\/11.2.0\/dbhome_1> export ORACLE_SID=topprod<\/span> <<\u8bbe\u7f6e\u8981\u767b\u9646\u7684\u6570\u636e\u5e93\u7684\u4ee3\u53f7<\/span><\/strong><\/p>\n

<\/u2\/oracle\/product\/11.2.0\/dbhome_1> sqlplus \/ as sysdba<\/span> <<SQLPLUS\u4ee5\u7cfb\u7edf\u7ba1\u7406\u5458\u767b\u9646<\/span><\/strong><\/p>\n

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 5 13:30:14 2012<\/strong><\/p>\n

Copyright (c) 1982, 2010, Oracle. All rights reserved.<\/strong><\/p>\n

Connected to:<\/strong><\/p>\n

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/p>\n

SQL> show user<\/span> <<\u786e\u8ba4\u7528\u6237<\/span><\/strong><\/p>\n

USER is “SYS”<\/strong><\/p>\n

SQL> exit<\/span> <<\u9000\u51faSQLPLUS<\/span><\/strong><\/p>\n

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/td>\n<\/tr>\n

\u9644\u6ce8\uff1a\u64cd\u4f5c\u9700\u5728DB\u4e3b\u673a\u4e0a\u8fdb\u884c<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e8c\u3001\u542f\u52a8Oracle<\/h1>\n\n\n\n\n
[root@TTP-2 ~]# su – oracle<\/span> <<\u5207\u6362\u4e3aoracle\u7528\u6237<\/span><\/strong><\/p>\n

<\/u1\/usr\/oracle> export ORACLE_SID=topprod<\/span> <<\u8bbe\u7f6e\u8981\u542f\u52a8\u7684\u6570\u636e\u5e93\u7684\u4ee3\u53f7<\/span><\/strong><\/p>\n

<\/u1\/usr\/oracle> sqlplus \/ as sysdba<\/span> <<SQLPLUS\u4ee5\u7cfb\u7edf\u7ba1\u7406\u5458\u767b\u9646<\/span><\/strong><\/p>\n

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 6 11:33:11 2012<\/strong><\/p>\n

Copyright (c) 1982, 2010, Oracle. All rights reserved.<\/strong><\/p>\n

Connected to an idle instance.<\/strong><\/p>\n

SQL> startup;<\/span> <<\u542f\u52a8\u6570\u636e\u5e93<\/span><\/strong><\/p>\n

ORACLE instance started.<\/strong><\/p>\n

Total System Global Area 267227136 bytes<\/strong><\/p>\n

Fixed Size 2225632 bytes<\/strong><\/p>\n

Variable Size 167774752 bytes<\/strong><\/p>\n

Database Buffers 92274688 bytes<\/strong><\/p>\n

Redo Buffers 4952064 bytes<\/strong><\/p>\n

Database mounted.<\/strong><\/p>\n

Database opened.<\/strong><\/p>\n

SQL> exit<\/span> <<\u542f\u52a8\u5b8c\u6210\u540e\u9000\u51fa<\/span><\/strong><\/p>\n

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/td>\n<\/tr>\n

\u9644\u6ce8\uff1a\u64cd\u4f5c\u9700\u5728DB\u4e3b\u673a\u4e0a\u8fdb\u884c<\/strong><\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u4e09\u3001\u5173\u95edOracle<\/h1>\n\n\n\n\n
[root@TTP-2 ~]# su – oracle<\/span> <<\u5207\u6362\u4e3aoracle\u7528\u6237<\/span><\/strong><\/p>\n

<\/u1\/usr\/oracle> export ORACLE_SID=gp510<\/span><\/strong><\/p>\n

<\/u1\/usr\/oracle> sqlplus \/ as sysdba<\/span><\/strong><\/p>\n

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 6 11:31:11 2012<\/strong><\/p>\n

Copyright (c) 1982, 2010, Oracle. All rights reserved.<\/strong><\/p>\n

Connected to:<\/strong><\/p>\n

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/p>\n

SQL> shutdown immediate;<\/span> <<\u5173\u95ed\u6570\u636e\u5e93<\/span><\/strong><\/p>\n

Database closed.<\/strong><\/p>\n

Database dismounted.<\/strong><\/p>\n

ORACLE instance shut down.<\/strong><\/p>\n

SQL> exit<\/span> <<\u5b8c\u6210\u5173\u95ed\u540e\u9000\u51fa<\/span><\/strong><\/p>\n

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/td>\n<\/tr>\n

\u9644\u6ce8\uff1a\u64cd\u4f5c\u9700\u5728DB\u4e3b\u673a\u4e0a\u8fdb\u884c<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a><\/a>\u56db\u3001\u67e5\u770bOracle\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5<\/h1>\n\n\n\n\n
[root@TTP-2 ~]# su \u2013 tiptop<\/span> <<\u5728AP\u4e0a\u4ee5tiptop\u7528\u6237\u767b\u9646<\/span><\/strong><\/p>\n

<topprod:\/u1\/topprod\/tiptop> sqlplus system\/manager@topprod<\/span> <<\u4ee5system\u7528\u6237\u767b\u9646\u6570\u636e\u5e93<\/span><\/strong><\/p>\n

SQL> @q_tbsFREE;<\/span> <<\u6267\u884c\u67e5\u770b\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5\u7684\u811a\u672c<\/span><\/strong><\/p>\n

TABLESPACE_NAME BYTES_USED BYTES_FREE LARGEST PERCENT_USED<\/strong><\/p>\n

—————————— ———- ———- ———- ————<\/strong><\/p>\n

SYSTEM 859832320 7143424 6291456 99.17<\/strong><\/p>\n

SYSAUX 713031680 43581440 39911424 93.89<\/strong><\/p>\n

DBS1 4613734400 354418688 126877696 92.32<\/em><\/strong><\/p>\n

BLOBDBS1 314572800 49610752 49283072 84.23<\/strong><\/p>\n

USERS 5242880 4194304 4194304 20<\/strong><\/p>\n

RPTDBS1 2097152000 1941962752 1934229504 7.4<\/em><\/strong><\/p>\n

UNDOTBS1 319815680 301727744 270532608 5.66<\/strong><\/p>\n

TEMPTABS 2097152000 2063400960 1765212160 1.61<\/em><\/strong><\/p>\n

TEMP02 524288000 523239424 523239424 .2<\/strong><\/p>\n

SQL> exit<\/span> <<\u9000\u51faSQLPLUS<\/span><\/strong><\/p>\n

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/td>\n<\/tr>\n

\u9644\u6ce8\uff1a1\uff09\u64cd\u4f5c\u9700\u5728AP\u4e3b\u673a\u4e0a\u8fdb\u884c<\/strong><\/p>\n

2\uff09\u5f53DBS1\u3001RPTDBS1\u3001TEMPTABS\u8868\u7a7a\u95f4\u4f7f\u7528\u7387\u8d85\u8fc780%\u65f6\uff0c\u9700\u53ca\u65f6\u589e\u52a0\u76f8\u5e94\u8868\u7a7a\u95f4<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a><\/a>\u4e94\u3001\u589e\u52a0Oracle\u8868\u7a7a\u95f4<\/h1>\n\n\n\n
<topprod:\/u1\/topprod\/tiptop> sqlplus system\/manager@topprod <\/strong><\/p>\n

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jan 6 12:10:57 2012<\/strong><\/p>\n

Copyright (c) 1982, 2010, Oracle. All rights reserved.<\/strong><\/p>\n

Connected to:<\/strong><\/p>\n

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit Production<\/strong><\/p>\n

With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/p>\n

SQL> select name from v$datafile order by name; <<\u67e5\u770b\u6570\u636e\u6587\u4ef6\u60c5\u51b5<\/strong><\/p>\n

NAME<\/strong><\/p>\n

——————————————————————————<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/blobdbs1.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/dbs1-01.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/dbs1-02.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/dbs1-03.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/dbs1-04.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/dbs1-05.dbf <<dbs1\u8868\u7a7a\u95f4\u6570\u636e\u6587\u4ef6\u6700\u5927\u4ee3\u53f705<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/rptdbs1-01.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/sysaux01.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/system01.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/temp02.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/temptabs.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/undotbs01.dbf<\/strong><\/p>\n

\/u2\/oracle\/oradata\/topprod\/users01.dbf<\/strong><\/p>\n

13 rows selected.<\/strong><\/p>\n

SQL> alter tablespace dbs1 add datafile ‘\/u2\/oracle\/oradata\/topprod\/dbs1-06.dbf’ size 2000M;<\/strong><\/p>\n

<<\u7ed9dbs1\u8868\u7a7a\u95f4\u589e\u52a0\u4ee3\u53f7\u4e3a06\uff0c\u5927\u5c0f\u4e3a2000M\u7684\u6570\u636e\u6587\u4ef6\uff0c\u4f7fdbs1\u6269\u5bb92000M<\/strong><\/p>\n

Tablespace altered.<\/strong><\/p>\n

SQL> @q_tbsFREE; <<\u518d\u89c2\u5bdf\u8868\u7a7a\u95f4\u4f7f\u7528\u60c5\u51b5<\/strong><\/p>\n

SQL>exit <<\u9000\u51faSQLPLUS<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a><\/a>\u516d\u3001\u5904\u7406\u8868\u9501<\/h1>\n\n\n\n\n
[root@TTP-2 ~]# su \u2013 tiptop <<\u5728AP\u4e0a\u4ee5tiptop\u7528\u6237\u767b\u9646<\/strong><\/p>\n

<topprod:\/u1\/topprod\/tiptop> sqlplus system\/manager@topprod <<\u4ee5system\u7528\u6237\u767b\u9646\u6570\u636e\u5e93<\/strong><\/p>\n

SQL> @q_locktable;<\/strong><\/p>\n

Locked Object Tiptop User Proc Terminal SID SERIAL# MACHINE<\/strong><\/p>\n

—————- ———– —– ——– ———- ———- ———-<\/strong><\/p>\n

DS1.NMD_FILE tiptop 7208 29 41921 TTP-2<\/strong><\/p>\n

DS1.NMD_FILE tiptop 13327 1155 54429 TTP-2<\/strong><\/p>\n

SQL> alter system kill session ‘29,41921’ immediate; <<\u6740\u6389\u9020\u6210\u9501\u7684\u4f1a\u8bdd<\/strong><\/p>\n

SQL> alter system kill session ‘1155,54429’ immediate; <<\u6740\u6389\u9020\u6210\u9501\u7684\u4f1a\u8bdd<\/strong><\/p>\n

SQL>exit;<\/strong><\/td>\n<\/tr>\n

\u9644\u6ce8\uff1a1\uff09\u64cd\u4f5c\u9700\u5728AP\u4e3b\u673a\u4e0a\u8fdb\u884c<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/a>\u4e03\u3001\u5907\u4efd\u8fd8\u539fOracle\u6570\u636e<\/h1>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
1\uff09\u5907\u4efdds1\u8425\u8fd0\u4e2d\u5fc3<\/strong><\/td>\n<\/tr>\n
[root@TTP-2 ~]# su \u2013 tiptop<\/strong><\/p>\n

<topprod:\/u1\/usr\/tiptop> exp ds1\/ds1@topprod file=\/tmp\/exp_ds1.dmp log=\/tmp\/exp_ds1.log<\/strong><\/td>\n<\/tr>\n

2\uff09\u5907\u4efdds1\u8425\u8fd0\u4e2d\u5fc3\u7684ima_file\u8868<\/strong><\/td>\n<\/tr>\n
[root@TTP-2 ~]# su \u2013 tiptop<\/strong><\/p>\n

<topprod:\/u1\/usr\/tiptop> exp ds1\/ds1@topprod file=\/tmp\/exp_ds1_ima_file.dmp tables=ima_file<\/strong><\/td>\n<\/tr>\n

3) \u8fd8\u539fds1\u8425\u8fd0\u4e2d\u5fc3<\/strong><\/td>\n<\/tr>\n
[root@TTP-2 ~]# su \u2013 tiptop<\/strong><\/p>\n

<topprod:\/u1\/topprod\/tiptop> sqlplus system\/manager@topprod as sysdba<\/strong><\/p>\n

SQL> drop user ds1 cascade;<\/strong><\/p>\n

SQL>create user ds1 identified by ds1 default tablespace dbs1 temporary tablespace temp;<\/strong><\/p>\n

SQL>grant create session,create table to ds1;<\/strong><\/p>\n

SQL>grant resource to ds1;<\/strong><\/p>\n

SQL>grant create synonym to ds1;<\/strong><\/p>\n

SQL>grant select on sys.v_$session to ds1;<\/strong><\/p>\n

SQL>exit;<\/strong><\/p>\n

<topprod:\/u1\/topprod\/tiptop> imp ds1\/ds1@topprod file=\/tmp\/exp_ds1.dmp log=\/tmp\/imp_ds1.log<\/strong><\/td>\n<\/tr>\n

4) \u8fd8\u539fds1\u8425\u8fd0\u4e2d\u5fc3\u7684ima_file<\/strong><\/td>\n<\/tr>\n
[root@TTP-2 ~]# su \u2013 tiptop<\/strong><\/p>\n

<topprod:\/u1\/topprod\/tiptop> sqlplus ds1\/ds1@topprod <<1.\u767b\u5165ds1\u6570\u636e\u5e93<\/strong><\/p>\n

SQL>create table ima_file_bak as select * from ima_file; <<2.\u5907\u4efdima_file\u5230ima_file_bak<\/strong><\/p>\n

SQL> truncate table ima_file; <<3.\u6e05\u7a7aima_file\u8868\u6570\u636e<\/strong><\/p>\n

SQL> exit; <<4.\u9000\u51faSQLPLUS<\/strong><\/p>\n

<topprod:\/u1\/topprod\/tiptop> imp ds1\/ds1@topprod file=\/tmp\/exp_ds1.dmp tables=ima_file ignore=y;<\/strong><\/p>\n

<<5.\u5bfc\u5165ima_file\u6570\u636e<\/strong><\/td>\n<\/tr>\n

5) \u5907\u4efd\u6574\u4e2a\u6570\u636e\u5e93<\/strong><\/td>\n<\/tr>\n
<topprod:\/u1\/usr\/tiptop> exp system\/manager@topprod file=\/tmp\/exp_all.dmp full=y<\/strong><\/td>\n<\/tr>\n
6) \u8fd8\u539f\u6574\u4e2a\u6570\u636e\u5e93<\/strong><\/td>\n<\/tr>\n
\n
    \n
  1. \u91cd\u5efa\u6574\u4e2atopprod\u5b9e\u4f8b<\/strong><\/li>\n
  2. \u5bfc\u5165\u4e4b\u524d\u7684exp_all.dmp\u5907\u4efd<\/strong><\/li>\n<\/ol>\n

    <topprod:\/u1\/usr\/tiptop>imp system\/manager@topprod file=\/tmp\/exp_all.dmp ignore=y<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    \u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u8d6b\u975e\u57df<\/a> » TIPTOP \u76f8\u5173Oracle\u90e8\u5206\u64cd\u4f5c<\/a><\/p>","protected":false},"excerpt":{"rendered":"

    (\u7ea2\u8272\u4e3a\u8f93\u5165\u547d\u4ee4\uff0c\u84dd\u8272\u4e3a\u89e3\u91ca\u8bf4\u660e\uff0c\u9ed1\u8272\u4e3a\u7cfb\u7edf\u663e\u793a\u3002\u4ee5\u4e0b\u540c) \u4e00\u3001\u767b\u5165Oracle [root@TTP-2 ~]# su – oracle <<\u5207\u6362\u4e3aoracle\u7528\u6237 <\/u2\/oracle\/product\/11.2.0\/ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[51,10,212],"class_list":["post-621","post","type-post","status-publish","format-standard","hentry","category-unix","tag-oracle","tag-tiptop","tag-212"],"_links":{"self":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=621"}],"version-history":[{"count":3,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/621\/revisions"}],"predecessor-version":[{"id":624,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=\/wp\/v2\/posts\/621\/revisions\/624"}],"wp:attachment":[{"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hefeiyu.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}