OraFAQ Forum: Backup & Recovery » duplicate database error : ORA-01405: fetched column value is NULL

Home » RDBMS Server » Backup & Recovery » duplicate database error : ORA-01405: fetched column value is NULL (Oracle Database, 10.2.0.5, SPARC 5.8 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

duplicate database error : ORA-01405: fetched column value is NULL [message #532181]

Mon, 21 November 2011 03:53

drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana

Member

Below is an error I keep getting but it does not point to anything I can fix, anybody have any ideas.

morojwa:HDES:/u01/app/oracle/product/10.2.0/KFXTRG/dbs

rman target sys/hdprod101@HDPROD nocatalog auxiliary /

Recovery Manager: Release 10.2.0.5.0 - Production on Mon Nov 21 11:55:19 2011

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

connected to target database: HDPROD (DBID=1367469811)
using target database control file instead of recovery catalog
@connected to auxiliary database: HDES (not mounted)

RMAN> @hdes_dup.rcv

RMAN> run {
2> set newname for datafile 1 to '/HDES/oradata/rsystem';
3> set newname for datafile 2 to '/HDES/oradata/rbs_01';
4> set newname for datafile 3 to '/HDES/oradata/tools';
5> set newname for datafile 4 to '/HDES/oradata/users01';
6> set newname for datafile 5 to '/HDES/oradata/hd_index01';
7> set newname for datafile 6 to '/HDES/oradata/hd_tables01';
8> set newname for datafile 7 to '/HDES/oradata/sysaux.dbf';
9> duplicate target database to HDES logfile group 1 ('/HDES/oradata/redo1a.log','/HDES/oradata/redo1b.log') size 100M, group 2 ('/HDES/oradata/redo2a.log','/HDES/oradata/redo2b.log') size 100M;
10> }
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 21-NOV-11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=157 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/21/2011 11:55:28
ORA-01405: fetched column value is NULL

RMAN> **end-of-file**

RMAN> exit

Recovery Manager complete.
morojwa:HDES:/u01/app/oracle/product/10.2.0/KFXTRG/dbs

Report message to a moderator