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

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 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/manager@prmry

connected to target database: DB1 (DBID=3353074485)

RMAN> connect auxiliary sys/manager@stby

connected to auxiliary database: DB1 (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  '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdb1' auxiliary format
'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdb1'   ;
}
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 =
 ''+ORADATA/ukenzidb/controlfile/current.274.722547917'', ''+ORAFRA/db/controlfile/current.266.722547917'' comment=
''Set by RMAN'' scope=spfile";
  backup as copy current controlfile for standby auxiliary format  '+ORADATA/db/controlfile/current.263.722547917';
  restore clone controlfile to  '+ORAFRA/db/controlfile/current.265.722547917' from
'+ORADATA/db/controlfile/current.263.722547917';
  sql clone "alter system set  control_files =
 ''+ORADATA/db/controlfile/current.263.722547917'', ''+ORAFRA/db/controlfile/current.265.722547917'' comment=
''Set by RMAN'' scope=spfile";
  shutdown clone immediate;
  startup clone nomount;
}
executing Memory Script

sql statement: alter system set  control_files =   ''+ORADATA/db/controlfile/current.274.722547917'', ''+ORAFRA/db/controlfile/current.266.722547917'' 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=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_uktnzidb1.f tag=TAG20100624T193917 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 =   ''+ORADATA/ukenzidb/controlfile/current.263.722547917'', ''+ORAFRA/ukenzidb/controlfile/current.265.722547917'' 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms