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
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)