| RMAN -6023 [message #148658] |
Sat, 26 November 2005 00:16  |
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  |
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??
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
