This discussion is archived
3 Replies Latest reply: Mar 18, 2013 8:41 AM by mseberg RSS

Issue with duplicate for standy

993195 Newbie
Currently Being Moderated
Hello,

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)

RMAN> run{
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

allocated channel: C2
channel C2: sid=153 devtype=DISK

executing command: SET until clause

Starting Duplicate Db at 18-MAR-13

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-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
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
  • 1. Re: Issue with duplicate for standy
    mseberg Guru
    Currently Being Moderated
    Hello;

    All my Oracle 10's are long gone. That said this :

    http://www.visi.com/~mseberg/duprman.html

    Should work on Oracle 10.

    Best Regards

    mseberg
  • 2. Re: Issue with duplicate for standy
    993195 Newbie
    Currently Being Moderated
    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.

    Step 5

    http://docs.oracle.com/cd/B19306_01/server.102/b14239/rcmbackp.htm#CHDGDGAA
  • 3. Re: Issue with duplicate for standy
    mseberg Guru
    Currently Being Moderated
    Hello again;
     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---

    Later

    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.



    Best Regards

    mseberg

    Edited by: mseberg on Mar 18, 2013 10:40 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points