Thanks. That worked, but I still don't understand why I need a standby controlfile backup when I am not creating a standby database. - Peter Schauss From: April Sims [mailto:aprilcsims@xxxxxxxxx] Sent: Thursday, November 03, 2011 10:35 AM To: Schauss, Peter (ESS) Subject: EXT :Re: rman duplicate wants a standby control file RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY; On Thu, Nov 3, 2011 at 8:30 AM, Schauss, Peter (ESS) <peter.schauss@xxxxxxx<mailto:peter.schauss@xxxxxxx>> wrote: This is Oracle 11.2.0.1.0 running on Aix 5.3. I am trying to duplicate a production database to create a test environment (and to test my backup strategy). My backup script looks like this: export ORACLE_SID=$1 rman nocatalog <<EOF connect target sys/syspassword run { allocate channel ch1 type disk format '$BACKUP_DIR2/${BASE_NAME}_1_%U.rbk'; allocate channel ch2 type disk format '$BACKUP_DIR2/${BASE_NAME}_2_%U.rbk'; allocate channel ch3 type disk format '$BACKUP_DIR2/${BASE_NAME}_3_%U.rbk'; allocate channel ch4 type disk format '$BACKUP_DIR2/${BASE_NAME}_4_%U.rbk'; allocate channel ch5 type disk format '$BACKUP_DIR2/${BASE_NAME}_5_%U.rbk'; allocate channel ch6 type disk format '$BACKUP_DIR2/${BASE_NAME}_6_%U.rbk'; backup database plus archivelog; sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; } exit My duplicate script is: export ORACLE_SID=pro2qa rman nocatalog <<EOF connect auxiliary sys/syspassword run{ set newname for datafile 1 to '/u06/oradata/pro2qa/system01.dbf'; set newname for datafile 2 to '/u06/oradata/pro2qa/undotbs01.dbf'; set newname for datafile 3 to '/u06/oradata/pro2qa/sysaux01.dbf'; set newname for datafile 4 to '/u06/oradata/pro2qa/users01.dbf'; set newname for datafile 5 to '/u06/oradata/pro2qa/indxts1_x01.dbf'; set newname for datafile 6 to '/u06/oradata/pro2qa/datats1_d01.dbf'; set newname for tempfile 1 to '/u06/oradata/pro2qa/temp01.dbf'; set newname for datafile 7 to '/u06/oradata/pro2qa/datats2_db01.dbf'; set newname for datafile 8 to '/u06/oradata/pro2qa/indexts2_db01.dbf'; duplicate database to pro2qa backup location '/orabkup2/pro2/rman' logfile group 1('/u06/oradata/pro2qa/redo01.log') size 50m, group 2('/u06/oradata/pro2qa/redo02.log') size 50m, group 3('/u06/oradata/pro2qa/redo03.log') size 50m; } exit EOF When I run the duplicate script I get: channel ORA_AUX_DISK_1: restoring control file RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 11/03/2011 09:05:44 RMAN-03015: error occurred in stored script Memory Script ORA-19697: standby control file not found in backup set Why is it asking for standby control file? Looking at the output from my backup script I see that the control file is being backed up: including current control file in backup set channel ch5 I also backed up the control file separately using: alter database backup controlfile to <file nam>; FWIW, a search for ORA-19697 on MOS turns up nothing. Also, when I ran this same script several months ago I was able to successfully duplicate the database. What's going on here? Thanks, Peter Schauss -- //www.freelists.org/webpage/oracle-l -- April C. Sims IOUG SELECT Journal Executive Editor http://aprilcsims.wordpress.com Twitter, LinkedIn Oracle Database 11g - Underground Advice for Database Administrators https://www.packtpub.com/oracle-11g-database-implementations-guide/book OCP 8i, 9i, 10g, 11g DBA Southern Utah University aprilcsims@xxxxxxxxx<mailto:aprilcsims@xxxxxxxxx> -- //www.freelists.org/webpage/oracle-l