| RMAN - Error [message #333457] |
Fri, 11 July 2008 13:15  |
marcossantos
Messages: 123
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 #333469 is a reply to message #333461] |
Fri, 11 July 2008 15:35  |
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 #333544 is a reply to message #333480] |
Sat, 12 July 2008 08:29 |
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 #333786 is a reply to message #333457] |
Mon, 14 July 2008 07:54 |
marcossantos
Messages: 123
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 #334152 is a reply to message #333457] |
Tue, 15 July 2008 09:50 |
marcossantos
Messages: 123
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 #334164 is a reply to message #333457] |
Tue, 15 July 2008 10:36 |
marcossantos
Messages: 123
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
