Restoration of Oracle8i tablespace and Data

When Microsoft Windows Server 2000 and Oracle8i reading is Edition 8.1.7 are in use, the client application reports a read/write error in the data window view, enters Oracle DBA Studio as SYSDBA, and finds "D: ORACLEORADATAORCLAPINFO. DBF "data file" offline ". An error occurred while trying to "Connect.

You can continue to view the "TSP_INFO" tablespace in the "tablespace" branch of DBA Studio. The tablespace is also in the "offline" status, and only one data file is available in this space.

First, you must find the corresponding cold backup or hot backup file. We can use any of the tablespace or data file recovery (RECOVER) methods. This method must ensure that the database instance is open and run D: OracleOra81BINSVRMGRL in the "SVRMGRL" Console window. the EXE executable file connects to the database instance with SYSDBA such as internal/oracle account, and completes with the file copy function of the operating system. The specific steps for the two recovery methods are as follows:

Table space restoration method

1. SEVMGR> alter tablespace tsp_info offline immediate;
2. Use the file copy function of the operating system to copy the cold or online Hot Backup APINFO. DBF to the current working directory.
3. SEVMGR> recover automatic tablespace tsp_info;
4. SEVMGR> alter tablespace tsp_info online;

Data File restoration method

1. SEVMGR> alter database datafile 'd: oracleoradataorclapinfo. dbf' offline immediate;
2. Use the file copy function of the operating system to copy the cold or online Hot Backup APINFO. DBF to the current working directory.
3. SEVMGR> recover automatic datafile 'd: oracleoradataorclapinfo. dbf ';
4. SEVMGR> alter database datafile 'd: oracleoradataorclapinfo. dbf' online;

The above two methods are non-system tablespace or data file recovery, but they are all based on the premise of a backup, so we must do a regular or daily cold backup or hot backup, prepare for future disaster recovery.

(