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 18.104.22.168 and later
Information in this document applies to any platform.
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
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
|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|