Hi,
I have rman backup taken 20 days back and all of sudden by database has
crashed, I have created DB using new manual script.
RMAN backup was on same machine, after running following command at RMAN
prompt
RMAN> startup force nomount
RMAN>Restore Database,
I got following error message,
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
Can somebody help me resolve this issue; I have tried catalog database
using
Rman>catalog backup C:\dBABACKUP\ORA_DF63447934338
But than I have same problem.
Regds,
Vaishali.
-----Original Message-----
From: Ingram David L
[mailto:oracledba-ezmlmshield-x52221816.[Email address protected]
Sent: Thursday, November 29, 2007 8:19 PM
To: LazyDBA Discussion
Subject: RE: DB Create using RMAN
You can use the rman duplicate command
http://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdup
db006.htm
-----Original Message-----
From: Vaishali Kamdar
[mailto:oracledba-ezmlmshield-x68476802.[Email address protected]
Sent: Thursday, November 29, 2007 6:00 AM
To: LazyDBA Discussion
Subject: DB Create using RMAN
Hi ALL,
I have Database backup which was raken using RMAN with control files but
I don't have actual OS copy of datafiles.I am creating database from
scratch for testing.
How to start restoring database using RMAN to newly created DB .
Regds,
Vaishali.
----------------------------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are
solely for the use of the individual or entity to which it is addressed.
Any use, distribution, copying or disclosure by any other person is
strictly prohibited. If you receive this transmission in error, please
notify the sender by reply email and then destroy the message. Opinions,
conclusions and other information in this message that do not relate to
official business of the company shall be understood to be neither given
nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information
contained in this email, when addressed to Clients is subject to the
terms and conditions in governing client contract.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
----------------------------------------------------------------------
DISCLAIMER
This email and any files transmitted with it are confidential and are solely for the use of the individual or entity to which it is addressed. Any use, distribution, copying or disclosure by any other person is strictly prohibited. If you receive this transmission in error, please notify the sender by reply email and then destroy the message. Opinions, conclusions and other information in this message that do not relate to official business of the company shall be understood to be neither given nor endorsed by NIIT Ltd. or NIIT Technologies Ltd. Any information contained in this email, when addressed to Clients is subject to the terms and conditions in governing client contract.
Oracle LazyDBA home page