Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
After completing this lesson, you should be able to: • Query the recycle bin • Configure Flashback Database • Perform Flashback Database to a point in time • Monitor flashback log statistics • Enable and disable the Flashback Database feature • Use the Enterprise Manager Recovery Wizard to perform Flashback Database • Use guaranteed restore points with Flashback Database | Flashback Objectives After completing this lesson, you should be able to: Query the recycle bin Configure Flashback Database Perform Flashback Database to a point in time Monitor flashback log statistics Enable and disable the Flashback Database feature Use the Enterprise Manager Recovery Wizard to perform Flashback Database Use guaranteed restore points with Flashback Database Recycle bin Flashback DB Config. FB DB Monitor FB DB Guar. Res. Pt. Flashback Technology: Review Object Level Scenario Examples Flashback Technology Uses Affects Data Database Truncate table; Undesired multitable changes made Database Flashback logs TRUE Table Drop table Drop Recycle bin TRUE Update with the wrong WHERE clause Table Undo data TRUE Compare current data with data from the past Query Undo data FALSE Compare versions of a row Version Undo data FALSE Tx Investigate several historical states of data Transaction Undo data FALSE Flashback Technology: Review Flashback technology must be used when a . | Flashback Objectives After completing this lesson, you should be able to: Query the recycle bin Configure Flashback Database Perform Flashback Database to a point in time Monitor flashback log statistics Enable and disable the Flashback Database feature Use the Enterprise Manager Recovery Wizard to perform Flashback Database Use guaranteed restore points with Flashback Database Recycle bin Flashback DB Config. FB DB Monitor FB DB Guar. Res. Pt. Flashback Technology: Review Object Level Scenario Examples Flashback Technology Uses Affects Data Database Truncate table; Undesired multitable changes made Database Flashback logs TRUE Table Drop table Drop Recycle bin TRUE Update with the wrong WHERE clause Table Undo data TRUE Compare current data with data from the past Query Undo data FALSE Compare versions of a row Version Undo data FALSE Tx Investigate several historical states of data Transaction Undo data FALSE Flashback Technology: Review Flashback technology must be used when a logical corruption occurs in the Oracle database, and you need to recover data quickly and easily. As with human errors, it is difficult to identify the objects and rows that are affected by an erroneous transaction. With flashback technology, you can diagnose how errors are introduced into the database, and then you can repair the damage. You can view the transactions that have contributed to specific row modifications, view the entire set of versions of a given row during some time period, or just view data as it appeared at a specific time in the past. The table in the slide shows typical uses of flashback technology. Flashback Database uses the flashback logs to perform flashback. Flashback Drop uses the recycle bin. All other techniques use undo data. Not all flashback features modify the database. Some are simply methods to query other versions of data. Those are tools for you to use to investigate a problem and aid in recovery. The results of those flashback queries can help you do
