Home » RDBMS Server » Backup & Recovery » Rman Error (Oracle 10.)
Rman Error [message #385963] Thu, 12 February 2009 01:31 Go to next message
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?
Re: Rman Error [message #385974 is a reply to message #385963] Thu, 12 February 2009 01:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Rman Error [message #385984 is a reply to message #385974] Thu, 12 February 2009 02:31 Go to previous messageGo to next message
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.
Re: Rman Error [message #385985 is a reply to message #385984] Thu, 12 February 2009 02:35 Go to previous message
Mahesh Rajendran
Messages: 10672
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:
  


Current Time: Mon Dec 05 21:20:49 CST 2016

Total time taken to generate the page: 0.05413 seconds