OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Rman Error (Oracle 10.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rman Error [message #385963]

Thu, 12 February 2009 01:31

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

When I issue any command in RMAN, I get the following error:

ORA-01400: cannot insert NULL into ("RMAN"."ROUT"."ROUT_SKEY")

Could anyone please tell me, what may be the cause for this error?

Report message to a moderator

Re: Rman Error [message #385974 is a reply to message #385963]

Thu, 12 February 2009 01:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Could anyone please tell me, what may be the cause for this error?
May be if you can provide more useful information.
Providing OS information, Database version upto 4 digits, RMAN catalog version etc would be a good starting point.

There are several bugs related to this depending the above and what you were trying to do.
May be you tried to upgrade the database and it did not go well.

Report message to a moderator

Re: Rman Error [message #385984 is a reply to message #385974]

Thu, 12 February 2009 02:31

rumman
Messages: 48
Registered: June 2007
Location: Bangladesh

Member

No. At 10:00 am yesterday, everything was working perfectly. I used command:

LIST BACKUP;

It worked fine. But when I use this command at 04:00 pm, I found that error. Infact, at that time, whatever command I gave, I got the error.

At that time, I solved it using the following command:

upgrade catalog;
unregister database;
register database;

But, I am confused about the error that what the actual reason.

Report message to a moderator

Re: Rman Error [message #385985 is a reply to message #385984]

Thu, 12 February 2009 02:35

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Read the first three lines of my previous response.
Seems like bug 4729752

[Updated on: Thu, 12 February 2009 02:40]

Report message to a moderator

Previous Topic:	RMAN duplicate database restore
Next Topic:	Changing 'Log on' option and getting error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 11:08:02 CDT 2024