| recreate tablespace from .ORA file [message #52924] |
Tue, 20 August 2002 23:06  |
patrick
Messages: 83
Registered: December 2000
|
Member |
|
|
Hi,
My server crashed (HDD Failure) and I didn't have a decent backup. Ther only thing I could manage to save were the ORA files.
Is it possible to restore a database from only this file and how can I do this?
Thanks in advance.
Patrick
|
|
|
|
| Re: recreate tablespace from .ORA file [message #52947 is a reply to message #52924] |
Wed, 21 August 2002 09:54  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
What about the control files? Do you have any log file from "ALTER DATABASE BACKUP CONTROLFILE TO TRACE"?
If you don't have the control files or any backup of them then - recreate the control file as:
CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 32
MAXINSTANCES 16
MAXLOGHISTORY 1600
LOGFILE
GROUP 1
'/diska/prod/sales/db/log1t1.dbf',
'/diskb/prod/sales/db/log1t2.dbf'
) SIZE 100K
GROUP 2
'/diska/prod/sales/db/log2t1.dbf',
'/diskb/prod/sales/db/log2t2.dbf'
) SIZE 100K,
DATAFILE
'/diska/prod/sales/db/database1.dbf',
'/diskb/prod/sales/db/filea.dbf'
;
You have to know the exact location and names of your data and redo log files.
If you also lost your redo log files, then do:
ALTER DATABASE RENAME FILE "/oracle/dbs/old_redo_log_file.log" TO "/temp/new_redo_log_file.log";
and
ALTER DATABASE CLEAR LOGFILE UNARCHIVED GROUP 1 UNRECOVERABLE DATAFILE; ( do that for all groups).
Also backup your existing data files before trying anything. Keep a separate copy on a side.
Of course, you better read the Backup & Recovery Manual first...
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
