Hi all, trying to duplicate a DB for Dataguard Standby via RMAN. It's not seeming to find the SPFILE. Any help would be appreciated, Thank you!
rman target sys/XXXXXXX@ECPMT1 auxiliary sys/XXXXXXX@ECPMTSB
Recovery Manager: Release 11.1.0.7.0 - Production on Mon Dec 3 19:07:13 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ECPMT (DBID=3935765344)
connected to auxiliary database: ECPMT (not mounted)
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database;
}
OUTPUT:
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=83 instance=ECPMT1 device type=DISK
allocated channel: prmy2
channel prmy2: SID=43 instance=ECPMT1 device type=DISK
allocated channel: prmy3
channel prmy3: SID=56 instance=ECPMT1 device type=DISK
allocated channel: prmy4
channel prmy4: SID=47 instance=ECPMT1 device type=DISK
allocated channel: stby
channel stby: SID=170 device type=DISK
Starting Duplicate Db at 03-DEC-12
contents of Memory Script:
{
backup as copy reuse
file '/opt/app/oracle/product/11.1.0/db_1/dbs/orapwECPMT1' auxiliary format
'/data/oracle/app/oracle/product/11.1.0/db_1/dbs/orapwECPMTSB' ;
}
executing Memory Script
Starting backup at 03-DEC-12
Finished backup at 03-DEC-12
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '+DG_01/ecpmtsb/controlfile/current.2717.769883873';
restore clone controlfile to '+FRA_DG_01/ecpmsbt/controlfile/current.4804.769883873' from
'+DG_01/ecpmtsb/controlfile/current.2717.769883873';
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting backup at 03-DEC-12
channel prmy1: starting datafile copy
copying standby control file
output file name=/opt/app/oracle/product/11.1.0/db_1/dbs/snapcf_ECPMT1.f tag=TAG20121203T190721 RECID=22 STAMP=801083242
channel prmy1: datafile copy complete, elapsed time: 00:00:07
Finished backup at 03-DEC-12
Starting restore at 03-DEC-12
channel stby: no AUTOBACKUP in 7 days found
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: stby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
Edited by: BostonDBA on Dec 3, 2012 2:36 PM