Home » RDBMS Server » Backup & Recovery » Restore one tablespace!
icon4.gif  Restore one tablespace! [message #110942] Fri, 11 March 2005 04:54 Go to next message
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 Go to previous message
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.
Previous Topic: Problem crash REDO Log files
Next Topic: Where is database and tables saved
Goto Forum:
  


Current Time: Fri Mar 29 05:14:45 CDT 2024