Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm working on creating duplication scripts for standby purposes. and it's constantly failing even though the backups are located in the exact same folder. DB structure is identical and spfile is already configured for standby. and it results in this.

channel aux1: restoring control file
ORA-19625: error identifying file /home/oracle/stdbyctrl.ctl
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file  (/home/oracle/stdbyctrl.ctl)
ORA-19601: output file is control file  (/opt/oracle/oradata/vcas/control01.ctl)
failover to previous backup

I have been searching a solution for a few days now and I think I need the help of the community. It does work if I take the backup in the flash recovery area, but i need this method because it will be applied on a cluster to cluster replication using ASM on both clusters. Thank you in advance:

Details below:

This is the procedure I'm using: From my primary server: I perform the backup.

rman target sys/verimatrix@to_primary auxiliary sys/verimatrix@to_standby catalog rman/cat@to_primary << EOF
> RUN {
> allocate channel d1 type disk;
> backup format '/home/oracle/ForStandby_%U.bkp' database;
> sql 'alter system archive log current';
> backup format '/home/oracle/ForStandby_arc_%U.bkp' archivelog all;
> backup current controlfile for standby format '/home/oracle/ForStandbyCTRL.bkp';
> release channel d1;
> }
> EOF

Then I copy them to the standby in the oracle home as well:

$scp ForStandby* vmx@192.168.1.149:/home/vmx
ForStandby_0qoib29b_1_1.bkp                                  100%  545MB  23.7MB/s   00:23
ForStandby_0roib29i_1_1.bkp                                  100% 6976KB   6.8MB/s   00:00
ForStandby_arc_0soib29n_1_1.bkp                              100%   49MB  24.6MB/s   00:02
ForStandbyCTRL.bkp                                           100% 6944KB   6.8MB/s   00:00

On standby server:

[oracle@standby ~]$ ll
total 622716
-rw------- 1 oracle dba  571039744 Aug 27 13:51 ForStandby_0qoib29b_1_1.bkp
-rw------- 1 oracle dba    7143424 Aug 27 13:51 ForStandby_0roib29i_1_1.bkp
-rw------- 1 oracle dba   51538432 Aug 27 13:51 ForStandby_arc_0soib29n_1_1.bkp
-rw------- 1 oracle dba    7110656 Aug 27 13:51 ForStandbyCTRL.bkp

Then I execute the duplicate command from the primary:

[oracle@primary ~]$ rman target sys/verimatrix@to_primary auxiliary sys/verimatrix@to_standby catalog rman/cat@to_primary << EOF

> RUN
> {
>   ALLOCATE CHANNEL C1 type disk;
>   ALLOCATE AUXILIARY CHANNEL aux1 TYPE DISK;
>   DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK DORECOVER;
>   RELEASE CHANNEL C1;
>   RELEASE CHANNEL aux1;
> }
> EOF

Which fails like this invariably:

Recovery Manager: Release 10.2.0.5.0 - Production on Tue Aug 27 07:59:02 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: VCAS (DBID=3516284596)
connected to recovery catalog database
connected to auxiliary database: VCAS (not mounted)

RMAN> 2> 3> 4> 5> 6>
allocated channel: C1
channel C1: sid=139 devtype=DISK

allocated channel: aux1
channel aux1: sid=152 devtype=DISK

Starting Duplicate Db at 27-AUG-13

contents of Memory Script:
{
   set until scn  429183;
   restore clone standby controlfile;
   sql clone 'alter database mount standby database';
}
executing Memory Script

executing command: SET until clause

Starting restore at 27-AUG-13

channel aux1: restoring control file
ORA-19625: error identifying file /home/oracle/stdbyctrl.ctl
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file  (/home/oracle/stdbyctrl.ctl)
ORA-19601: output file is control file  (/opt/oracle/oradata/vcas/control01.ctl)
failover to previous backup
share|improve this question
    
Can you post the control file part of the pfile or string spfile? –  Munchi Aug 29 '13 at 9:34
    
Move /home/oracle/ForStandbyCTRL.bkp to /home/oracle/stdbyctrl.ctl ? –  Phil Aug 29 '13 at 9:39
    
Did you check active duplication? DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE PASSWORD FILE ... –  Munchi Aug 29 '13 at 9:39
    
@Phil, where is he getting this value from. He needs a solution not a quick fix :) –  Munchi Aug 29 '13 at 9:42
    
@Munchi I /think/ it looks for a file called $ORACLE_HOME/$ORACLE_SID.ctl (then looks in $ORACLE_HOME/dbs), so my suggestion is THE fix, not a quick fix –  Phil Aug 29 '13 at 9:53
show 5 more comments

1 Answer 1

This is the problem:

$scp ForStandby* vmx@192.168.1.149:/home/vmx

You need to copy the files to /home/oracle. RMAN can't find the files because your scp command copied the files to /home/vmx.

share|improve this answer
    
I tried that. It didn't work either. I have found a solution but I could never make that method work. –  ndefontenay Jan 10 at 20:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.