Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
RMAN-05056, RMAN-05056 Recover table sys.aud$, 18c

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
Best Answer
-
Action: Remove SYS table, SYS objects cannot be recovered.
But what does this really mean?
Perhaps the following is less ambiguous:
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.
Answers
-
Why you want to recover this table?
-
hi,
for old audit records before truncating
best regards
-
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.
-
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.
Regards,
Adi -
Action: Remove SYS table, SYS objects cannot be recovered.
But what does this really mean?
Perhaps the following is less ambiguous:
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. -
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
-
Siyavuş AK wrote:<snip>have you got any document link for duplicate database 18c version? ( step by step in detail)best regardssiyavus
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.
-
... and since RMAN duplicate is pretty much a different topic than table recovery, it will be best to create a new thread.