rman-06024
- From: "Pedro Espinoza" <raindoctor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 Mar 2007 20:42:36 -0400
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**
Other related posts:
