OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » "ORA-0142" ERROR

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

"ORA-0142" ERROR [message #73094]

Mon, 02 February 2004 06:58

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

Mahesh Rajendran
Messages: 10707
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

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

Mahesh Rajendran
Messages: 10707
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 16:07:16 CDT 2024