(Copy the hot data file back, excluding Control and Redo) SQL> Conn Internal Connected. SQL> Shutdown Immediate; Database CLOSED. Database DISMOUNTED. ORACLETANCE SHUT DOWN. SQL> Copy all hot-standing data files (complete !. successful recovery) mount the database SQL> startup mount ORACLE instance started Total System Global Area 25856028 bytes Fixed Size 75804 bytes Variable Size 8925184 bytes database Buffers 16777216 bytes Redo Buffers 77824 bytes database mounted SQL> full recovery database SQL> recover database;. ORA -00279: Change 424112 20:40:52 needed for thread 1 ora-00289: suggestion: d: /backupdb/archive/backupt001s00001.arc ora-00280: Change 424112 for thread 1 is in sequern 1 specify log: {
.. No longer needed for this recovery Log applied Media recovery complete SQL> to open the database SQL> alter database open; Database altered Verify recovery: Fully restored SQL> conn lunar / lunar Connected SQL> select * from test1; A -.. -------- 1 2 SQL> Fully recovery successfully! Description: 1. Copy all hot-standing data files over 2. Mount database 3. Fully recover database 4. Open the database http://www.cnoug.org/viewthread.php?tid=87&highlight=+lunar