咨询微信： dbservice1234 7 x 24 在线支持！

首页

下载 DBRECOVER

Request of recovery oracle db

Request of recovery oracle db

Posted by PDSERVICE on 10月 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'