Home » RDBMS Server » Backup & Recovery » RMAN - Error (10g RHEL5)
RMAN - Error [message #333457] Fri, 11 July 2008 13:15 Go to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

for all commands I get this error in RMAN. For examplo:

RMAN>reset database;

starting full resync of recovery catalog
RMAN-00571: ==========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of reset command at 07/10/2008 08:09:15
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 07/10/2008 08:09:15
ORA-00001: unique constraint (RMAN_USER.TS_P) violated


Anybody can help me?


Marcos Santos
Re: RMAN - Error [message #333459 is a reply to message #333457] Fri, 11 July 2008 13:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please check metalink.
One possible bug and several workarounds already posted.
Re: RMAN - Error [message #333461 is a reply to message #333457] Fri, 11 July 2008 13:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are several known bugs around this in 10g.
The most likely in your case is Bug 4754328, explained in Metalink note 345159.1.

Regards
Michel
Re: RMAN - Error [message #333469 is a reply to message #333461] Fri, 11 July 2008 15:35 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi, this may be a bit off-topic, just want to ask, is it illegal for other sites to post those "metalink notes"? because i havent seen any metalink notes also being posted even here in orafaq.com.
Re: RMAN - Error [message #333470 is a reply to message #333457] Fri, 11 July 2008 15:36 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Thanks!!!

Marcos
Re: RMAN - Error [message #333471 is a reply to message #333469] Fri, 11 July 2008 15:39 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
ehegagoka wrote on Fri, 11 July 2008 13:35
hi, this may be a bit off-topic, just want to ask, is it illegal for other sites to post those "metalink notes"? because i havent seen any metalink notes also being posted even here in orafaq.com.


Yes posting them violates the support contract with Oracle.
The Notes: are copyrighted by Oracle.
Re: RMAN - Error [message #333479 is a reply to message #333471] Fri, 11 July 2008 18:17 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
thank you very much. i wonder why some companies that use oracle don't have metalink accounts =(

[Updated on: Fri, 11 July 2008 18:18]

Report message to a moderator

Re: RMAN - Error [message #333480 is a reply to message #333479] Fri, 11 July 2008 18:22 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
ehegagoka wrote on Fri, 11 July 2008 16:17
thank you very much. i wonder why some companies that use oracle don't have metalink accounts =(

The support contract with Oracle cost money on top of s/w license fee.
I suspect that the Oracle s/w may not be (properly?) licensed.
Re: RMAN - Error [message #333544 is a reply to message #333480] Sat, 12 July 2008 08:29 Go to previous messageGo to next message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi, thanks again. do you mean that when you buy "oracle database" you first pay for the "software/installer" then you have to pay for those metalink login accounts?
Re: RMAN - Error [message #333552 is a reply to message #333544] Sat, 12 July 2008 10:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You don't pay for software if you don't use it in production (for instance development, education...).
You don't have to pay for software in any case if you use XE (in the limit of the license).
You have to pay to get support which includes Metalink access.

Regards
Michel
Re: RMAN - Error [message #333786 is a reply to message #333457] Mon, 14 July 2008 07:54 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

I decide apply patch set 10.2.0.3 in my Oracle Database, but I have a question: Patch sets are cumulative? If I install 10.2.0.3, its fixes all bugs for 10.2.0.2?

Marcos Santos
Re: RMAN - Error [message #333829 is a reply to message #333786] Mon, 14 July 2008 09:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Information should be inside the patchset.
look into readme file
Re: RMAN - Error [message #333830 is a reply to message #333786] Mon, 14 July 2008 09:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what is said in the readme file you got with patchset.

Regards
Michel
Re: RMAN - Error [message #334152 is a reply to message #333457] Tue, 15 July 2008 09:50 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

I am installing patch set 10.2.0.3 and after install, I connect with "sqlplus sys/pass as sysdba" and execute the script $?db_1/rdbms/admin/catupgrd.sql. I get error:

The following statement will cause an "ORA-01722: invalid number"
error if the user running this script is not SYS. Disconnect
and reconnect with AS SYSDBA.

and not complete upgrade.

Thanks,

Marcos

Re: RMAN - Error [message #334154 is a reply to message #334152] Tue, 15 July 2008 09:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Sure it is an error?
>>The following statement will cause an
could be just a warning.
Post the session. Atleast the relevant part of it.
Explaining what you did and what kind of errors you got will help us nothing.
Re: RMAN - Error [message #334164 is a reply to message #333457] Tue, 15 July 2008 10:36 Go to previous messageGo to next message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Hi,

not is error. This messages of script. But, its stop in this point:


SQL> grant select on user_repgrouped_column to public with grant option
2 /

Grant succeeded.

SQL>
SQL> -- This view is for internal use only and may change without notice.
SQL> REM For the remote acess of POS in repcat$_grouped_column,
SQL> REM "_ALL_REPGROUPED_COLUMN" is added.
SQL> REM This view is for internal use only and may change without notice.
SQL> create or replace view "_ALL_REPGROUPED_COLUMN"
2 (
3 sname, oname, group_name, column_name, pos
4 )
5 as
6 select
7 gc.sname, gc.oname, gc.group_name,
8 gc.column_name,
9 gc.pos
10 from all_tab_columns tc, system.repcat$_grouped_column gc
11 where gc.sname = tc.owner
12 and gc.oname = tc.table_name
13 and (gc.column_name = tc.column_name OR
14 (gc.column_name = 'SYS_NC_OID$' AND
15 -- sOID column
16 exists (select 1 from system.repcat$_repcolumn rc
17 where rc.sname = gc.sname
18 and rc.oname = gc.oname
19 and rc.cname = 'SYS_NC_OID$'
20 and utl_raw.bit_and(utl_raw.substr(rc.property, 1, 1),
21 '10') = '10')))
22 union
23 select
24 gc.sname, gc.oname, gc.group_name,
25 gc.column_name,
26 gc.pos
27 from "_ALL_REPL_NESTED_TABLE_NAMES" nt, system.repcat$_grouped_column gc
28 where gc.sname = nt.owner
29 and gc.oname = nt.table_name
30 /

thanks,

Marcos
Re: RMAN - Error [message #334192 is a reply to message #333457] Tue, 15 July 2008 14:42 Go to previous message
marcossantos
Messages: 114
Registered: June 2008
Senior Member
Its work.

Thanks.
Previous Topic: How to Migrate Oracle 10g using Veritas NetBackup 5.0 to Veritas BackupExec 9.0
Next Topic: Roll forward from a hot backup
Goto Forum:
  


Current Time: Wed Dec 07 07:03:30 CST 2016

Total time taken to generate the page: 0.14171 seconds