Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-17627: ORA-01041 while doing replication

611bcee7-c794-483c-a5ae-4caa61870718Jun 20 2017 — edited Jun 21 2017

Hi,

I am stuck when doing a replication on our current production server, does anyone here encountered the same issue I am having below. Below is the logs I am encountering while doing replication on the servers.

Recovery Manager: Release 11.2.0.1.0 - Production on Wed Jun 14 16:44:23 2017

connected to target database: FLZDB (DBID=3234805104)

connected to auxiliary database: FLZDB (not mounted)

RMAN> DUPLICATE TARGET DATABASE

2> FOR STANDBY

3> FROM ACTIVE DATABASE

4> DORECOVER

5> SPFILE

6> SET db_unique_name='FLZDB_STBY' COMMENT 'Is standby'

7> SET LOG_ARCHIVE_DEST_2='SERVICE=FLZDB ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FLZDB'

8> SET FAL_SERVER='FLZDB' COMMENT 'Is primary'

9> NOFILENAMECHECK;

10>

Starting Duplicate Db at 14-JUN-17

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=854 device type=DISK

contents of Memory Script:

{

backup as copy reuse

targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwFLZDB' auxiliary format

'/u01/app/oracle/product/11.2.0/db_1/dbs/orapwFLZDB' targetfile

'/u01/app/oracle/product/11.2.0/db_1/dbs/spfileFLZDB.ora' auxiliary format

'/u01/app/oracle/product/11.2.0/db_1/dbs/spfileFLZDB.ora' ;

sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfileFLZDB.ora''";

}

executing Memory Script

Starting backup at 14-JUN-17

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=585 device type=DISK

Finished backup at 14-JUN-17

sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfileFLZDB.ora''

contents of Memory Script:

