| 失效链接处理 |
|
How to view and edit data on ASM using BBED PDF 下载
本站整理下载：
提取码：cck4
相关截图：
 主要内容：
How to view and edit data on ASM using BBED
Marcin Przepiorowski – marcin.przepiorowski@wp.pl
Introduction
The following document describes my work related to check if it is possible to read and write data
which are placed inside ASM structures.
An idea of that article comes to my mind when I recall that Oracle has been shipped with a Binary
Block Editor which is an internal Oracle tool to view and edit database block. I was trying to read
data files based on ASM but with no luck. So I decide to investigate it a little bit deeper.
This article is an example only and I can’t take responsibility for any damages of your databases. Do
not edit database block on production or other important system without assistance from Oracle
Support.
3
How to view and edit data on ASM using BBED
Marcin Przepiorowski – marcin.przepiorowski@wp.pl
Preparation
First problem appear on very beginning – there is no BBED in 11g. But with little help from Miladin
Modrakovic blog I have solve it. Now I got a tool – BBED was running so what I needed was a data to
view.
There second problem appeared – database file had been placed on ASM and not a file system.
BBED is a very old tool and it not working with ASM. There are two possibilities to fix that – I could
use a RMAN to copy a data file from ASM into file system but this is not a good idea if your files are
big and you want to see a live data. Second option is to copy only a required database blocks
(related to data which you want to see) directly from ASM into file system and then view it.
But how to copy only some block from ASM into file system ? ASM is based on disks, so if we now
where the data are placed we can use “dd” command to copy them. Some important information
about ASM structure I have found in Luca Canali presentation for UKOUG. After I read it I was ready
to perform some tests. Here are results of my work.
Creating of test table
1. Create a table which has been used in my test
[oracle@piorovm ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jun 18 09:18:57 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> connect pioro/pioro
Connected.
SQL> create table secret_table (id number, name varchar2(100), cardnum
varchar2(20)) tablespace users;
Table created.
SQL> insert into secret_table values (1,'Marcin Przepiorowski','4444-1111-
2222-3333');
1 row created.
SQL> insert into secret_table values (2,'Jim Smith','4444-2222-3333-5555');
1 row created.
SQL> commit;
Commit comp
|
| Java1234官方群25： | 
|
| Java1234官方群25： | 838462530 |
苏公网安备 32061202001004号
