prerequisite: the beginning, the database has been restored when the deleted table spaces created in archivelog mode, do the following: SQL> archive log list; Database log mode Archive ModeAutomatic archival EnabledArchive destination F: / oracle / ora92 / RDBMSOldest online log sequence 23Next log sequence TO Archive 25Current Log Sequence 25
SQL> ALTER TABLESPACE BACKUPTEST OFFLINE; ALTER TABLESPACE BACKUPTEST OFFLINE * Error At Line 1: ORA-01109: Database Not Open
SQL> ALTER DATABASE DATAFILE 'F: /BACKUP.DBF' OFFLINE
Database altered.
SQL> ALTABASE OPEN;
Database altered.
SQL> ALTER TABLESPACE BackupTest Offline Immediate;
TableSpace altered.
SQL> SELECT * FROM V $ Recover_File;
File # Online Online_ Error Change # Time -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------- ------- --------- 11 OFFLINE OFFLINE FILE NOT Found 0
SQL> ALTABASE CREATE DATAFILE 'F: /BACKUP.DBF' AS 'F: /BACKUP.DBF';
Database altered.
SQL> SELECT * FROM V $ Recover_File;
File # Online Online_ Error Change # Time -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------- ------- --------- 11 OFFLINE OFFLINE 3074706 03-NOV-04
SQL> Recover TableSpace Backuptest; Media Recovery Complete.SQL> ALTER TABLESPACE BackupTest Online
TableSpace altered.
SQL> SELECT * from Backup;
ID ---------- 1 2 here, it has been completely restored ^ _ ^
