Skip to main content
Solved

Oracle Database Re-sync Error & Archive Log


Forum|alt.badge.img+10

Hello, Team

I have this client with these issues.

 

1. They backup currently on an Oracle DR server (the production database replicates to to the DR(They don't use production because of performance issue))and they are having this resync issue.. below is the error: 

Error Code: [18:183] Description: Failed with Oracle DB/RMAN error [RMAN-03002: failure of allocate command at 04/27/2022 07:16:05 RMAN-03014: implicit resync of recovery catalog failed RMAN-03009: failure of partial resync command on default channel at 04/27/2022 07:16:05 ORA-20110: set stamp set count conflict ]

2. When they do a restore of an oracle database, on the Database end, it requests for an archive logs of 5 years ago. 

 

What could be the cause of these problems? I am writing a report to them and these are the only 2 issues I have not been able to fathom.

Best answer by Gowri Shankar

Hi @Mubaraq ,

 

For the catalog resync issue please refer Oracle documentation Doc ID 2453569.1

 

For the question 2, could you provide the complete RMAN log from the restore for review

 

Regards,

Gowri Shankar

View original
Did this answer your question?

3 replies

Forum|alt.badge.img+13

Hi @Mubaraq ,

 

For the catalog resync issue please refer Oracle documentation Doc ID 2453569.1

 

For the question 2, could you provide the complete RMAN log from the restore for review

 

Regards,

Gowri Shankar


Forum|alt.badge.img+10
  • Author
  • Byte
  • 57 replies
  • May 8, 2022

Hi, @Gowri Shankar 

 

I have requested for the log on the next restore.

 

Will upload once i get it


Mike Struening
Vaulter
Forum|alt.badge.img+23

@Mubaraq , were you able to get the log as @Gowri Shankar suggested?


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