Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovery without backup.
It
existed before 8i. There is an example in Backup and Recovery book. alter
database create datafile ...
and
then recover.
<FONT face=Arial color=#0000ff
size=2>
Alex
Hillman
<FONT face=Tahoma
size=2>-----Original Message-----From: Christopher Spence
[mailto:cspence_at_FuelSpot.com]Sent: Wednesday, August 08, 2001 3:22
PMTo: Multiple recipients of list ORACLE-LSubject:
Recovery without backup.
I don't know much about this feature, but someone
mentioned in 8.1.7 you can recover a datafile even without a backup as long as
you have a control file that knew about it and the archive logs.
Anyone give this a try? I am going to attempt
this weekend on my test box.
"Do not criticize someone until you walked a
mile in their shoes, that way when you criticize them, you are a mile a way
and have their shoes."
Christopher R. Spence <FONT
face="Bell MT" size=1>OCP MCSE MCP A+ RAPTOR CNA <FONT face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" size=2>Fax: (707) 885-2275
face="Comic Sans MS" size=2>73 Princeton Street <FONT face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT face="Comic Sans MS" size=2>Received on Wed Aug 08 2001 - 14:39:45 CDT