alternate client restore fails with recovery target incarnation changed during recovery
From: hrishy <hrishys_at_yahoo.co.uk>
Date: Fri, 1 Jul 2011 04:07:35 +0100 (BST)
Message-ID: <1309489655.13467.YahooMailClassic_at_web29009.mail.ird.yahoo.com>
Hi
I have a RAC database with instances called RAC[1-4] we duplicated this to a single instance database called TRAC using alternate client restore.
It restored all the datafiles and the archivelog files but when trying to recover the restored datafiles by applying the archives it started throwing a error like
And i could see
ORA-00283: recovery session canceled due to errors ORA-19906: recovery target incarnation changed during recovery
and when i looked into the database i saw there were 2 incarnations of the database whereas the target database from where it was cloned has only one incarnation.
can anybody explain what is the reason that the incarnation automatically changes and why ?
Another DBA solved the issue by reseting the incarnation to 1 and regsitering the logfiles manually and recovering the database but i did not understand why this happened
Date: Fri, 1 Jul 2011 04:07:35 +0100 (BST)
Message-ID: <1309489655.13467.YahooMailClassic_at_web29009.mail.ird.yahoo.com>
Hi
I have a RAC database with instances called RAC[1-4] we duplicated this to a single instance database called TRAC using alternate client restore.
It restored all the datafiles and the archivelog files but when trying to recover the restored datafiles by applying the archives it started throwing a error like
And i could see
ORA-00283: recovery session canceled due to errors ORA-19906: recovery target incarnation changed during recovery
and when i looked into the database i saw there were 2 incarnations of the database whereas the target database from where it was cloned has only one incarnation.
can anybody explain what is the reason that the incarnation automatically changes and why ?
Another DBA solved the issue by reseting the incarnation to 1 and regsitering the logfiles manually and recovering the database but i did not understand why this happened
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 30 2011 - 22:07:35 CDT