Recover from failures in the RAC environment.
Diagnose and repair a data file corruption online.
Diagnose and repair a data file corruption offline.
Diagnose and repair failures on a standby database
第1题:
A. Diagnose and repair a data file corruption offline.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair failures on a standby database.
D. Recover from failures in the Real Application Cluster (RAC) environment.
第2题:
Which kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()
第3题:
A. The data file is checked for physical corruption and backed up if found clean.
B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
第4题:
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning, while querying the user1.employeestable, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5:’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following: The data file should remain online. The mean time to recover (MTTR) should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose?()
第5题:
Which two activities are NOT supported by the Data Recovery Advisor?()
第6题:
A. failures because a data file is renamed by error
B. failures when no standby database is configured
C. failures that require no archive logs to be applied for recovery
D. failures due to loss of connectivity-for example, an unplugged disk cable
第7题:
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file. Which method would you use for recovery?()
第8题:
A. Another repair session is running concurrently.
B. The failure ID has not been mentioned in the command for data file 5.
C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).
D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
第9题:
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employees table, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5: ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following: The data file should remain online. The mean time to recover (MTTR) should be minimal. You are not using a backup control file, and all the archived logs are accessible. Which option would you choose?()
第10题:
Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist()