 Restore one tablespace! [message #110942] |
Fri, 11 March 2005 04:54  |
z89zt
Messages: 1
Registered: March 2005
|
Junior Member |
|
|
Oracle 9.2.0.3.0 on W2k3
Somehow one of the tablespaces got corrupt and is offline.
We hava an online full database backup from 10 days ago, which was done using Veritas BackupExec and agent for Oracle server.
We are trying to recover just one tablespace.
Oracle is in the archivelog mode, automatic archiving is enabled.
We managed to recover tablespaceXY.ora file from tape to Oracle server. The we tried to execute "recover" command in SQL Plus, and get the following errors:
ORA-01190: controlfile or datafile 8 is from before the last RESETLOGS.
ORA-01110: data file 8: "D:\oracle\oradata\DBXY\T_tablesp_01.ora
Can someone suggest what are we doing wrong? We have very little experience with Oracle DBMS.
Thanks.
|
|
|
|
| Re: Restore one tablespace! [message #111245 is a reply to message #110942] |
Mon, 14 March 2005 23:17  |
sridcpp
Messages: 23
Registered: February 2005
Location: India
|
Junior Member |
|
|
If your are having backup of the data file T_tablesp_01.ora
copy the T_tablesp_01.ora to the particular directory
"D:\oracle\oradata\DBXY\T_tablesp_01.ora
sql>startup mount
sql>recover database
this will be the media recovery.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
