数据库数据恢复操作记录1128.doc

数据库数据恢复操作记录 1128 Connecting to :22... Connection established. Escape character is '^@]'. Last login: Mon Nov 28 11:57:14 2011 from JSBC-SIHUA-DB01:~ # ps -ef |grep ora root 4655 4524 0 Nov11 ? 00:00:48 hald-addon-storage: polling /dev/sr0 (every 16 sec) oracle 7443 10 Nov11 ? 00:03:41 ora_pmon_sihua oracle 7445 10 Nov11 ? 00:00:28 ora_psp0_sihua oracle 7447 10 Nov11 ? 00:00:19 ora_mman_sihua oracle 7449 10 Nov11 ? 00:01:18 ora_dbw0_sihua oracle 7451 10 Nov11 ? 00:01:15 ora_dbw1_sihua oracle 7453 10 Nov11 ? 00:01:16 ora_dbw2_sihua oracle 7455 10 Nov11 ? 00:01:18 ora_dbw3_sihua oracle 7457 10 Nov11 ? 00:04:07 ora_lgwr_sihua oracle 7459 10 Nov11 ? 00:05:51 ora_ckpt_sihua oracle 7461 10 Nov11 ? 00:01:17 ora_smon_sihua oracle 7463 10 Nov11 ? 00:00:00 ora_reco_sihua oracle 7477 10 Nov11 ? 00:00:29 ora_arc0_sihua oracle 7479 10 Nov11 ? 00:00:38 ora_arc1_sihua oracle 7510 10 Nov11 ? 00:00:40 /oracle/product/10g/bin/tnslsnr LISTENER -inherit oracle 19459 10 Nov18 ? 00:00:15 oraclesihua (LOCAL=NO) root 42514 42162 0 11:40 pts/0 00:00:00 su- oracl e oracle 42515 42514 0 11:40 pts/0 00:00:00 -bash oracle 42693 42515 0 11:56 pts/0 00:00:00 lsnrctl sto p root 42746 42701 0 11:59 pts/1 00:00:00 su- oracl e oracle 42747 42746 0 11:59 pts/1 00:00:00 -bash oracle 42773 42747 0 11:59 pts/1 00:00:00 sqlplus oracle 42775 42773 0 11:59 ? 00:00:00 oraclesihua (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) root 42848 42815 0 12:02 pts/2 00:00:00 grep ora oracle 81916 10 Nov17 ? 00:00:08 oraclesihua (LOCAL=NO) JSBC-SIHUA-DB01:~ # su- oracle ******@JSBC-SIHUA-DB01:~> sqlplus /nolog SQL*Plus: Release - Production on Mon Nov 28 12:02:26 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn /as/sysdba SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] |/ SQL> bye SP2-0042: mand "bye" - rest of line ignored. SQL> bye SP2-0042: mand "bye" - rest of line