SSH Secure Shell 3.2.9 (Build 283)
Copyright (c) 2000-2003 SSH Communications Security Corp - http://www.ssh.com/
This copy of SSH Secure Shell is a non-commercial version.
This version does not include PKI and PKCS #11 functionality.
Last login: Wed Sep 25 17:06:45 2013 from 192.168.0.122
[root@OS4 ~]# su - oracle
[oracle@OS4 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 26 09:18:43 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
09:18:43 SQL> conn scott/tiger
Connected.
09:18:48 SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10
14 rows selected.
09:24:45 SQL> select dbms_rowid.rowid_relative_fno(rowid) rel_fno,dbms_rowid.rowid_block_number(rowid) blockno,dbms_rowid.rowid_row_number(rowid) rowno from emp;
REL_FNO BLOCKNO ROWNO
---------- ---------- ----------
4 151 0
4 151 1
4 151 2
4 151 3
4 151 4
4 151 5
4 151 6
4 151 7
4 151 8
4 151 9
4 151 10
4 151 11
4 151 12
4 151 13
14 rows selected.
Elapsed: 00:00:00.01
09:31:58 SQL> conn / as sysdba
09:32:30 SQL> select file#,name from v$datafile;
FILE# NAME
---------- ------------------------------------------------------------
1 /opt/oracle/oradata/ninvoice/system01.dbf
2 /opt/oracle/oradata/ninvoice/sysaux01.dbf
3 /opt/oracle/oradata/ninvoice/undotbs01.dbf
4 /opt/oracle/oradata/ninvoice/users01.dbf
5 /opt/oracle/oradata/ninvoice/ninvoice.dbf
6 /opt/oracle/oradata/ninvoice/NETINVOICE01.dbf
7 /opt/oracle/oradata/ninvoice/NETINVOICE_IDX01.dbf
8 /opt/oracle/oradata/ninvoice/MTCLUSTER.dbf
9 /opt/oracle/oradata/ninvoice/MAIN_MAXVLUES.dbf
10 /opt/oracle/oradata/ninvoice/MAIN_2010_02.dbf
11 /opt/oracle/oradata/ninvoice/MAIN_2011_01.dbf
12 /opt/oracle/oradata/ninvoice/MAIN_2011_02.dbf
13 /opt/oracle/oradata/ninvoice/MAIN_2012_02.dbf
14 /opt/oracle/oradata/ninvoice/MAIN_2012_01.dbf
15 /opt/oracle/oradata/ninvoice/MAIN_2013_01.dbf
16 /opt/oracle/oradata/ninvoice/MTCLUSTER_IDX.dbf
17 /opt/oracle/oradata/ninvoice/ggate01.dbf
17 rows selected.
Elapsed: 00:00:00.00
09:32:31 SQL> exit
09:32:37 SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@OS4 ~]$ vi /tmp/f.lst
1 /opt/oracle/oradata/ninvoice/system01.dbf
2 /opt/oracle/oradata/ninvoice/sysaux01.dbf
3 /opt/oracle/oradata/ninvoice/undotbs01.dbf
4 /opt/oracle/oradata/ninvoice/users01.dbf
5 /opt/oracle/oradata/ninvoice/ninvoice.dbf
6 /opt/oracle/oradata/ninvoice/NETINVOICE01.dbf
7 /opt/oracle/oradata/ninvoice/NETINVOICE_IDX01.dbf
8 /opt/oracle/oradata/ninvoice/MTCLUSTER.dbf
9 /opt/oracle/oradata/ninvoice/MAIN_MAXVLUES.dbf
10 /opt/oracle/oradata/ninvoice/MAIN_2010_02.dbf
11 /opt/oracle/oradata/ninvoice/MAIN_2011_01.dbf
12 /opt/oracle/oradata/ninvoice/MAIN_2011_02.dbf
13 /opt/oracle/oradata/ninvoice/MAIN_2012_02.dbf
14 /opt/oracle/oradata/ninvoice/MAIN_2012_01.dbf
15 /opt/oracle/oradata/ninvoice/MAIN_2013_01.dbf
16 /opt/oracle/oradata/ninvoice/MTCLUSTER_IDX.dbf
17 /opt/oracle/oradata/ninvoice/ggate01.dbf
~
"/tmp/f.lst" 18L, 948C written
[oracle@OS4 ~]$ bbed listfile= '/tmp/f.lst'
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Thu Sep 26 09:33:30 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> show all
FILE# 1
BLOCK# 1
OFFSET 0
DBA 0x00400001 (4194305 1,1)
FILENAME /opt/oracle/oradata/ninvoice/system01.dbf
BIFILE bifile.bbd
LISTFILE /tmp/f.lst
BLOCKSIZE 8192
MODE Browse
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
BBED> set dba 4,151
DBA 0x01000097 (16777367 4,151)
BBED> d /v
File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
Block: 151 Offsets: 0 to 511 Dba:0x01000097
-------------------------------------------------------
06a20000 97000001 3b590e00 00000106 l .?.....;Y......
1bf10000 01000000 f11d0100 3a590e00 l .?.....?..:Y..
00000000 02003200 90000001 0a001b00 l ......2.........
32020000 cc58c100 5c004500 0e200000 l 2...蘕?\.E.. ..
3b590e00 00000000 00000000 00000000 l ;Y..............
00000000 00000000 00000000 00000000 l ................
00000000 00010e00 ffff2e00 611d331d l ............a.3.
331d0000 0e00721f 471f1c1f f31ec61e l 3.....r.G...??
9d1e741e 4c1e261e fb1dd51d af1d881d l ..t.L.&.???..
611d0000 00000000 00000000 00000000 l a...............
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................
<16 bytes per line>
BBED> find /c SMITH
File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
Block: 151 Offsets: 8158 to 8191 Dba:0x01000097
------------------------------------------------------------------------
534d4954 4805434c 45524b03 c2500307 77b40c11 01010102 c209ff02 c1150106
3b59
<32 bytes per line>
BBED> d /v dba 4,151 offset 8158
File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
Block: 151 Offsets: 8158 to 8191 Dba:0x01000097
-------------------------------------------------------
534d4954 4805434c 45524b03 c2500307 l SMITH.CLERK.翽..
77b40c11 01010102 c209ff02 c1150106 l w?.....?..?..
3b59 l ;Y
<16 bytes per line>
BBED> m /c DEITY dba 4,151 offset 8158
BBED-00215: editing not allowed in BROWSE mode
BBED> set mode edit
MODE Edit
BBED> m /c Deity dba 4,151 offset 8158
File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
Block: 151 Offsets: 8158 to 8191 Dba:0x01000097
------------------------------------------------------------------------
44656974 7905434c 45524b03 c2500307 77b40c11 01010102 c209ff02 c1150106
3b59
<32 bytes per line>
BBED> d /v
File: /opt/oracle/oradata/ninvoice/users01.dbf (4)
Block: 151 Offsets: 8158 to 8191 Dba:0x01000097
-------------------------------------------------------
44656974 7905434c 45524b03 c2500307 l Deity.CLERK.翽..
77b40c11 01010102 c209ff02 c1150106 l w?.....?..?..
3b59 l ;Y
<16 bytes per line>
BBED> sum
Check value for File 4, Block 151:
current = 0xf11b, required = 0xf91d
BBED> sum apply;
Check value for File 4, Block 151:
current = 0xf91d, required = 0xf91d
BBED> exit
[oracle@OS4 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 26 09:39:03 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
09:39:03 SQL> conn scott/tiger
Connected.
09:39:08 SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10
14 rows selected.
Elapsed: 00:00:00.00
09:39:13 SQL> conn / as sysdba
Connected.
09:39:18 SQL> alter system flush buffer_cache;
System altered.
Elapsed: 00:00:00.17
09:39:26 SQL> conn scott/tiger
Connected.
09:39:29 SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 Deity CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10
14 rows selected.
Elapsed: 00:00:00.00
09:39:32 SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16381228/viewspace-773386/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16381228/viewspace-773386/