2 Replies Latest reply: Nov 26, 2012 4:46 PM by user12194321 RSS

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

    user12194321
      Hi,

      Oracle version : 11.2.0.2

      os : linux rhel 5

      i am doing duplicate database from active database
      rman target sys/*******@pindb AUXILIARY sys/*****@test
      
      Recovery Manager: Release 11.2.0.2.0 - 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;
      DUPLICATE TARGET DATABASE  TO 'TEST' FROM ACTIVE DATABASE  DB_FILE_NAME_CONVERT '/oradata/pindb','/oradata/test';
      }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], [11.2.0.2.0], [], [], [], [], [], [], [], []
      RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
      Please can any one suggest

      Thanks
        • 1. Re: RMAN-04014: startup failed: ORA-00600 during duplicate database
          mseberg
          Hello;

          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 :

          http://www.acehints.com/2011/11/fix-rman-duplicate-database-failed-ora.html

          http://bryangrenn.blogspot.com/2011/12/ora-600-kckrlscheck-must-use-110000-or.html


          Best Regards

          mseberg

          Edited by: mseberg on Nov 26, 2012 4:07 PM
          • 2. Re: RMAN-04014: startup failed: ORA-00600 during duplicate database
            user12194321
            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 ?



            Thanks

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