单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）Arecover lost blocksBrecover corrupt blocksCrecover media corrupt blocks from listDrecover corrupt block

题目
单选题
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
A

 recover lost blocks

B

 recover corrupt blocks

C

 recover media corrupt blocks from list

D

 recover corrupt blocks from list

E

 recover corruption list

相似考题

1.When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）A、Until SCNB、Until timeC、Until cancelD、Recover using backup control file.

2.Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

3.You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

4. You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. A、a， b， f， gB、c， f， gC、a， d， f， gD、a， f， gE、a， e， g

更多“单选题If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A  recover lost blocksB  recover corrupt blocksC  recover media corrupt blocks from listD  recover corru”相关问题

  • 第1题：

    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

    • A、Restore and recover the datafile. 
    • B、Restore and recover the tablespace. 
    • C、Restore and recover the database. 
    • D、Restore and recover the control file. 
    • E、Restore and recover the parameter file.

    正确答案:A

  • 第2题：

    In which case would you use the Flashback Database feature to perform a recovery？（）

    • A、to recover a dropped tablespace
    • B、to recover data from a truncated table
    • C、to recover a data file that has been shrunk
    • D、to recover a database to the state that existed before the RESETLOGS operation

    正确答案:B

  • 第3题：

    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）  

    • A、 RECOVER FILE=1201 BLOCK=1968
    • B、 RECOVER CORRUPTION LIST
    • C、 RECOVER DATAFILE 1201 BLOCK 1968
    • D、 RECOVER BLOCK CORRUPTION LIST
    • E、 None of the above

    正确答案:B,C

  • 第4题：

    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.

    正确答案:D

  • 第5题：

    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

    • A、 recover lost blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第6题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）
    A

    Restore and recover the datafile. 

    B

    Restore and recover the tablespace. 

    C

    Restore and recover the database. 

    D

    Restore and recover the control file. 

    E

    Restore and recover the parameter file.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    You execute the following RMAN commands 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


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）
    A

     Restore and recover the datafile.

    B

     Restore and recover the tablespace.

    C

     Restore and recover the database.

    D

     Restore and recover the control file.

    E

     Restore and recover the parameter file.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database.
    A

    a， b， f， g

    B

    c， f， g

    C

    a， d， f， g

    D

    a， f， g

    E

    a， e， g


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）
    A

     The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.

    B

     The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.

    C

     The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    D

     The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）
    A

    Until SCN

    B

    Until time

    C

    Until cancel

    D

    Recover using backup control file.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）
    A

     V$BACKUP_CORRUPTION

    B

     V$COPY_CORRUPTION

    C

     V$DATABASE_BLOCK_CORRUPTION

    D

     RC_BACKUP_CORRUPTION


    正确答案： B
    解析： 暂无解析

  • 第13题：

    Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as “stuck recovery”. Before Oracle9i， the  Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source， then all transactions that committed after the corrupt point in the redo steam would be lost.  Oracle9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database.  What are three other characteristics of Trial Recovery（）

    • A、Speeds up subsequent media recover actions.
    • B、Writes any uncorrupted block to disk during the test recovery.
    • C、Can be invoked by adding the TEST option to any RECOVER command.
    • D、Allows the Administrator to determine how many blocks are affected by corruption.
    • E、Marks blocks as corrupt in memory， allowing the test recover to proceed to completion.

    正确答案:A,D,E

  • 第14题：

    You execute the following RMAN commands 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

    正确答案:D

  • 第15题：

    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

    • A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
    • B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
    • C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
    • D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    正确答案:C

  • 第16题：

    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

    • A、Rebuild the index using the online option. 
    • B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
    • C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
    • D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

    正确答案:C

  • 第17题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt.  With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）
    A

    time­based recovery

    B

    log sequence recovery

    C

    cancel­based recovery

    D

    change­based recovery


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）
    A

    Rebuild the index using the online option. 

    B

    Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 

    C

    Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 

    D

    Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    In which case would you use the Flashback Database feature to perform a recovery？（）
    A

    to recover a dropped tablespace

    B

    to recover data from a truncated table

    C

    to recover a data file that has been shrunk

    D

    to recover a database to the state that existed before the RESETLOGS operation


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    You have lost datafiles 1 and 3 from your database，and the database has crashed.  In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline.  2. startup mount the database  3. Issue the alter database open command. 4. Restore the datafiles that were lost  5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online.  7. Recover the database with the recover database command.
    A

     2，1，3，4，5，6

    B

     2，4，5，3

    C

     4，7，3

    D

     2，4，7，3

    E

     2，7，3


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    Your database runs in NOARCHIVELOG mode， and is backed up every night using RMAN scripts. However， last night your assistant DBA performed a manual operating system backup， instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo？（）
    A

    You need to perform the restore and recover operations manually, because the backup was made manually. 

    B

    First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. 

    C

    First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. 

    D

    You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 


    正确答案： A
    解析： 暂无解析

相关内容