Re: EXT :Re: rman duplicate wants a standby control file
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: Hemant.Chitale@xxxxxx
- Date: Sat, 5 Nov 2011 11:52:42 -0500
I think this wouldn't be necessary if you connected to the target.
On Thu, Nov 3, 2011 at 8:46 PM, Chitale, Hemant Krishnarao
<Hemant.Chitale@xxxxxx> wrote:
>
> I would say that you need a separate controlfile backup -- a controlfile
> autobackup.
> Since yours is a NOCATALOG backup, Oracle cannot identify which backupset
> contains the controlfile
> (else it would have to probe each backuppeice !).
> However a controlfile autobackup in the "correct" location can be immediately
> identified.
>
>
> Try with CONTROLFILE AUTOBACKUP ON. (and not having to create a Standby
> controlfile).
>
>
> Hemant K Chitale
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of Schauss, Peter (ESS)
> Sent: Friday, November 04, 2011 2:12 AM
> To: April Sims
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: RE: EXT :Re: rman duplicate wants a standby control file
>
> 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
>
>
>
> This email and any attachments are confidential and may also be privileged.
> If you are not the addressee, do not disclose, copy, circulate or in any
> other way use or rely on the information contained in this email or any
> attachments. If received in error, notify the sender immediately and delete
> this email and any attachments from your system. Emails cannot be guaranteed
> to be secure or error free as the message and any attachments could be
> intercepted, corrupted, lost, delayed, incomplete or amended. Standard
> Chartered PLC and its subsidiaries do not accept liability for damage caused
> by this email or any attachments and may monitor email traffic.
>
> Standard Chartered PLC is incorporated in England with limited liability
> under company number 966425 and has its registered office at 1 Aldermanbury
> Square, London, EC2V 7SB.
>
> Standard Chartered Bank ("SCB") is incorporated in England with limited
> liability by Royal Charter 1853, under reference ZC18. The Principal Office
> of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In
> the United Kingdom, SCB is authorised and regulated by the Financial Services
> Authority under FSA register number 114276.
>
> If you are receiving this email from SCB outside the UK, please click
> http://www.standardchartered.com/global/email_disclaimer.html to refer to the
> information on other jurisdictions.
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
