Skip to main content
Solved

Single Table level restore issue in Oracle


Forum|alt.badge.img+6

Hello Team,

We are trying to restore single level table restore in Oracle DB, while restore is getting an error.

 

RMAN-03002: failure of duplicate DB command

RMAN-05501: aborting duplication of target database.

RMAN-04004: error from recovery catalog database: ORA-01033: ORACLE initialization or shutdown in progress.

 

RMAN-05546: DUPLICATE without TARGET and CATALOG connections requires that BACKUP LOCATION is specified.

 

The restoration is using the same DB server.

 

Please advise the restoration process.

Best answer by DMowers

Here is information I found in a couple of support cases with similar error messages;

 

Please read below snipper from the Oracle online documentation: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-duplicating-databases.html#GUID-17D02072-3003-4003-AC6F-BE680B4F107D

When you perform duplication without a target connection and without a recovery catalog, only disk …

View original
Did this answer your question?

2 replies

DMowers
Vaulter
Forum|alt.badge.img+4
  • Vaulter
  • 16 replies
  • Answer
  • May 26, 2022

Here is information I found in a couple of support cases with similar error messages;

 

Please read below snipper from the Oracle online documentation: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/bradv/rman-duplicating-databases.html#GUID-17D02072-3003-4003-AC6F-BE680B4F107D

When you perform duplication without a target connection and without a recovery catalog, only disk …


Forum|alt.badge.img+1
  • Bit
  • 1 reply
  • June 28, 2023

We have use oracle standard edition 12c. Can I know this oracle standard edition is able to support table restore level or not. We are try but was fail.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings