Oracle 9.2.0.3.0 on W2k3
Somehow one of the tablespaces got corrupt and is offline.
We have an online full database backup from 10 days ago, which was done using Veritas BackupExec 9.1 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 (as stated in BackupExec Administrator Guide, page 1303), 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.
Somehow one of the tablespaces got corrupt and is offline.
We have an online full database backup from 10 days ago, which was done using Veritas BackupExec 9.1 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 (as stated in BackupExec Administrator Guide, page 1303), 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.
