My Oracle Support Banner

Script to Take Blockdump Using ROWID or RDBA and Object ID (Doc ID 2459241.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

Diagnostic command "alter database dump datafile" requires absolute file number and block number as input.

In many case we don't directly know the absolute file number and block number, it requires conversion.

This document intends to provide sample script to take block dump using several kind of input parameters.

First provide several anonymous plsql blocks for different kind of input parameters, then provide stored plsql package procedures that accept some combinations.

Anonymous plsql blocks can be easily modified to match favorite input parameters

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Example 1: 1-2 use rowid to take blockdump where this rowid resides
 1-1: Anonymous PLSQL block, which accept tablespace name and rdba in hex as a parameter
 1-2: Anonymous PLSQL block, which accept rowid as a parameter
 1-3: Anonymous PLSQL block, which accept dictionary object id and rdba in hex as a parameter
 1-4: Anonymous PLSQL block, which accept data object id and rdba in hex as a parameter
 2-1: Stored PLSQL package, which accept 9 kind of parameters

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.