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

orasiya

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

Dude!

Action: Remove SYS table, SYS objects cannot be recovered.

But what does this really mean?

Perhaps the following is less ambiguous:

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED…

Recovering tables and table partitions from RMAN backups by using the RECOVER command is subject to certain limitations.

The limitations include the following:

Tables and table partitions belonging to SYS schema cannot be recovered.

Sunny kichloo

Why you want to recover this table?

orasiya

hi,

for old audit records before truncating

best regards

Dude!

RMAN recovery means applying incremental level 1 and redo logs. Redo cannot undo changes, with the exception of rebuilding the undo table to undo uncommitted transactions. I find the RMAN messages somewhat irritating, but I would say you need to restore the system tablespace first before you can apply redo.

Adityanath Dewoolkar

RMAN-05056: Table string.string belongs to SYS

Cause: A SYS table was specified to be recovered.

Action: Remove SYS table, SYS objects cannot be recovered.

https://docs.oracle.com/en/database/oracle/oracle-database/18/errmg/RMAN-00201.html#GUID-8CF36220-DF1E-4BC7-A0B7-A958243…

Regards,
Adi

Dude!

Action: Remove SYS table, SYS objects cannot be recovered.

But what does this really mean?

Perhaps the following is less ambiguous:

https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED…

Recovering tables and table partitions from RMAN backups by using the RECOVER command is subject to certain limitations.

The limitations include the following:

Tables and table partitions belonging to SYS schema cannot be recovered.

orasiya

Ok  Dude,

many thanks for your attention. As you reminded according to oracle technical document, we do not execute Recover Table for Tables and table partitions belonging to SYS schema.

Therefore  we must execute

run {

      set until time "to_date('SYSDATE-10')";

      restore database;

      recover database;

      alter database open resetlogs;

}

have you got any document link for duplicate database 18c version? ( step by step in detail)

best regards

siyavus

EdStevens

Siyavuş AK wrote:<snip>have you got any document link for duplicate database 18c version? ( step by step in detail)best regardssiyavus 

https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/part-transfering-data-rman.html#GUID-A341A776-5EEF-4…

There are too many options to give a single 'step by step in detail'. But all the options and requirements are discussed in the above official doc.

Tim Hall usually has some very good 'cookbook' articles. See https://oracle-base.com/articles/misc/articles-misc#rman

But even then you will have to decide among various options, starting with - is this a multi-tenant installation ....Beyond that, there are still other options, depending on how you want to approach it.

Dude!

... and since RMAN duplicate is pretty much a different topic than table recovery, it will be best to create a new thread.