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？（）

A、flash back the corrupted blocks

B、use the DBMS_REPAIR package

C、use the RMAN TSPITR command

D、use the RMAN BLOCKRECOVER command

E、use the RESTORE DATABASE and RECOVER DATABASE commands

F、investigate the time at which the corruption occurred and perform a point-in-time recovery

相关问题推荐

• 关于类和对象描述错误的是()。

  A．对象(Object)是现实世界中的客观事物，对象具有确定的属性

  B．类是具有相同属性和行为的一组对象的集合

  C．对象是类的抽象，类是对象的实例

  D．类是对象的抽象，对象是类的实例

  查看答案

• In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level.  You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.  How do you achieve this objective？（）

  A、by setting the SQL_TRACE parameter to FALSE in the parameter file

  B、by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session

  C、by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session

  D、by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

  查看答案

• You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

  A、 Create a backup of the database and recover all corrupted blocks found in the backup.

  B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

  C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

  D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

  E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

  查看答案

• You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）

  A、drop the read­only tablespace and re­create the tablespace after recovery

  B、take data files from the read­only tablespace offline before performing a recovery

  C、perform a recovery; status of the tablespace in control file will be changed automatically

  D、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database

  查看答案

• You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）;  Which statement is true？（）

  A、When a file is created in DGROUP1 with the template， it would have three­way mirroring. 

  B、When a file is created in DGROUP1， the MY_TEMP template becomes the default template.

  C、When a file is created in DGROUP1 with the template， it would have two­way mirroring and file striping.

  D、When a file is created in DGROUP1 with the template， it would have three­way mirroring and file striping.

  E、When a file is created in DGROUP1 with the template， it would have two­way mirroring but no file striping.

  查看答案