RMAN DUPLICATION FAILS WITH RMAN-600 [7002] IF NEWNAME FOR NON-DB FILES IS USED

Bug No. 2624658
Filed 14-OCT-2002 Updated 27-JAN-2003
Product Oracle Server - Enterprise Edition Product Version 9.2.0.1.0
Platform AIX 4.3 Based Systems (64-bit) Platform Version 5.1
Database Version 9.2.0.1.0 Affects Platforms Generic
Severity Severe Loss of Service Status Development to Q/A
Base Bug N/A Fixed in Product Version 10.0

*** 10/14/02 07:27 am ***

DDR RDBMS BUG FILING TEMPLATE

.

.

.

.

.

=========================

PROBLEM:

.

1. Clear description of the problem encountered:

.

Datafile added to production but not yet in backupset causes RMAN-600 during

duplication command.

.

2. Pertinent configuration information (MTS/OPS/distributed/etc)

.

N/A

Not using automatic channels.

.

3. Indication of the frequency and predictability of the problem

.

Using 'set newname' for each datafile when a datafile is missing from the

backupset will reproduce this every time.

.

4. Sequence of events leading to the problem

.

Customer corrupted a table that was only in an RMAN backupset. They did not

want to perform TSPITR because they just needed to recover a 143 row table and

did not wat to impact the entire tablespace. They decided to duplicate the

100G database to a new node using duplicate to PIT. There are 26 files in the

production but only 25 in backup. The restore failed to validate file# 26 in

backup.

.

5. Technical impact on the customer. Include persistent after effects.

.

This caused an extreme amount of time and effort to duplicate the database

which caused them to question RMAN's viability as their backup and recovery

solution.

.

=========================

DIAGNOSTIC ANALYSIS:

.

DBGSQL: EXEC SQL AT AUXILIARY begin sys . dbms_backup_restore .

inspectDataFileCopy ( fname => :fname , full_name => :newname , recid =>

:recid , stamp => :stamp ) ; end ;

DBGSQL: sqlcode=0

DBGSQL: :b1 = "/backup2/zlbr/data/pstemp_t_01.dbf"

DBGSQL: :b2 = "/backup2/zlbr/data/pstemp_t_01.dbf"

DBGSQL: :b3 = 24

DBGSQL: :b4 = 474302320

DBGMISC: krmicomp: error 7002 signalled during compilation

DBGMISC: krmicomp: error 3015 signalled during compilation

.

.

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

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

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

RMAN-03002: failure of Duplicate Db command at 10/03/2002 14:38:40

RMAN-03015: error occurred in stored script Memory Script

RMAN-00600: internal error, arguments [7002] [0] [7804] [] []

.

=========================

WORKAROUND:

.

Given by DEV --

.

Exclude file# 26 from the 'set newname' line and rerun operation.

Customer has not tested this workaround yet.

.

=========================

RELATED BUGS:

.

.

=========================

REPRODUCIBILITY:

.

1. State if the problem is reproducible; indicate where and predictability

.

This was tested 3 times and produced the same results each time.

.

2. List the versions in which the problem has reproduced

.

Only tested using 9.2.0.1

.

3. List any versions in which the problem has not reproduced

.

N/A

.

=========================

TESTCASE:

.

N/A

.

========================

STACK TRACE:

.

DBGSQL: EXEC SQL AT AUXILIARY begin sys . dbms_backup_restore .

inspectDataFileCopy ( fname => :fname , full_name => :newname , recid =>

:recid , stamp => :stamp ) ; end ;

DBGSQL: sqlcode=0

DBGSQL: :b1 = "/backup2/zlbr/data/pstemp_t_01.dbf"

DBGSQL: :b2 = "/backup2/zlbr/data/pstemp_t_01.dbf"

DBGSQL: :b3 = 24

DBGSQL: :b4 = 474302320

DBGMISC: krmicomp: error 7002 signalled during compilation

DBGMISC: krmicomp: error 3015 signalled during compilation

.

.

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

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

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

RMAN-03002: failure of Duplicate Db command at 10/03/2002 14:38:40

RMAN-03015: error occurred in stored script Memory Script

RMAN-00600: internal error, arguments [7002] [0] [7804] [] []

.

=========================

SUPPORTING INFORMATION:

.

rman debug output will be uploaded to the ess30

.

=========================

24 HOUR CONTACT INFORMATION FOR P1 BUGS:

.

N/A

.

=========================

DIAL-IN INFORMATION:

.

N/A

.

=========================

IMPACT DATE:

.

Next release

*** 10/14/02 07:37 am *** (CHG: Sta->16)

*** 10/14/02 07:37 am ***

*** 10/14/02 07:55 am *** (CHG: Sta->11 Asg->NEW OWNER)

*** 10/14/02 07:55 am ***

*** 12/23/02 03:06 pm *** (CHG: DevPri->2)

*** 01/27/03 04:29 am *** (CHG: Sta->80)

*** 01/27/03 04:29 am *** (CHG: Fixed->10.0)

*** 01/27/03 04:29 am ***

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/193161/viewspace-50207/，如需转载，请注明出处，否则将追究法律责任。