Hi guys,
I am duplicating primary database PROD1 (RAC) to PROD2 (RAC) using restore untill scn.
I get the following error..I have done recover database using backup controlfile but when I entered the logfile path it was asking it couldnt complete the recovery process. It didnt give any suggestions of the logfile name, except telling it that the required scn would be found in thread2.
Starting recover at 16-MAY-2009 03:59:20
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/PROD2/data001/system01.dbf'
released channel: C2
released channel: C3
released channel: C4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/16/2009 03:59:49
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06102: no channel to restore a backup or copy of log thread 2 seq 38762 lowscn 45625475313
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47044 lowscn 45625473575
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47043 lowscn 45625446718
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47042 lowscn 45625262810
RMAN-06102: no channel to restore a backup or copy of log thread 2 seq 38761 lowscn 45625262795
RMAN-06102: no channel to restore a backup or copy of log thread 2 seq 38760 lowscn 45625261978
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47041 lowscn 45625261662
RMAN-06102: no channel to restore a backup or copy of log thread 2 seq 38759 lowscn 45625261559
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47040 lowscn 45625261555
RMAN-06102: no channel to restore a backup or copy of log thread 2 seq 38758 lowscn 45625232490
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47039 lowscn 45625231460
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47038 lowscn 45625210665
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47037 lowscn 45625185633
RMAN-06102: no channel to restore a backup or copy of log thread 2 seq 38757 lowscn 45625131973
RMAN-06102: no channel to restore a backup or copy of log thread 1 seq 47036 lowscn 45625131966
RMAN>
Recovery Manager complete.
Please Help.