Question
We are interested on do a recover of a table that was truncated and has
84 partitions. We are trying to do the process of recovery but it take
Too long.
All the partitions has a size of 5TB (the sum of all the partitions). We
Had 2 requests for you
1. Is normal that the process takes too long?
2. We understand that this recover must be payed, what could be the
Price of this recover? Should we had to pay for a license of the
Software of for the recovery?
Answer
1、have you try prm-dul?
2、let me know details: os version 、 storage type(filesystem or ASM)、 RAC or not?
Question
We use prm-dul, we download fromhttps://sourceforge.net/projects/prm-dul-oracle/And try to recover the data of a partition but the process takes too long and never ends.
We are interested on a remote support to try to recover all the data.
Please les us know how to reach you to talk about.
The details of the server are: OS Version: Red hat enterprise linux 6.4; Storage Type: ASM; Single instance Oracle Database EE 11.2.0.4
We are working with PRM-DUL but it seems that the BLOB column is not recovering. When we use recovery with "data-bridge" option we don´t get any row recovered. When we use the option that create a file we see this information ... and the blob information contains photos .... Exists a way to pay for a demo that show us that the recovery will be succesfull and then pay for full recovery?
Answer
Let me know the details
Database version
Dictionary-mode or non-dictionary-mode?
Securefile LOB or classic LOB?
OS Version: Red hat enterprise linux 6.4; Storage Type: ASM; Single instance Oracle Database EE 11.2.0.4
Dictionary-mode or non-dictionary-mode? We are using non-dictionary mode, but the DB is up and running, but no one is using it.
Securefile LOB or classic LOB? BLOB
The tables has many partitions, some information was recovered but some partitions are not in backups ...
Securefile LOB or classic LOB?
You can check this by command in sqlplus
Show parameter db_securefile
And
Col Column format a6
Col isSecureFile format a12
Col Compressed format a10
Col DeDuplicated format a12
Col Encrypted format a9
Col StoredInRow format a11
Col Logging format a7
Col Cached format a10
SELECT
Column_name as "Column"
, securefile as "isSecureFile"
, compression as "Compressed"
, deduplication as "DeDuplicated"
, encrypt as "Encrypted"
, in_row as "StoredInRow"
, logging as "Logging"
, cache as "Cached"
FROM dba_lobs
WHERE table_name ='&THE_TABLE_NAME'
DBRECOVER Recovery Options
For Oracle incidents, start with the DBRECOVER for Oracle trial to verify table visibility, row previews, and export readiness on copied datafiles. For MySQL and InnoDB incidents, DBRECOVER for MySQL is free software and can inspect.ibd files, ibdata1, and database directories locally.
When the case is urgent, preserve the original files first, work from copies, and contact paid emergency support with the database version, platform, error messages, file list, and recovery objective.