2 Replies Latest reply: May 1, 2012 7:53 AM by 934265 RSS

    RMAN-20042:invalid tablespace creation change#

    934265
      Database was flashbacked to guaranteed restore point.Below is the alert log entries:


      Mon Apr 30 10:52:15 2012
      flashback database to restore point REFRESH05APR2012
      Flashback Restore Start
      Mon Apr 30 10:55:40 2012
      Flashback: created tablespace #90: 'TEMP_TEMP' in the controlfile.
      Flashback: dropped tablespace #3: 'TEMP' from the control file.
      Flashback: created tablespace #3: 'TEMP' in the controlfile.
      Flashback: dropped tablespace #90: 'TEMP_TEMP' from the control file.
      Flashback Restore Complete
      Flashback Media Recovery Start
      started logmerger process
      Parallel Media Recovery started with 4 slaves
      Flashback Media Recovery Log +FRA/dbname/archivelog/2012_04_06/thread_2_seq_2.900.779864459
      Flashback Media Recovery Log +FRA/dbname/archivelog/2012_04_06/thread_1_seq_1.295.779881013
      Mon Apr 30 10:55:49 2012
      Incomplete Recovery applied until change 244414859 time 04/05/2012 20:13:08
      Flashback Media Recovery Complete
      Mon Apr 30 10:55:50 2012
      Completed: flashback database to restore point REFRESH05APR2012
      Mon Apr 30 10:56:18 2012
      alter database open resetlogs
      Archived Log entry 1144 added for thread 1 sequence 359 ID 0x7ccadac8 dest 1:
      ARCH: Archiving disabled thread 1 sequence 360
      Archived Log entry 1145 added for thread 1 sequence 360 ID 0x7ccadac8 dest 1:
      Archived Log entry 1146 added for thread 2 sequence 783 ID 0x7ccadac8 dest 1:
      Archived Log entry 1147 added for thread 2 sequence 784 ID 0x7ccadac8 dest 1:
      RESETLOGS after incomplete recovery UNTIL CHANGE 244414859
      Resetting resetlogs activation ID 2093669064 (0x7ccadac8)


      And after this RMAN backup failed with below error:


      starting full resync of recovery catalog
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of show command at 05/01/2012 13:18:28
      RMAN-03014: implicit resync of recovery catalog failed
      RMAN-03009: failure of full resync command on default channel at 05/01/2012 13:18:28
      RMAN-20042: invalid tablespace creation change#


      I can not even do show all while connected to catalog.

      tried unregister and register but no use.

      using target database control file instead of recovery catalog

      List of Database Incarnations
      DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
      ------- ------- -------- ---------------- --- ---------- ----------
      1 1 dbname 2093649865 PARENT 163049942 23-NOV-2011 17:28:18
      2 2 dbname 2093649865 PARENT 244408925 05-APR-2012 19:41:13
      3 3 dbname 2093649865 CURRENT 244414860 30-APR-2012 10:56:18



      below are the incarnation entries from other database which uses same catalog database;


      RMAN> list incarnation of database 'dbanme';


      List of Database Incarnations
      DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
      ------- ------- -------- ---------------- --- ---------- ----------
      43437 43438 dbname 2064845848 PARENT 1 13-MAY-2011 10:34:00
      43437 727618 dbname 2064845848 CURRENT 90131270 30-MAR-2012 13:15:20
      43437 727707 dbname 2064845848 ORPHAN 90131270 30-MAR-2012 13:08:45
      807871 807872 dbname 2093649865 CURRENT 244414860 30-APR-2012 10:56:18


      Database version 11.2.0.1.0
      OS version Linux 2.6.18-194.3.1.el5 x86_64

      Please help.

      Edited by: user12860499 on May 1, 2012 5:45 AM