I tried to reset the incarnation to its previous state when I received the following error below:
RMAN> LIST INCARNATION; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 TECH 4459792587 PARENT 1 18-MAR-15 2 2 TECH 4459792587 CURRENT 32752735843 15-SEP-22 RMAN> RESET DATABASE TO INCARNATION 1; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of reset database command on default channel at 09/15/2022 11:29:58 ORA-19910: can not change recovery target incarnation in control file
After some analysis, I acknowledge that the database was OPEN. Therefore, to change the incarnation, I bounced the database, started it in the MOUNT state, and executed the operation to shift the incarnation, so it finished successfully. The evidence of this operation can be seen below:
SQL> SHUTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 1068937216 bytes Fixed Size 2235208 bytes Variable Size 436208824 bytes Database Buffers 624951296 bytes Redo Buffers 5541888 bytes Database mounted. SQL> Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN> connect target / connected to target database: TECH (DBID=4459792587, not open) RMAN> RESET DATABASE TO INCARNATION 1; using target database control file instead of recovery catalog database reset to incarnation 1 RMAN> LIST INCARNATION; List of Database Incarnations DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------- ------- -------- ---------------- --- ---------- ---------- 1 1 TECH 4459792587 CURRENT 1 18-MAR-15 2 2 TECH 4459792587 ORPHAN 32752735843 15-SEP-22
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)