Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> can not identify file when Rman duplicate standby database
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
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
![]() |
![]() |