Restore Series 4 - Archive Mode Implementing the Recovery of the entire database

SQL> INSERT INTO TEST_EXCEL VALUES ('2009-03-28', 'YYYY-MM-DD'), 'TES5');

It has created a row.

SQL> CONN / AS SYSDBA is connected. SQL> Shutdown Immediate database has been turned off. The database has been uninstalled. Oracle routines have been closed. SQL> HostMicrosoft Windows 2000 [Version 5.00.2195] (C) All rights reserved 1985-2000 Microsoft Corp .-- Change Example For Simple, only analog to lose a data file, change can implement recovery including system database files

C: /> DEL D: /Oracle9/oradata/nbxtdb/nbxttp.ora

C: /> EXIT

SQL> StartUporacle routines have been started.

Total System Global Area 378608760 Bytesfixed Size 453752 bytesvariable size 167772160 bytesdatabase buffers 209715200 BYTESREDO BUFFERS 667648 BYTES Database Loading. ORA-01157: Unable to identify / lock data files 9 - See DBWR Tracking file ORA-01110: Data file 9: 'D: /oracle9/oradata/nbxtdb/nbxttp.ora'

SQL> SELECT * FROM V $ Recover_File;

File # online online _--------------- ------- Error Change # ------------------- ---------------------------------------------- ---- ------ Time ---------- 9 Online OnlineFile Not Found 0

SQL> HostMicrosoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp.

C: /> COPY E: / ORAHOTBAK/NBXTTTP.ORA D: / ORACLE9 / ORADATA / NBXTDB has copied 1 file.

C: /> EXIT

SQL> Recover Database; ORA-00279: Change 356135 (Generated at 05/27/2004 20:50:36) For thread 1 is the necessary ORA-00289: Recommendation: d: / Oracle9 / ORADATA / NBXTDB / Archive / ARC00100100. Arcora-00280: Change 356135 For thread 1 is performed in sequence # 100

Specify log: { = suggested | filename | auto | ca Zan} autoora-00279: Change 356192 (Generated at 05/27/2004 20:50:40) For thread 1 is an essentible ORA-00289: Recommendation: D: / ORACORA-00280: Change 356192 For thread 1 is ORA-00278 performed in sequence # 101: This recovery no longer needs log file 'D: / Oracle9 / ORADATA / NBXTDB / Archive / Arc00100100.arc'ora-00279: Change 356702 (Generated at 05/27/2004 20:58:10) For thread 1 is an essentible ORA-00289: Suggestion: d: /oacle9/oradata/nbxtdb/archive/arc00100102.arcora -00280: Change 356702 For thread 1 is ORA-00278 performed in sequence # 102: This recovery no longer needs log file 'd: /oracle9/oradata/nbxtdb/archive/ARC00100101.ARC'

Applicable logs. Complete media recovery. SQL> ALTABASE OPEN;

The database has been changed.

SQL> Conn Test / TEST is connected. SQL> SELECT * from test_excel;

Accident Code Time Type ----------------------------------------- ----- 23 22- February -08 TEST125 22-February -08 TEST226 22-February -08 TEST32 24-November -03 Vehicle damage 12 07-February -03 Height fall from 13 21 to October -03 Height fall from 1 22- March -02 2228-28- March -09 Test5

8 lines have been selected.

SQL>