Re: can not identify file when Rman duplicate standby database

On Tue, 12 Apr 2005 03:49:18 -0700, yoke wang wrote:

> 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.

Exactly. You have to copy all backup pieces and archived logs manually.

Jerome Received on Tue Apr 12 2005 - 06:00:56 CDT