{

sql clone "alter system set db_unique_name =

''FLZDB_STBY'' comment=

''Is standby'' scope=spfile";

sql clone "alter system set LOG_ARCHIVE_DEST_2 =

''SERVICE=FLZDB ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FLZDB'' comment=

'''' scope=spfile";

sql clone "alter system set FAL_SERVER =

''FLZDB'' comment=

''Is primary'' scope=spfile";

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

sql statement: alter system set db_unique_name = ''FLZDB_STBY'' comment= ''Is standby'' scope=spfile

sql statement: alter system set LOG_ARCHIVE_DEST_2 = ''SERVICE=FLZDB ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FLZDB'' comment= '''' scope=spfile

sql statement: alter system set FAL_SERVER = ''FLZDB'' comment= ''Is primary'' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 13428654080 bytes

Fixed Size 2217992 bytes

Variable Size 7113541624 bytes

Database Buffers 6308233216 bytes

Redo Buffers 4661248 bytes

contents of Memory Script:

{

backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/FLZDB/control01.ctl';

restore clone controlfile to '/u01/app/oracle/oradata/FLZDB/control02.ctl' from

'/u01/app/oracle/oradata/FLZDB/control01.ctl';

}

executing Memory Script

Starting backup at 14-JUN-17

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

copying standby control file

output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_FLZDB.f tag=TAG20170614T164445 RECID=40 STAMP=946658687

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07

Finished backup at 14-JUN-17

Starting restore at 14-JUN-17

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=854 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 14-JUN-17

contents of Memory Script:

{

sql clone 'alter database mount standby database';

}

executing Memory Script

sql statement: alter database mount standby database

RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT

Using previous duplicated file /data/dbf/DATA03.dbf for datafile 5 with checkpoint SCN of 10225523995

Using previous duplicated file /data/dbf/DATA02.dbf for datafile 6 with checkpoint SCN of 10225683704

contents of Memory Script:

{

set newname for tempfile 1 to

"/u01/app/oracle/oradata/FLZDB/temp01.dbf";

switch clone tempfile all;

set newname for datafile 1 to

"/u01/app/oracle/oradata/FLZDB/system01.dbf";

set newname for datafile 2 to

"/u01/app/oracle/oradata/FLZDB/sysaux01.dbf";

set newname for datafile 3 to

"/u01/app/oracle/oradata/FLZDB/undotbs01.dbf";

set newname for datafile 4 to

"/u01/app/oracle/oradata/FLZDB/users01.dbf";

set newname for datafile 7 to

"/data/dbf/DATA01.dbf";

set newname for datafile 8 to

"/data/dbf/DATA04.dbf";

set newname for datafile 9 to

"/data/dbf/DATA05.dbf";

set newname for datafile 10 to

"/data/dbf/DATA06.dbf";

set newname for datafile 11 to

"/data/dbf/DATA07.dbf";

set newname for datafile 12 to

"/data/dbf/DATA08.dbf";

set newname for datafile 13 to

"/data/dbf/DATA09.dbf";

set newname for datafile 14 to

"/data/dbf/DATA10.dbf";

set newname for datafile 15 to

"/data/dbf/DATA11.dbf";

set newname for datafile 16 to

"/data/dbf/DATA12.dbf";

set newname for datafile 17 to

"/data/dbf/DATA13.dbf";

set newname for datafile 18 to

"/data/dbf/DATA14.dbf";

set newname for datafile 19 to

"/data/dbf/DATA15.dbf";

set newname for datafile 20 to

"/data/dbf/DATA16.dbf";

set newname for datafile 21 to

"/data/dbf/DATA17.dbf";

set newname for datafile 22 to

"/data/dbf/DATA18.dbf";

set newname for datafile 23 to

"/data/dbf/DATA19.dbf";

set newname for datafile 24 to

"/data/dbf/DATA20.dbf";

set newname for datafile 25 to

"/data/dbf/SYSTEM02.dbf";

set newname for datafile 26 to

"/data/dbf/sysaux02.dbf";

set newname for datafile 27 to

"/data/dbf/DATA21.dbf";

set newname for datafile 28 to

"/data/dbf/DATA22.dbf";

set newname for datafile 29 to

"/data/dbf/DATA23.dbf";

set newname for datafile 30 to

"/data/dbf/DATA24.dbf";

set newname for datafile 31 to

"/data/dbf/DATA25.dbf";

set newname for datafile 32 to

"/data/dbf/DATA26.dbf";

set newname for datafile 33 to

"/data/dbf/DATA27.dbf";

set newname for datafile 34 to

"/data/dbf/DATA28.dbf";

set newname for datafile 35 to

"/u01/app/oracle/oradata/FLZDB/undotbs02.dbf";

backup as copy reuse

datafile 1 auxiliary format

"/u01/app/oracle/oradata/FLZDB/system01.dbf" datafile

2 auxiliary format

"/u01/app/oracle/oradata/FLZDB/sysaux01.dbf" datafile

3 auxiliary format

"/u01/app/oracle/oradata/FLZDB/undotbs01.dbf" datafile

4 auxiliary format

"/u01/app/oracle/oradata/FLZDB/users01.dbf" datafile

7 auxiliary format

"/data/dbf/DATA01.dbf" datafile

8 auxiliary format

"/data/dbf/DATA04.dbf" datafile

9 auxiliary format

"/data/dbf/DATA05.dbf" datafile

10 auxiliary format

"/data/dbf/DATA06.dbf" datafile

11 auxiliary format

"/data/dbf/DATA07.dbf" datafile

12 auxiliary format

"/data/dbf/DATA08.dbf" datafile

13 auxiliary format

"/data/dbf/DATA09.dbf" datafile

14 auxiliary format

"/data/dbf/DATA10.dbf" datafile

15 auxiliary format

"/data/dbf/DATA11.dbf" datafile

16 auxiliary format

"/data/dbf/DATA12.dbf" datafile

17 auxiliary format

"/data/dbf/DATA13.dbf" datafile

18 auxiliary format

"/data/dbf/DATA14.dbf" datafile

19 auxiliary format

"/data/dbf/DATA15.dbf" datafile

20 auxiliary format

"/data/dbf/DATA16.dbf" datafile

21 auxiliary format

"/data/dbf/DATA17.dbf" datafile

22 auxiliary format

"/data/dbf/DATA18.dbf" datafile

23 auxiliary format

"/data/dbf/DATA19.dbf" datafile

24 auxiliary format

"/data/dbf/DATA20.dbf" datafile

25 auxiliary format

"/data/dbf/SYSTEM02.dbf" datafile

26 auxiliary format

"/data/dbf/sysaux02.dbf" datafile

27 auxiliary format

"/data/dbf/DATA21.dbf" datafile

28 auxiliary format

"/data/dbf/DATA22.dbf" datafile

29 auxiliary format

"/data/dbf/DATA23.dbf" datafile

30 auxiliary format

"/data/dbf/DATA24.dbf" datafile

31 auxiliary format

"/data/dbf/DATA25.dbf" datafile

32 auxiliary format

"/data/dbf/DATA26.dbf" datafile

33 auxiliary format

"/data/dbf/DATA27.dbf" datafile

34 auxiliary format

"/data/dbf/DATA28.dbf" datafile

35 auxiliary format

"/u01/app/oracle/oradata/FLZDB/undotbs02.dbf" ;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/FLZDB/temp01.dbf in control file

executing command: SET NEWNAME

Starting backup at 14-JUN-17

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

input datafile file number=00007 name=/data/dbf/DATA01.dbf

output file name=/data/dbf/DATA01.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:09

channel ORA_DISK_1: starting datafile copy

input datafile file number=00008 name=/data/dbf/DATA04.dbf

output file name=/data/dbf/DATA04.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:30

channel ORA_DISK_1: starting datafile copy

input datafile file number=00009 name=/data/dbf/DATA05.dbf

output file name=/data/dbf/DATA05.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:51

channel ORA_DISK_1: starting datafile copy

input datafile file number=00010 name=/data/dbf/DATA06.dbf

output file name=/data/dbf/DATA06.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:01

channel ORA_DISK_1: starting datafile copy

input datafile file number=00011 name=/data/dbf/DATA07.dbf

output file name=/data/dbf/DATA07.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:49

channel ORA_DISK_1: starting datafile copy

input datafile file number=00012 name=/data/dbf/DATA08.dbf

output file name=/data/dbf/DATA08.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:60

channel ORA_DISK_1: starting datafile copy

input datafile file number=00013 name=/data/dbf/DATA09.dbf

output file name=/data/dbf/DATA09.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:34:31

channel ORA_DISK_1: starting datafile copy

input datafile file number=00014 name=/data/dbf/DATA10.dbf

output file name=/data/dbf/DATA10.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:20

channel ORA_DISK_1: starting datafile copy

input datafile file number=00015 name=/data/dbf/DATA11.dbf

output file name=/data/dbf/DATA11.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:30

channel ORA_DISK_1: starting datafile copy

input datafile file number=00016 name=/data/dbf/DATA12.dbf

output file name=/data/dbf/DATA12.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:41

channel ORA_DISK_1: starting datafile copy

input datafile file number=00017 name=/data/dbf/DATA13.dbf

output file name=/data/dbf/DATA13.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:30

channel ORA_DISK_1: starting datafile copy

input datafile file number=00018 name=/data/dbf/DATA14.dbf

output file name=/data/dbf/DATA14.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:50

channel ORA_DISK_1: starting datafile copy

input datafile file number=00019 name=/data/dbf/DATA15.dbf

output file name=/data/dbf/DATA15.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:01

channel ORA_DISK_1: starting datafile copy

input datafile file number=00020 name=/data/dbf/DATA16.dbf

output file name=/data/dbf/DATA16.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:40

channel ORA_DISK_1: starting datafile copy

input datafile file number=00021 name=/data/dbf/DATA17.dbf

output file name=/data/dbf/DATA17.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:01

channel ORA_DISK_1: starting datafile copy

input datafile file number=00022 name=/data/dbf/DATA18.dbf

output file name=/data/dbf/DATA18.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:20

channel ORA_DISK_1: starting datafile copy

input datafile file number=00023 name=/data/dbf/DATA19.dbf

output file name=/data/dbf/DATA19.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:44:03

channel ORA_DISK_1: starting datafile copy

input datafile file number=00024 name=/data/dbf/DATA20.dbf

output file name=/data/dbf/DATA20.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:31:30

channel ORA_DISK_1: starting datafile copy

input datafile file number=00027 name=/data/dbf/DATA21.dbf

output file name=/data/dbf/DATA21.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:31:40

channel ORA_DISK_1: starting datafile copy

input datafile file number=00028 name=/data/dbf/DATA22.dbf

output file name=/data/dbf/DATA22.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:30

channel ORA_DISK_1: starting datafile copy

input datafile file number=00029 name=/data/dbf/DATA23.dbf

output file name=/data/dbf/DATA23.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:31:51

channel ORA_DISK_1: starting datafile copy

input datafile file number=00030 name=/data/dbf/DATA24.dbf

output file name=/data/dbf/DATA24.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:32:41

channel ORA_DISK_1: starting datafile copy

input datafile file number=00031 name=/data/dbf/DATA25.dbf

output file name=/data/dbf/DATA25.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:52

channel ORA_DISK_1: starting datafile copy

input datafile file number=00032 name=/data/dbf/DATA26.dbf

output file name=/data/dbf/DATA26.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:41

channel ORA_DISK_1: starting datafile copy

input datafile file number=00033 name=/data/dbf/DATA27.dbf

output file name=/data/dbf/DATA27.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:33:10

channel ORA_DISK_1: starting datafile copy

input datafile file number=00034 name=/data/dbf/DATA28.dbf

output file name=/data/dbf/DATA28.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:34:40

channel ORA_DISK_1: starting datafile copy

input datafile file number=00003 name=/u01/app/oracle/oradata/FLZDB/undotbs01.dbf

output file name=/u01/app/oracle/oradata/FLZDB/undotbs01.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:21:29

channel ORA_DISK_1: starting datafile copy

input datafile file number=00035 name=/u01/app/oracle/oradata/FLZDB/undotbs02.dbf

output file name=/u01/app/oracle/oradata/FLZDB/undotbs02.dbf tag=TAG20170614T164502

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:22:20

channel ORA_DISK_1: starting datafile copy

input datafile file number=00025 name=/data/dbf/SYSTEM02.dbf

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2017 07:59:34

ORA-19558: error de-allocating device

ORA-19557: device error, device type: DISK, device name:

ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist

ORA-03113: end-of-file on communication channel

channel ORA_DISK_1 disabled, job failed on it will be run on another channel

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 06/15/2017 07:59:34

RMAN-03015: error occurred in stored script Memory Script

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/15/2017 07:59:34

ORA-19558: error de-allocating device

ORA-19557: device error, device type: DISK, device name:

ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist

ORA-03113: end-of-file on communication channel

Recovery Manager complete.

----------

Other datafiles are replicated successfully, while im stuck at SYSTEM02.dbf with this error.

The DBF is existing on the Primary Database, and same path are created on both Primary and Replicated Servers

Thanks in Advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2017

Added on Jun 20 2017

#performance-availability, #recovery-manager-rman

5 comments

638 views