Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> rman-06024

rman-06024

From: Pedro Espinoza <raindoctor_at_gmail.com>
Date: Thu, 15 Mar 2007 20:42:36 -0400
Message-ID: <b86c876f0703151742s342e5241v10f0e49fdc842db4@mail.gmail.com>


Hi,

I am trying to create a physical standby using RMAN. I took a cold backup, along with controlfile for standby. When I run the script to create standby, I am getting rman-06024 and rman-6026, even though the controlfile for standby exists.

The script to take backup:

run {
allocate channel d1 type disk;
backup format '/RMANBKUP/data/bohr/STDBY/df_t%t_s%s_p%p'database; sql 'alter system archive log current';
backup format '/RMANBKUP/data/bohr/STDBY/al_t%t_s%s_p%p' archivelog all; backup current controlfile for standby format '/RMANBKUP/data/bohr/STDBY/PROD/sb_t%t_s%s_p%p'; release channel d1;
}

create standby script:


RUN {

set newname for datafile 1 to '/ORA_OEM/data/OEMRMAN/system01.dbf';
set newname for datafile 2 to '/ORA_OEM/data/OEMRMAN/undotbs01.dbf';
set newname for datafile 3 to '/ORA_OEM/data/OEMRMAN/indx01.dbf';
set newname for datafile 4 to '/ORA_OEM/data/OEMRMAN/tools01.dbf';
set newname for datafile 5 to '/ORA_OEM/data/OEMRMAN/users01.dbf';
set newname for datafile 6 to '/ORA_OEM/data/OEMRMAN/mgmt.dbf';
set newname for datafile 7 to '/ORA_OEM/data/OEMRMAN/mgmt_ecm_depot1.dbf';
set newname for datafile 8 to '/ORA_OEM/data/OEMRMAN/sysaux01.dbf';
set newname for datafile 9 to '/ORA_OEM/data/OEMRMAN/mgmt01.dbf';
set newname for tempfile 1 to '/ORA_OEM/data/OEMRMAN/temp01.dbf';

set until sequence = 12 thread = 1;

allocate channel C1 device type disk;
allocate auxiliary channel C2 device type disk; duplicate target database for standby;
}

The error stack:

RMAN-03002: failure of Duplicate Db command at 03/15/2007 19:58:04
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

RMAN> **end-of-file**

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 15 2007 - 19:42:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US