Home » RDBMS Server » Backup & Recovery » RMAN -6023
RMAN -6023 [message #148658] Sat, 26 November 2005 00:16 Go to next message
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
Member
hi all
I am getting one error while restoring one lost datafile using RMAN can anybody help me please.....

I backuped up total database....and then deleted all the datafile s and I have done restore and recovery through RMAN ...It is successfullly done ....database is working fine...next I deleted one non system datafile...and then while restoring it is giving problem..no backup of that file is there...
here i am giving the error.. my database is 9.2.0.1.0 running on lunux machine....can anybody help me please..

[nals@oralinux9 nals]$ rman catalog rman/rman target sys/sys@topay

Recovery Manager: Release 9.2.0.1.0 - Production

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

connected to target database: PAY (DBID=1708202702)
connected to recovery catalog database

RMAN> restore datafile 4;

Starting restore at 26-NOV-05

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/26/2005 11:38:34
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore

RMAN>


Thanks in advance
subbu
Re: RMAN -6023 [message #148669 is a reply to message #148658] Sat, 26 November 2005 02:20 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

The error is self explanatory no backup or copy of datafile 4 found to restore.

Are you sure that you have the backup of the specified datafile??


Re: RMAN -6023 [message #148675 is a reply to message #148658] Sat, 26 November 2005 03:46 Go to previous message
bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad
Member
Hi tarun,
Thank u very much...
that file is missed in backup...
bye
subbu
Previous Topic: how to recover database if o/s corrupted & also loss server?plz step by step with script with de
Next Topic: Please see this....? when o/s get corrupt .....
Goto Forum:
  


Current Time: Thu Dec 01 14:13:50 CST 2022