Hi guys,
I deleted one of my datafile, and I can't recover it back because I have no
backup.
Can I drop my entire database without reinstalling my Oracle8i ??
Thank you
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
sorry guys I got the answer
dbassist
-Original Message-
Sent: Monday, 12 March 2001 9:28 AM
To: [EMAIL PROTECTED]; 'lzDBA'
Hi guys,
I deleted one of my datafile, and I can't recover it back because I have no
backup.
Can I drop my entire database without reinstalling my
Hi ,
is the datafile very very important to you and filled with many records ?
if the datafile can be ignored, you dont have to drop your database.
just tell to the database that the lost datafile is explicitly dropped.
first , you have to STARTUP NOMOUNT database , then
in SVRMGR type :
Yes those records are very important, how to save them without re-entering
those data (oh man they are alot of data)?
-Original Message-
Setiawan
Sent: Monday, 12 March 2001 10:30 AM
To: Multiple recipients of list ORACLE-L
Hi ,
is the datafile very very important to you and filled
Sorry ,
If you accidentally drop it without having backup , there's no other way to recover
it...
an exprienced DBA just write 3 lines in his summary presentation :
1.BACKUP BACKUP BACKUP
2.PRACTICE , PRACTICE , PRACTICE
3. Dont Panic
HTH ,
=bambang=
Bambang Setiawan
[EMAIL