See metalink: 360962.1: Manual Completion of a Failed RMAN Duplicate.
See How to duplicate a database
Controlfile creation failed (Phase 2) - ** The restore has completed - Db dest is nomount ** - Failed to create controlfile because wrong destination instance name: ... duplicate target database to p2 nofilenamecheck; ... No need to backup controlfile to trace as suggested in note. Go to rman log and copy and paste the failed statement (with your corrections) |
Controlfile created, recover (Phase 3)
- ** Db dest is mounted **
Suggested script in note is uncomplete because lacks auxiliary channel allocation.
Be sure to keep the same until time.
Here it is with advanced legato channel configuration:
run {
set until time "to_date('06-28-2007 00:00:00','MM-DD-YYYY HH24:MI:SS')";
allocate auxiliary channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_BINDIR=/usr/sbin,NSR_CLIENT=pkg_nis,NSR_SERVER=bk801bck,NSR_DATA_VOLUME_POOL=DBTAN)';
recover clone database;
alter clone database open resetlogs;
}
|