tailieunhanh - ORACLE8i- P13

ORACLE8i- P13: We want information information.” Possibly you recognize these words as the primary interest of a somewhat clandestine group, and as told by a character called Number 2 to Patrick McGoohan’s character Number 6 (in the old TV show The Prisoner). Indeed, in this day, information is king, and the speedy, accurate, and reliable retrieval of this information is paramount. | 474 CHAPTER 10 PHYSICAL BACKUP AND RECOVERY Now let s look at the table. SQL SELECT TO_CHAR the_time mm dd yyyy hh24 mi ss FROM time_table TO_CHAR THE_TIME M 04 29 2001 00 24 52 04 29 2001 00 24 54 04 29 2001 00 27 26 04 29 2001 00 27 26 Shut down the database. SQL SHUTDOWN IMMEDIATE Database closed. Database dismounted. ORACLE instance shut down. Recover the last backup. SQL HOST COPY d oracle_backup hot . d oracle oradata recover d oracle_backup hot d oracle_backup hot d oracle_backup hot d oracle_backup hot d oracle_backup hot d oracle_backup hot d oracle_backup hot Mount the database. SQL STARTUP MOUNT ORACLE instance started. Total System Global Area 92280076 bytes Fixed Size 70924 bytes Variable Size 87937024 bytes Database Buffers 4194304 bytes Redo Buffers 77824 bytes Database mounted. We begin the change-based recovery. Notice we use automatic application of archived redo logs -- in response to the recovery prompt. Please purchase PDF Split-MJe 9e n to removebihis watermark. RECOVERIES IN ARCHIVELOG MODE 475 Change 35936 is the first change in the online redo log after we forced the log switch thus we will recover up to but not including that point. SQL RECOVER DATABASE UNTIL CHANGE 35936 We open the database. Note the use of RESETLOGS. SQL ALTER DATABASE OPEN RESETLOGS We query the table and see only two records SQL SELECT TO_CHAR the_time mm dd yyyy hh24 mi ss FROM time_table TO_CHAR THE_TIME M 04 29 2001 00 24 52 04 29 2001 00 24 54 Cancel-Based Recovery Cancel-based recovery allows you to manually apply archived redo logs to the database during a recovery but be able to stop the recovery after the application of each archived redo log and open the database. This is handy in cases where you have lost a control file or the online redo log and you need to recover the database as much as possible. To .