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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)