Durante a execução de um backup, foi reportado o seguinte erro:
Starting Control File and SPFILE Autobackup at Mar 14 2016 12:36:57 piece handle=c-3519572088-20160314-05 comment=API Version 2.0,MMS Version 6.3.0.0 Finished Control File and SPFILE Autobackup at Mar 14 2016 12:37:14 released channel: t1 released channel: t2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03008: error while performing automatic resync of recovery catalog RMAN-20033: control file SEQUENCE# too low
Para resolver este problema, executei um resync (para efetuar uma resincronização dos metadados no schema do catálogo do rman com os metadados no control file do banco de dados alvo) no catalógo do RMAN e posteriormente o backup foi finalizado com sucesso após uma nova execução. Segue abaixo um exemplo do troubleshooting:
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / connected to target database: TECHDB (DBID=3519572088) RMAN> connect catalog <user>/<password>@<string> connected to recovery catalog database RMAN> resync catalog; starting full resync of recovery catalog full resync complete RMAN> exit
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.