A Oracle na versão 11gR2 disponibiliza como New Feature a forma de fazer o duplicate sem precisar estar conectado na base de origem. Facilitando muitas vezes o transporte de uma base inteira, como irei mostrar neste teste case de um duplicate RAC 11gR2 para um Single 11gR2.
Meu ambiente que estarei demonstrando será tudo em linux, RAC+ASM para Single Non-ASM.
Primeiramente temos que fazer um backup full do database RAC, no meu caso chamado database: TKRAC11G.
Continue lendo mais em oraclehome.com.br…
olá Rafael,
estou a duplicar a minha PRD RAC ASM database from backup para DEV RAC ASM. por algum motivo o ASM não me deixa fazer a duplicação. podes dar-me algumas dicas como resolver?
abaixo tens o alert.log
Errors in file /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/trace/devvttk1_rbal_4349.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
Errors in file /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/trace/devvttk1_rbal_4349.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
SUCCESS: diskgroup DG_TTK was mounted
Errors in file /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/trace/devvttk1_rbal_4349.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so
Errors in file /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/trace/devvttk1_rbal_4349.trc:
ORA-15183: ASMLIB initialization error [driver/agent not installed]
SUCCESS: diskgroup FRA_TTK was mounted
SUCCESS: diskgroup FRA_TTK was dismounted
Errors in file /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/trace/devvttk1_ora_4218.trc (incident=43405):
ORA-00600: internal error code, arguments: [kfioTranslateIO03], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/incident/incdir_43405/devvttk1_ora_4218_i43405.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Wed Apr 24 12:20:54 2013
Dumping diagnostic data in directory=[cdmp_20130424122054], requested by (instance=1, osid=4218), summary=[incident=43405].
Errors in file /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/trace/devvttk1_ora_4218.trc (incident=43406):
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u02/app/oracle/devvttk/diag/rdbms/devvttk/devvttk1/incident/incdir_43406/devvttk1_ora_4218_i43406.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
ERROR: unrecoverable error ORA-600 raised in ASM I/O path; terminating process 4218
Dumping diagnostic data in directory=[cdmp_20130424122055], requested by (instance=1, osid=4218), summary=[incident=43406].
Wed Apr 24 12:20:56 2013
Boa tarde,
Está parecendo um erro de privilegios no ASMLIB, cheque os discos e ASM primeiramente.
Boa tarde,
Felizmente ultrapassei este problema, alguns parametros no pfile estavam mal configurados. agora estou a receber um erro inesparado do rman.
RMAN-08021: channel ORA_AUX_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/26/2013 14:43:34
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of IRESTORE command on ORA_AUX_DISK_1 channel at 04/26/2013 14:43:34
RMAN-10038: database session for channel ORA_AUX_DISK_1 terminated unexpectedly