SQL> SELECT * FROM SCOTT.TEST; I J K ---------- ---------- ---------- 10 20 30 100 200 300 1000 2000 3000 1 1 1 2 2 2 SQL> REM - - -5 ROWS IN SCOTT.TEST SQL> SQL> REM - - - TAKE THE COLD BACKUP SQL> SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> REM - - - START THE DB AND DO SOME TRANSACTION - WHICH IS NT THERE IN BKUP SQL> SQL> startup ORACLE instance started. Total System Global Area 437330132 bytes Fixed Size 454868 bytes Variable Size 226492416 bytes Database Buffers 209715200 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SQL> SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination F:\TEST\ARC Oldest online log sequence 0 Next log sequence to archive 1 Current log sequence 1 SQL> insert into scott.test values(3,3,3); 1 row created. SQL> insert into scott.test values(4,4,4); 1 row created. SQL> insert into scott.test values(5,5,5); 1 row created. SQL> commit; Commit complete. --------------------THIS DATA IS NOT THERE IN THE BACKUP----------------------- SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> alter system switch logfile; System altered. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination F:\TEST\ARC Oldest online log sequence 2 Next log sequence to archive 4 Current log sequence 4 SQL> REM SHUTDOWN THE DB, DELETE EVERYTHING EXCEPT THE INITTEST.ORA SQL> SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> REM DELETING...... SQL> SQL> startup nomount ORACLE instance started. Total System Global Area 437330132 bytes Fixed Size 454868 bytes Variable Size 226492416 bytes Database Buffers 209715200 bytes Redo Buffers 667648 bytes SQL> SQL> SQL> REM --- COPY THE DATAFILES TO THE LOCATION... SQL> SQL> CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS FORCE LOGGING ARCHIVELOG 2 -- SET STANDBY TO MAXIMIZE PERFORMANCE 3 MAXLOGFILES 5 4 MAXLOGMEMBERS 2 5 MAXDATAFILES 100 6 MAXINSTANCES 1 7 MAXLOGHISTORY 226 8 LOGFILE 9 GROUP 1 'F:\TEST\REDO01.LOG' SIZE 100M, 10 GROUP 2 'F:\TEST\REDO02.LOG' SIZE 100M, 11 GROUP 3 'F:\TEST\REDO03.LOG' SIZE 100M 12 -- STANDBY LOGFILE 13 DATAFILE 14 'F:\TEST\SYSTEM01.DBF', 15 'F:\TEST\UNDOTBS01.DBF', 16 'F:\TEST\USERS.ORA' 17 CHARACTER SET WE8MSWIN1252 18 ; Control file created. SQL> SQL> REM -- SHIP THE NECESSARY ARCHIVES SQL> SQL> recover database using backup controlfile; ORA-00279: change 889559 generated at 08/22/2005 11:32:49 needed for thread 1 ORA-00289: suggestion : F:\TEST\ARC\ARCH_T1_S1.DBF ORA-00280: change 889559 for thread 1 is in sequence #1 Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00279: change 889734 generated at 08/22/2005 11:38:20 needed for thread 1 ORA-00289: suggestion : F:\TEST\ARC\ARCH_T1_S2.DBF ORA-00280: change 889734 for thread 1 is in sequence #2 ORA-00278: log file 'F:\TEST\ARC\ARCH_T1_S1.DBF' no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00279: change 889736 generated at 08/22/2005 11:38:21 needed for thread 1 ORA-00289: suggestion : F:\TEST\ARC\ARCH_T1_S3.DBF ORA-00280: change 889736 for thread 1 is in sequence #3 ORA-00278: log file 'F:\TEST\ARC\ARCH_T1_S2.DBF' no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00279: change 889740 generated at 08/22/2005 11:38:27 needed for thread 1 ORA-00289: suggestion : F:\TEST\ARC\ARCH_T1_S4.DBF ORA-00280: change 889740 for thread 1 is in sequence #4 ORA-00278: log file 'F:\TEST\ARC\ARCH_T1_S3.DBF' no longer needed for this recovery Specify log: {=suggested | filename | AUTO | CANCEL} ORA-00328: archived log ends at change 888991, need later change 889740 ORA-00334: archived log: 'F:\TEST\ARC\ARCH_T1_S4.DBF' SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01113: file 1 needs media recovery ORA-01110: data file 1: 'F:\TEST\SYSTEM01.DBF' REM..............................I THOUGHT IT HAD FAILED, SO TRIED TO RECREATE THE CTL FILE , AND NO RECOVERY ATTEMPTED THIS TIME!!................................. SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup nomount ORACLE instance started. Total System Global Area 437330132 bytes Fixed Size 454868 bytes Variable Size 226492416 bytes Database Buffers 209715200 bytes Redo Buffers 667648 bytes SQL> CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS FORCE LOGGING ARCHIVELOG 2 -- SET STANDBY TO MAXIMIZE PERFORMANCE 3 MAXLOGFILES 5 4 MAXLOGMEMBERS 2 5 MAXDATAFILES 100 6 MAXINSTANCES 1 7 MAXLOGHISTORY 226 8 LOGFILE 9 GROUP 1 'F:\TEST\REDO01.LOG' SIZE 100M, 10 GROUP 2 'F:\TEST\REDO02.LOG' SIZE 100M, 11 GROUP 3 'F:\TEST\REDO03.LOG' SIZE 100M 12 -- STANDBY LOGFILE 13 DATAFILE 14 'F:\TEST\SYSTEM01.DBF', 15 'F:\TEST\UNDOTBS01.DBF', 16 'F:\TEST\USERS.ORA' 17 CHARACTER SET WE8MSWIN1252 18 ; Control file created. SQL> alter database open resetlogs; Database altered. SQL> select * from scott.test; -------------------- GOT THE DATA BACK!!! I J K ---------- ---------- ---------- 10 20 30 100 200 300 1000 2000 3000 1 1 1 2 2 2 3 3 3 4 4 4 5 5 5 8 rows selected.