RMAN DUPLICATE ORA-19838 RMAN-06054 || ORA-19838: Cannot use this control file to open database || RMAN-06054: media recovery requesting unknown archived log

******************************************************************************************
RMAN DUPLICATE ORA-19838 RMAN-06054

****  Rman Script
connect catalog '<rmanuser>/<rmanuser_pwd>@<tns_for_rman_catalog>';
connect auxiliary / ;

run {
allocate auxiliary channel t1_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)";
allocate auxiliary channel t2_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)";
allocate auxiliary channel t3_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)";
allocate auxiliary channel t4_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)";

duplicate database <src_db_name> to <dsT-db_name>;
release channel t1_db;
release channel t2_db;
release channel t3_db;
release channel t4_db;
}
******************************************************************************************

Failed Database Duplication, recovery manager duplication was started after "open resetlogs" on source database and the last full backup was done with previous incarnation.
This is RMAN log file ->

archived log file name=/oradb1/archivelog/<dsT-db_name>/<dsT-db_name>_285521_695915219.arc RECID=285737 STAMP=823973951
archived log file name=/oradb1/archivelog/<dsT-db_name>/<dsT-db_name>_285522_695915219.arc thread=1 sequence=285522
channel clone_default: deleting archived log(s)
archived log file name=/oradb1/archivelog/<dsT-db_name>/<dsT-db_name>_285522_695915219.arc RECID=285731 STAMP=823973836
unable to find archived log
archived log thread=1 sequence=285523
released channel: t1_db
released channel: t2_db
released channel: t3_db
released channel: t4_db
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/20/2013 17:39:30
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 285523 and starting SCN of 15614356785656

Recovery Manager complete.

******************************************************************************************
*** After Alter database open

alter database open
*
ERROR at line 1:
ORA-19838: Nie mozna uzyc tego pliku sterujacego do otwarcia bazy danych

** So ..

sql> alter database backup controlfile to trace ;

** In controlfile recretion script the database name is the source db_name and the dir names for redo logs are still incorrect
******************************************************************************************
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "<src_db_name>" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 11680
LOGFILE
  GROUP 9 '/oradb1/<src_db_name>/redo09.log'  SIZE 150M BLOCKSIZE 512,
  GROUP 10 '/oradb1/<src_db_name>/redo10.log'  SIZE 150M BLOCKSIZE 512,
  GROUP 11 '/oradb1/<src_db_name>/redo11.log'  SIZE 150M BLOCKSIZE 512,
  GROUP 12 '/oradb1/<src_db_name>/redo012.log'  SIZE 150M BLOCKSIZE 512,
  GROUP 13 '/oradb1/<src_db_name>/redo013.log'  SIZE 150M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/oradb1/<dst_db_name>/system01.dbf',
  '/oradb1/<dst_db_name>/undotbs01.dbf',
  '/oradb1/<dst_db_name>/sysaux01.dbf',
  '/oradb1/<dst_db_name>/users01.dbf',
  '/oradb1/<dst_db_name>/TBS1_DATA01.dbf',
  '/oradb1/<dst_db_name>/TBS1_DATA02.dbf',
................
................
  '/oradb1/<dst_db_name>/TBS1_IDX08.dbf',
  '/oradb1/<dst_db_name>/TBS1_DATA29.dbf',
  '/oradb1/<dst_db_name>/TBS1_IDX09.dbf',
  '/oradb1/<dst_db_name>/TBS1_IDX07.dbf',
  '/oradb1/<dst_db_name>/TBS1_237318729380334627.dbf'
CHARACTER SET EE8ISO8859P2
;
******************************************************************************************

SQL> alter system set db_name=<new db_name> scope=spfile;

*** or change it in pfile init<dst_dbname>.ora


SQL> @<dstdbname>_ctl_recr.sql
ORACLE instance started.

Total System Global Area 4710043648 bytes
Fixed Size                  2229384 bytes
Variable Size            1962937208 bytes
Database Buffers         2734686208 bytes
Redo Buffers               10190848 bytes

Control file created.

SQL> alter database open resetlogs ;

Database altered.

SQL>




--------------------
Kamil Piórek
kamil.piorekk@gmail.com