Database Backup and Recovery (MOSC)

MOSC Banner

rman table recovery failing 12c

edited Feb 24, 2018 4:16PM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Hi All,

When I try to recover a table after taking rman compressed backup using catalog database, it is throwing below error .  I tried below commands to recover table, but both are giving below error.

recover table t1.t1 until time "to_date('06/04/2015 00:12:10','mm/dd/yyyy hh24:mi:ss')" auxiliary destination '/oracle/recover';

recover table t1.t1 until scn 44465586 auxiliary destination '/oracle/recover'

Before dropping I noted the time and scn as mentioned above.

t1 is user and t1 is a table created as t1 user.

RMAN> recover table t1.t1 until scn 44465586 auxiliary destination '/oracle/recover'

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