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 want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze?()
ATop SQL
Bsnapshots
CSQL Tuning sets
Dindex access path
Eoptimizer statistics
Fmaterialized view logs
-
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed?()
ADrop and re-create the inbox.
BCoalesce the ORDERS_IND index.
CCoalesce the INDEXES tablespace.
DDrop and re-create the ORDERS table.
ERebuild the index online and move it to another tablespace.
-
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 readonly tablespace and recreate the tablespace after recovery
B、take data files from the readonly 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 issued the following statement in your SQL*Plus session: SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600; Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
B、 executing a long query that involves a sort operation and the statement runs out of temporary space
C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error
-
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()
A、 VERSIONS_STARTSCN
B、 VERSIONS_STARTTIME
C、 VERSIONS_XID
D、 VERSIONS_OPERATION