RMAN Duplicate failing

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Wed, 30 Sep 2015 17:16:05 +0000
Message-ID: <ef6775311e704973904136e0b09f9c3f_at_mspm1bmsgm17a.ent.core.medtronic.com>



Deal All,

I am trying to duplicate a 11.2.0.3 database but it is failing with the following error. I was successful in doing RMAN duplicate of the same database when it was at Oracle 10.2.0.4.

I didn’t enable ‘BLOCK CHANGE TRACKING’ feature in this database.

Q1. If it was enabled while it was still at 10g then why the duplicate worked fine at that time and failing now when the database is at 11g?

Q2. Does the upgrade scripts automatically enable ‘BLOCK CHANGE TRACKING’ feature while upgrading the database from 10.2.0.4 to 11.2.0.3?

Q3. Is there way to verify when and how ‘BLOCK CHANGE TRACKING’ feature was enabled?

Q4. If statement in Q2 is not true then what are other means of enabling ‘BLOCK CHANGE TRACKING’ feature?

Q5. As per some Oracle note it recommends to disable the feature and then run the RMAN duplicate but even after I have disabled the ‘BLOCK CHANGE TRACKING’ RMAN duplicate is still failing the same error.

Q6. Any idea how to address this issue?

RMAN-03002: failure of Duplicate Db command at 09/29/2015 14:10:29

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

ORA-00283: recovery session canceled due to errors

RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/phxdmasd3/uarchive/dtwdmas/dtwdmas_70408_1_595505569.arc'

ORA-00283: recovery session canceled due to errors

ORA-19755: could not open change tracking file

ORA-19750: change tracking file: '/phx10db1/uflashback/TWDMAS/rman_change_track.f'

ORA-27037: unable to obtain file status

SVR4 Error: 2: No such file or directory

Additional information: 3

Thanks,

Ashoke

[CONFIDENTIALITY AND PRIVACY NOTICE] - Applied from EOP Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 30 2015 - 19:16:05 CEST

Original text of this message