Rodrigo, boa tarde. Muito obrigado pela informação. Como na doc fala: "RMAN must be connected to the destination recovery catalog, which is the catalog into which you want to import catalog data""No target database connection is needed to merge catalog schemas" Então fiz: rman target /RMAN> connect catalog user_catalog/xxx RMAN> import catalog USER_ANTIGO/xxx; Starting import catalog at 13-MAR-18connected to source recovery catalog databaseDBMS_RCVCAT package version 11.02.00.04 in source database is not of version 11.02.00.03RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of import catalog command at 03/13/2018 14:06:01RMAN-06429: IMPCAT database is not compatible with this version of RMAN
RMAN> upgrade catalog;upgrade catalog; recovery catalog upgraded to version 11.02.00.03 DBMS_RCVMAN package upgraded to version 11.02.00.03DBMS_RCVCAT package upgraded to version 11.02.00.03 RMAN> connect catalog ELIPSEPRD151164/rmngrprd connected to recovery catalog database RMAN> upgrade catalog; RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-06441: cannot upgrade catalog - catalog is already newer than this RMAN ----- Mensagem encaminhada ----- De: Rodrigo Mufalani rodr...@mufalani.com.br [oracle_br] <oracle_br@yahoogrupos.com.br>Para: oracle...@yahoogrupos..com.br <oracle_br@yahoogrupos.com.br>Enviado: terça-feira, 13 de março de 2018 13:39:50 BRTAssunto: Re: [oracle_br] Change owner catalog Boa tarde, Procure sobre import catalog, comando do rman. Isso vai resolver seu problema. Obter o Outlook para iOSFrom: oracle_br@yahoogrupos.com.br <oracle_br@yahoogrupos.com.br> on behalf of Rafael Mendonca raffaell.t...@yahoo.com [oracle_br] <oracle_br@yahoogrupos.com.br> Sent: Tuesday, March 13, 2018 5:32:38 PM To: Yahoo! Brazil Subject: [oracle_br] Change owner catalog PEssoal, boa tarde. Oracle 11gR2. Seguinte, possuo um banco de dados (catalogo de recuperação) que possui diversos owners onde cada um eh dono de um catalogo. Estou migrando todas as informações de vários owners para um único catalogo (um unico owner) O que está ocorrendo são os erros que recebo no impdp, segue: Criacao do catologo que servira para todos os databases: SQL> CREATE TABLESPACE TBS_CATALOG DATAFILE '/oracle/oradata/rmngrprd/data/tbs_catalog_01.dbf' SIZE 3G AUTOEXTEND ON NEXT 1G; SQL> CREATE USER USER_CATALOG IDENTIFIED BY xxxx DEFAULT TABLESPACE TBS_CATALOG;SQL> GRANT CONNECT, RESOURCE, RECOVERY_CATALOG_OWNER TO USER_CATALOG;SQL> ALTER USER USER_CATALOG QUOTA UNLIMITED ON TBS_CATALOG; $ rman CATALOG=USER_CATALOG/xxxxx RMAN> CREATE CATALOG TABLESPACE TBS_CATALOG; Owner de origem: USERNAME DEFAULT_TABLESPACE------------------------------ ------------------------------USER_ANTIGO USERS expdp \' /as sysdba \' CONTENT=DATA_ONLY schemas=USER_ANTIGO directory="BACKUP_DBA" dumpfile=USER_ANTIGO .dmp logfile=USER_ANTIGO.log Logo depois, mando o impdp: impdp \' /as sysdba \' TABLE_EXISTS_ACTION=APPEND remap_schema= USER_ANTIGO :USER_CATALOG remap_tablespace=USERS:TBS_CATALOG directory="BACKUP_DBA" dumpfile=USER_ANTIGO .dmp logfile=USER_ANTIGO .log e abaixo segue o erro ao importar: ORA-31693: Table data object "USER_CATALOG"."ROUT" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEFETCH calloutORA-02291: integrity constraint (USER_CATALOG.ROUT_F2) violated - parent key not foundORA-31693: Table data object "USER_CATALOG"."RLH" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEFETCH calloutORA-02291: integrity constraint (USER_CATALOG..RLH_F1) violated - parent key not foundORA-31693: Table data object "USER_CATALOG"."BP" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEFETCH calloutORA-02291: integrity constraint (USER_CATALOG.BP_F2) violated - parent key not foundORA-31693: Table data object "USER_CATALOG"."RSR" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEFETCH calloutORA-02291: integrity constraint (USER_CATALOG.RSR_F2) violated - parent key not foundORA-31693: Table data object "USER_CATALOG"."BS" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEFETCH calloutORA-02291: integrity constraint (USER_CATALOG.BS_F2) violated - parent key not foundORA-31693: Table data object "USER_CATALOG"."BRL" failed to load/unload and is being skipped due to error:ORA-29913: error in executing ODCIEXTTABLEFETCH callout Tentei também utilizar o parâmetro no impdp DATA_OPTIONS=SKIP_CONSTRAINT_ERRORS, mas isso é uma gambiarra e mesmo assim obtive vários erros, alguém sabe como faço para resolver esse problema?