ASM bbed

Please download to get full document.

View again

of 14
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Information Report
Category:

Documents

Published:

Views: 6 | Pages: 14

Extension: PDF | Download: 0

Share
Related documents
Description
ASM + BBE
Tags
Transcript
    How to view and edit data on ASM using BBED ver. 1.0 Marcin Przepiorowski, July 2009 marcin.przepiorowski@wp.pl http://oracleprof.blogspot.com/   How to view and edit data on ASM using BBED Marcin Przepiorowski  –  marcin.przepiorowski@wp.pl 2 Contents Introduction ...................................................................................................................................... 3 Preparation ....................................................................................................................................... 4 Data access ....................................................................................................................................... 5 Final comment ................................................................................................................................ 14 Bibliography .................................................................................................................................... 14  How to view and edit data on ASM using BBED Marcin Przepiorowski  –  marcin.przepiorowski@wp.pl 3 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.  How to view and edit data on ASM using BBED Marcin Przepiorowski  –  marcin.przepiorowski@wp.pl 4 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 th e 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 complete.
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks