Solved

Single Table level restore issue in Oracle


Badge +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.

icon

Best answer by DMowers 26 May 2022, 09:16

View original

2 replies

Badge +4

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 …

Badge +1

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