Database Backup and Recovery (MOSC)

MOSC Banner

RMAN RECOVER TABLE on EXADATA ASM

edited Sep 6, 2018 5:05AM in Database Backup and Recovery (MOSC) 11 commentsAnswered

Hi,

I wanted to restore a table with rman (first time for me) on Exadata. So following the doc i've just ran a command like:

RMAN> run {recover table DBADM.TRACKAPPSLOCK

until time 'sysdate-4/24'

auxiliary destination '/backup/auxiliary/PCB1'

remap table 'DBADM'.'TRACKAPPSLOCK':'TRACKAPPSLOCK_RECO';}

RMAN went to the end of the restore but to my surprise the Table created was empty.

I've checked the log (i will paste only the relevant part) and find this:

...

Performing export of tables...

   EXPDP> Starting "SYS"."TSPITR_EXP_bzlo_Cpcg":

   EXPDP> Estimate in progress using BLOCKS method...

   EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center