| control files again-URGENT [message #54240] |
Wed, 06 November 2002 09:29  |
Juergen
Messages: 7
Registered: August 2002
|
Junior Member |
|
|
Hi, a customer of mine was stolen all the hard disks (!!!?), but he has a backup. But the backup has no control files, no redo files and no archive log files. Bad scenario, i think.
They try to create the control files with the RESETLOGS option. The
ALTER DATABASE OPEN RESETLOGS
shows an error 01113 (file system01.dbf needs media recovery). So they try
RECOVER DATABASE USING BACKUP CONTROL FILE;
But it asks for an archive file arc00690.001 which doesn't exist (there is no archive file at all).
Is there any solution?
There is only one relevant user in the database. Is there any way to dump this data (recreate the whole database and import the user)?
Any hint is appreciated.
Juergen
|
|
|
|
|
|
| Re: control files again-URGENT [message #54257 is a reply to message #54240] |
Thu, 07 November 2002 03:56  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
No Ur database is dead. If u do HOT BACKUP u should always have ARCHIVELOG ... Who's the DBA ?
Did U have any other backup ?
if not only ORACLE can do something for U CALL SUPPORT
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
