2 Replies Latest reply on Nov 26, 2012 10:46 PM by user12194321

    RMAN-04014: startup failed: ORA-00600 during duplicate database


      Oracle version :

      os : linux rhel 5

      i am doing duplicate database from active database
      rman target sys/*******@pindb AUXILIARY sys/*****@test
      Recovery Manager: Release - Production on Mon Nov 26 19:56:41 2012
      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
      connected to target database: pindb (DBID=4116200880)
      connected to auxiliary database: TEST (not mounted)
      RMAN> run {
      allocate channel C1 type disk;
      allocate auxiliary channel DUP type disk;
      }2> 3> 4> 5>
      using target database control file instead of recovery catalog
      allocated channel: C1
      channel C1: SID=699 device type=DISK
      allocated channel: DUP
      channel DUP: SID=5 device type=DISK
      Starting Duplicate Db at 26-NOV-12
      contents of Memory Script:
         sql clone "create spfile from memory";
      executing Memory Script
      sql statement: create spfile from memory
      contents of Memory Script:
         shutdown clone immediate;
         startup clone nomount;
      executing Memory Script
      Oracle instance shut down
      connected to auxiliary database (not started)
      released channel: C1
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 11/26/2012 19:57:07
      RMAN-06403: could not obtain a fully authorized session
      RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux-x86_64 Error: 2: No such file or directory
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-04014: startup failed: ORA-00600: internal error code, arguments: [kck_rls_check must use (11,0,0,0,0) or lower], [kdt.c], [9576], [], [], [], [], [], [], [], [], []
      RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
      Please can any one suggest

        • 1. Re: RMAN-04014: startup failed: ORA-00600 during duplicate database

          I believe this is a bug taht has to do with compression compatibility.

          I think the work around is :
          alter system  set "_compression_compatibility"="11.2.0";
          Let me confirm with a MOS document number

          Later Unable to find the MOS doc - This has some details :



          Best Regards


          Edited by: mseberg on Nov 26, 2012 4:07 PM
          • 2. Re: RMAN-04014: startup failed: ORA-00600 during duplicate database
            Thanks mseberg

            it works :)

            actually we thought to use rman duplicate from active database to refresh the test from production but problem is difference in grants and privs in some users from production to test
            may i know where these grants/privelegs information will stored , is it system tablespace ?


            Edited by: user12194321 on Nov 26, 2012 2:39 PM