First, ensure that you have made a complete cold backup or hot backup (backup process omitted) SQL> archive log list of the entire database; Database log mode Archive ModeAutomatic archival EnabledArchive destination F: / oracle / ora92 / RDBMSOldest online log sequence 0Next log sequence TO Archive 1Current Log Sequence 1 indicates that the database is running in archiving mode SQL> SELECT * FROM Backup;
ID ---------- 1 2 3 Test Table Backup already exists in three data SQL> Shutdown ImmediateDatabase Closed.Database DISMOUNTEDATABASE CLOSED.DATABASE DISMOUNTEDATABASE CLOSED SHUT DOWN. After completely shut down, you can delete files in Table BACKUP. Backup.dbf, used to simulate damage of data files and then launch database SQL> StartUpoPoracle Instance Started.
Total System Global Area 143727516 bytesFixed Size 453532 bytesVariable Size 109051904 bytesDatabase Buffers 33554432 bytesRedo Buffers 667648 bytesDatabase mounted.ORA-01157: can not identify / lock data file 11 - see DBWR trace fileORA-01110: data file 11: 'F: / ORACLE / ORADATA /Oracas/backup.dbf 'Obviously reports :) View SQL> SELECT * FROM V $ Recover_File;
File # Online Online_ Error Change # Time -------------------------------------------------------------------------------------------------------------------------------- ------------------------------------- --------------- 11 Online Online File Not Found 0 then put backup good backup.dbf file restore SQL> Recover Databasemedia Recovery Complete.SQL> Select * from backup;
ID ---------- 1 2 3 4 Summet: 1, Restore All The Corrupt DataFile from The Cold or Hot Backup; 2, Startup Mount; 3, Recover Database; 4, ALTER DATABASE OPEN; BTW: THIS Is A Sort of Complete Recovery.
