Home » RDBMS Server » Backup & Recovery » duplicate database error : ORA-01405: fetched column value is NULL (Oracle Database, 10.2.0.5, SPARC 5.8 )
duplicate database error : ORA-01405: fetched column value is NULL [message #532181] Mon, 21 November 2011 03:53 Go to next message
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



Re: duplicate database error : ORA-01405: fetched column value is NULL [message #532185 is a reply to message #532181] Mon, 21 November 2011 04:26 Go to previous messageGo to next message
John Watson
Messages: 7255
Registered: January 2010
Location: Global Village
Senior Member
In some releases, you will get this if there are no archivelogs to apply. Have there been any log switches since the backup was made?
Re: duplicate database error : ORA-01405: fetched column value is NULL [message #532186 is a reply to message #532181] Mon, 21 November 2011 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See Metalink/MOS note ID 280823.1

Regards
Michel
Re: duplicate database error : ORA-01405: fetched column value is NULL [message #532321 is a reply to message #532186] Tue, 22 November 2011 00:43 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

Thanks Gents.
Re: duplicate database error : ORA-01405: fetched column value is NULL [message #532585 is a reply to message #532321] Wed, 23 November 2011 09:34 Go to previous message
Michael90
Messages: 2
Registered: November 2011
Junior Member
Thanks! *CLicking thanks button*
Previous Topic: rman and Tivoli backup
Next Topic: Connect to Target db
Goto Forum:
  


Current Time: Sun Feb 18 13:18:13 CST 2018

Total time taken to generate the page: 0.01348 seconds