Home » RDBMS Server » Server Utilities » "ORA-0142" ERROR
"ORA-0142" ERROR [message #73094] Mon, 02 February 2004 06:58 Go to next message
Hernan
Messages: 2
Registered: February 2004
Junior Member
Hi, when I make a BACKUP DATABASE from RMAN, this error appear:

 

ORA-01422: exact fetch returns more than requested number of rows

 

I'm using RMAN in local mode with Oracle on WINDOWS 2000 without OMS.

Can anybody help me please ?

Thanks.

Hernan.

Report message to a moderator

Re: "ORA-0142" ERROR [message #73095 is a reply to message #73094] Mon, 02 February 2004 08:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
first make sure dual table is NOT HAVING more than one record.
and i assume by your posting
I'm using RMAN in local mode with Oracle on WINDOWS 2000 without OMS.

that your not using a recovery catalog.

please try this
first
connect to target database
do a resync
exit out of rman.

connect again and do the backup.

Report message to a moderator

Re: "ORA-0142" ERROR [message #73096 is a reply to message #73095] Mon, 02 February 2004 09:35 Go to previous messageGo to next message
Hernan
Messages: 2
Registered: February 2004
Junior Member
Thanks Mahesh!
This server is not on production environment, it's only for test, and a few days ago I was trying something and I created a record on dual table. I never thought that this record would break my rman backup :)
Thanks a lot again!.
Hernan.

Report message to a moderator

Re: "ORA-0142" ERROR [message #73097 is a reply to message #73096] Mon, 02 February 2004 09:57 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
its is not just for RMAN.
Many oracle intenal algorithms are dependent on Dual table.
Never mess-up with that.~~

Report message to a moderator

Previous Topic: DBA
Next Topic: Can this be done with export/import ??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 22:02:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.