Tuesday, June 4, 2013

Capture Workload using Oracle Database Replay in 11g


Hi Everyone,

My articles published in Oracle Experts website media "Allthingsoracle.com" by RedGate

Please view the article using below link.
Oracle Database Replay for your Workload Test

This article talks about simulating actual production load using in an easy & cost-effective way.

I hope you will like the article and it will be helpful to you.

Please leave your valuable comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Datapump export/import Errors ORA-39142, ORA-39000, ORA-39001 and UDI-00018

When you are working with 10g to 11g database/user migration, you will encounter many issues.

Here are the few issues common issues.

Scenario 1: User is trying to import a dumpfile using 10g Datapump utility which is generated by 11g Data pump utility.

Oracle@Srv1$ impdp system/xxxxxx schemas=SCOTT dumpfile= scottbkp.dmp logfile=scottbkp.log remap_schema=SCOTT:SCOTTTEST

Import: Release 10.2.0.4.0 - 64bit Production on Wednesday, 17 April, 2013 12:59:50

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/u01/home/oracle/product/10.2.0/db_1/rdbms/log/scottbkp.dmp"

Cause: User is trying to import a dumpfile whose version (11.2.0.1) number is incompatible with the dump file version of the Data Pump product currently running on the system (10.2.0.4). You cannot able to use lower version of Data pump to import a dumpfile create by a newer version of the data pump utility.

Solution: To migrate the data from 11g to 10g using Data Pump you need to export the schema/database VERSION parameter that matches the compatibility of the target database i.e. 10g

Oracle@Srv1>expdp \'/ AS SYSDBA\' schemas=SCOTT dumpfile= scottbkp.dmp logfile= scottbkp.log version=10.2.0

Scenario 2: User is trying to import a dumpfile using 11g Datapump utility which is generated by 10g Data pump utility.

Oracle@Srv1>impdp system/xxxxxx @oradb schemas=SCOTT dumpfile=scottbkp.dmp logfile=scottbkp.log remap_schema=SCOTT:SCOTTTEST

Import: Release 11.2.0.1.0 - Production on Wed Apr 17 13:05:00 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

UDI-00018: Data Pump client is incompatible with database version 10.2.0.4.0

Cause: User is trying use higher version of Datapump utility (11.2.01.1) to a lower version of the database (10.2.0.4)

Solution: Use the datapump client that matches with database version of your target database.

Refer below compatibility matrix
Overview of Data Pump dump file compatibility

  

Overview of Data Pump client/server compatibility


Overview of Data Pump dumpfile  set file versions

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

ORA-00600: internal error code, arguments: [krcrfi_nohist]


Users may encounter below backup failure with Oracle Single instance or RAC Databases.

RMAN-03009: failure of backup command on dsk_1 channel at 04/27/2013 19:19:23
ORA-00600: internal error code, arguments: [krcrfi_nohist], [16485391338], [16470585596], [], [], [], [], [], [], [], [], []

Possible reasons:

1. Users may see this error on Databases where Block change tracking enabled. This error is due to insufficient history in change tracking bitmap.

Workaround: Disable and enable change tracking.

2. User may also see this error if the storage location of any of the data file is not on a shared device.

Workaround: Move the datafile to a shared disk

The above issue has been fixed in 11.1.0.6. If you still see this issue contact Oracle Support.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com