Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
OCA /OCP Oracle Database 11g A ll-in-One Exam Guide- P66:There is an ever increasing demand for staff with IT industry certification. The benefits to employers are significant—they can be certain that staff have a certain level of competence—and the benefits to the individuals, in terms of demand for their services, are equally great. Many employers are now requiring technical staff to have certifications, and many IT purchasers will not buy from firms that do not have certified staff. | This page intentionally left blank CHAPTER 16 Restore and Recover with RMAN Exam Objectives In this chapter you will learn to 052.16.1 052.16.1 Describe the Data Recovery Advisor Use the Data Recovery Advisor to Perform Recovery Controlfile Redo Log File and Datafile 053.7.1 Perform Complete Recovery from a Critical or Noncritical Datafile Loss Using RMAN 053.7.2 053.7.3 053.7.4 053.7.6 053.13.3 Perform Incomplete Recovery Using RMAN Recover Using Incrementally Updated Backups Switch to Image Copies for Fast Recovery Recover Using a Backup Controlfile Perform Block Media Recovery 607 OCA OCP Oracle Database 11g All-in-One Exam Guide 608 In principle restore and recovery Oracle uses these terms very precisely following a failure are simple To restore a damaged file is to extract it from a previously made backup to recover it is to apply change vectors extracted from the redo stream thus bringing it up to date. Recovery can be complete meaning no loss of data or incomplete meaning that you do deliberately lose data . However there are many variations depending on the nature of the damage and the downtime that can be tolerated. Using Recovery Manager automates the process which can make restore and recovery operations much faster than using manual techniques and also eliminates the possibility of making mistakes. There is also a Data Recovery Advisor Wizard which can diagnose problems and recommend the best action to take. The Data Recovery Advisor The Data Recovery Advisor the DRA is a facility for diagnosing and repairing problems with a database. There are two interfaces the RMAN executable and Enterprise Manager. The DRA is capable of generating scripts to repair damage to datafiles and in some circumstances the controlfile it does not advise on problems with the spfile or with the online redo log files. It is dependent on the Automatic Diagnostic Repository the ADR and the Health Monitor. The information the Health Monitor gathers and the advice the DRA gives .