I am trying to create my standby database though RMAN and I am getting an error. I issued by backup standby controlfile then backed up my archive logs. I have nightly full compressed backups. I also tired without the dorecover command and the same thing happened. I hate to ask this but I don't need to copy over my backups and stdby control file to the destination target database? From my reading everything stays on the primary and it gets moved over when I run the duplicate for standby command. All my backups and standby controlfile is on the primary and I am running this command from the primary.
10.2.0.5 on RH 5 enterprise
rman target / auxiliary sys/@BCSTDBY_40;
Recovery Manager: Release 10.2.0.5.0 - Production on Mon Mar 18 15:08:27 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: BCSST (DBID=2914560172)
auxiliary database Password:
connected to auxiliary database: BCSST (not mounted)
allocate channel C1 device type disk;
allocate auxiliary channel C2 device type disk;
set until sequence 361533;
DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK dorecover;}2> 3> 4> 5>
using target database control file instead of recovery catalog
allocated channel: C1
channel C1: sid=108 devtype=DISK
contents of Memory Script:
set until scn 10825882791499;
restore clone standby controlfile;
sql clone 'alter database mount standby database';
executing Memory Script
executing command: SET until clause
Starting restore at 18-MAR-13
released channel: C1
released channel: C2
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of Duplicate Db command at 03/18/2013 15:09:51
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
Okay thanks. So I guess not copying over the backup is a problem then lol. Does it matter if I am on the primary or the stdby when I connect to RMAN and issue the duplicate command? Yours looks like you are on the stdby when you issue that command but it looks like the 10g documentation does it from the primary.
Does it matter if I am on the primary or the stdby when I connect to RMAN?
Yes. I would always start duplicate from the Standby server. Always
Check your document link---
Cannot disagree with how you read the Oracle document. But I know my method works. Seems like they are making harder than it should be and they are not very clear about what server the RMAN command is issued from.