This discussion is archived
2 Replies Latest reply: Nov 26, 2012 2:46 PM by user12194321 RSS

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

user12194321 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points