DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » Blogs » Chris Foot Blog » Chris Foot's Oracle10g Blog » RMAN 10G Registration Problems » Another FIX!

Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.

Who Are You?

I am a:
[ Results | Polls ]
Votes : 3608

Comment

Above in this comment thread: RMAN 10G Registration Problems

Another FIX!

Posted by cfoot at 2006-02-26 08:12 AM

Thanks for a great description of the problem.

I have found an alternative to recreating the control file. I logged in to the rman database and changed the rout_skey column to allowing NULLs. Afther that I ran the resync catalog from rman which completed successfully. Then I updated all the NULLs to 1 and changed the column back to NOT NULL.

Hope this helps.

Thorhallur

What a great idea!

Posted by cfoot at 2006-02-26 08:14 AM

I accidently deleted your post instead of replying to it. Another GREAT workaround. MUCH better than being forced to recreate the control file.

How did you know that was the column?