Forum Stats

  • 3,768,648 Users
  • 2,252,827 Discussions
  • 7,874,668 Comments

Discussions

RMAN-05056, RMAN-05056 Recover table sys.aud$, 18c

orasiya
orasiya Member Posts: 427 Bronze Badge
edited Jun 27, 2020 10:16AM in Recovery Manager (RMAN)

Dear friends,

I would like to recover only one table, sys.aud$

but I get the following error,

Recovery Manager: Release 18.0.0.0.0 - Production on Wed Jun 24 13:56:25 2020

Version 18.9.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

RECOVER TABLE 'SYS'.'AUD$'  UNTIL TIME "TO_DATE('01-01-2020 12:01', 'DD-MM-YYYY HH24:MI')"   AUXILIARY DESTINATION '/my_storage/aux_u01' REMAP TABLE 'SYS'.'AUD$':'AUD_PRE';

Starting recover at 24-04-20

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 04/24/2020 13:58:47

RMAN-05063: Cannot recover specified tables

RMAN-05056: Table SYS.AUD_PRE belongs to SYS

RMAN-05056: Table SYS.AUD$ belongs to SYS

Does this command work for sys tables? or not ?

Does we need full restore / duplicate until time / scn?

best regrads

Adityanath Dewoolkar

Best Answer

Answers