My Oracle Support Banner

Data Guard Physical Duplicate for Standby using Active Primary fails ORA-600 [kfdNotify02] (Doc ID 1136834.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
*** This note is reviewed on Feb 26, 2013

Symptoms

RMAN duplicate for standby using the active primary site is failing reporting the following errors.

RMAN> connect target sys/<PASSWORD>@<ALIAS>

connected to target database: <DB_NAME>(DBID=nnnnnnnnnnn)

RMAN> connect auxiliary sys/<PASSWORD>@<ALIAS>

connected to auxiliary database: <DB_NAME> (not mounted)


RMAN> run {
2>         allocate channel prmy1 type disk;
3>         allocate channel prmy2 type disk;
4>         allocate channel prmy3 type disk;
5>         allocate channel prmy4 type disk;
6>         allocate auxiliary channel stby type disk;
7>         duplicate target database for standby from active database;
8> }
using target database control file instead of recovery catalog
allocated
..
.
Starting Duplicate Db at 24-JUN-2010 19:45:12

contents of Memory Script:
{
  backup as copy reuse
  targetfile  '/<PATH>/dbs/<PASSWORD_FILE>' auxiliary format
'/<PATH>/db_1/dbs/<PASSWORD_FILE>'   ;
}
executing Memory Script

Starting backup at 24-JUN-2010 19:45:13
Finished backup at 24-JUN-2010 19:45:16

contents of Memory Script:
{
  sql clone "alter system set  control_files =
 ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'', ''<PATH>/controlfile/<CONTROL_FILE_NAME>'' comment=
''Set by RMAN'' scope=spfile";
  backup as copy current controlfile for standby auxiliary format  '+<PATH>/controlfile/<CONTROL_FILE_NAME>';
  restore clone controlfile to  '+<PATH>/controlfile/<CONTROL_FILE_NAME>' from
'+<PATH>/controlfile/<CONTROL_FILE_NAME>';
  sql clone "alter system set  control_files =
 ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'', ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'' comment=
''Set by RMAN'' scope=spfile";
  shutdown clone immediate;
  startup clone nomount;
}
executing Memory Script

sql statement: alter system set  control_files =   ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'', ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'' comment= ''Set by RMAN'' scope=spfile

Starting backup at 24-JUN-2010 19:45:17
channel prmy1: starting datafile copy
copying standby control file
output file name=/<PATH>/db_1/dbs/<FILE_NAME>.f tag=<TAG_NAME> RECID=1 STAMP=722547558
channel prmy1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 24-JUN-2010 19:45:24

Starting restore at 24-JUN-2010 19:45:24

channel stby: copied control file copy
Finished restore at 24-JUN-2010 19:45:27

sql statement: alter system set  control_files =   ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'', ''+<PATH>/controlfile/<CONTROL_FILE_NAME>'' comment= ''Set by RMAN'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/24/2010 19:45:59
RMAN-03015: error occurred in stored script Memory Script
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-00600: internal error code, arguments: [kfdNotify02], [2], [], [], [], [], [], [], [], [], [], []

RMAN>
RMAN> **end-of-file**

 

Changes

No changes implemented this error can occur during the configuration of a new standby database.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.