Request of recovery oracle db

Posted by PDSERVICE on Oct 23, 2018 In

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 from https://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'

You are here

Request of recovery oracle db

Request of recovery oracle db