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?
