Skip navigation.

Pakistan's First Oracle Blog

Syndicate content
I Love What I do i.e. Oracle DBA
Updated: 3 weeks 2 days ago

RMAN-07518: Reason: Foreign database file DBID

Wed, 2014-06-04 05:06
While cloning a database to another system through RMAN in an 11.2 database on a Linux system, there was a need to catalog the backups after putting the destination instance in mount status, before the restore/recover process could be started.





During the phase of cataloging, got the following error:

RMAN-07518: Reason: Foreign database file DBID

Upon checking, it was learned that there was a mismatch of database incarnation at the source and the destination databases.

RMAN> LIST INCARNATION;

In order to resolve this error, you need to make sure that the incarnation number of both source and destination databases is same. So check what's the Current Incarnation Number at the source database, and then reset the incarnation of destination to the same.

For example if the incarnation number at the source is 3, you can reset the incarnation of destination in RMAN by:

RMAN> reset database to incarnation 3;

Now the cataloging the backup files worked fine.

Cheers.
Categories: DBA Blogs

From Las Vegas to Ottawa

Wed, 2014-05-28 21:16
After a very engaging session at Collaborate14 in sunny Las Vegas amidst the desert of Nevada, I just arrived in not-so-bitterly cold Ottawa, the capital of Canada. Looking forward meeting with various Pythian colleagues and hanging out with the friends I cherish most.

My Exadata IORM session went well. Lots of follow back discussion plus questions are still pouring in. I promise I will answer them as soon as I return to Australia after couple of weeks. That reminds me of my flight from one corner of the globe to the other, but well I need to learn as how to sleep like a baby during flights. Any ideas?

Ottawa reminds me of Australian capital Canberra. It's quite a change after neon-city Vegas. Where Vegas was bathing in lights, simmering with shows, bubbling with bars, swarming with party-goers, and rattling with Casinos; Ottawa is laid-back, quiet, peaceful, and small. Restaurants and cafes look cool. Ottawa River is mostly still frozen and mounds of snow are evident along the road sides with leafless trees.

But spring is here, and things look all set to rock.
Categories: DBA Blogs

My Session Evaluation from Collaborate14 in Las Vegas Arrived :)

Sun, 2014-05-25 17:56
Dear Fahd Chughtai,
Thank you for presenting at COLLABORATE 14 – IOUG Forum in Las Vegas, Nevada. We hope that you will consider presenting at future IOUG events. You can view your evaluation results for the following session below: 194-12c Multi-Tenancy and Exadata IORM: An Ideal Cloud Based Resource Management
Note: Session evaluations were based on a 1-5 scoring scale. (1 being the lowest and 5 being the highest)

Primary speaker was knowledgeable about the materialThe primary speaker's presentation skills were satisfactoryThe slides and materials presented in the session were satisfactoryThe agenda abstract and objectives were accurate to the session presentationI learned a lot of new information in this session.I can apply what I learned in this session to my jobOverall, how would you rate this session?4.334.334.67444.334.33
Categories: DBA Blogs