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

Home -> Community -> Usenet -> c.d.o.server -> can not identify file when Rman duplicate standby database

can not identify file when Rman duplicate standby database

From: yoke wang <cnwy_at_263.net>
Date: 12 Apr 2005 03:49:18 -0700
Message-ID: <42c18ceb.0504120249.28c9ccba@posting.google.com>


Hi,   

Primary Node
  OS: RAS3 Oracle: 9204
Standby Node
  OS: RAS3 Oracle: 9204
RMAN Catalog Node:
  OS: WindowsXP Oracle:9201

Run RMAN on WindowsXP,Below is output.

############################################################################
D:\>rman catalog rman/rman target sys/xxx_at_primary auxiliary sys/xxx_at_standby

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: ORCL (DBID=1083153663) connected to recovery catalog database
connected to auxiliary database: orcl (not mounted)

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/9.2.0/dbs/snapcf_or l.f'; # default

RMAN> RMAN> DUPLICATE TARGET DATABASE FOR STANDBY 2> NOFILENAMECHECK; Starting Duplicate Db at 12-APR-05
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=14 devtype=DISK

printing stored script: Memory Script
{

   restore clone standby controlfile to clone_cf;    replicate clone controlfile from clone_cf;    sql clone 'alter database mount standby database'; }
executing script: Memory Script

Starting restore at 12-APR-05

using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: restoring controlfile

output filename=/opt/oracle/oradata/orcl/control01.ctl
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/12/2005 18:39:30 RMAN-03015: error occurred in stored script Memory Script ORA-19505: failed to identify file "/opt/oracle/product/9.2.0/dbs/08ghmpkr_1_1" ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory Additional information: 3

RMAN>
############################################################################
  I think I must miss something.
  Must I copy the backup file from primary node to standby node manually?

  Any Suggestions will be appriciated.

wy. Received on Tue Apr 12 2005 - 05:49:18 CDT

Original text of this message

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