多选题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 co

题目
多选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You can control instance recover performance by setting parameters to define targets for()

  • A、The size of the redo buffer in SGA. 
  • B、The instance that will perform recovery in Real Application Cluster database. 
  • C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 
  • D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

正确答案:C

第2题:

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

第3题:

Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()

  • A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
  • B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
  • C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
  • D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

正确答案:A

第4题:

What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()

  • A、BMR lowers the mean time to recover (MTTR).
  • B、BMR supports point­in­time recovery of individual data blocks.
  • C、BMR enables you to use incremental backups for block recovery.
  • D、BMR enables recovery even when the database is not mounted or open.
  • E、BMR enables you to use proxy backups to perform block media recovery.
  • F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.

正确答案:A,F

第5题:

You have a read-only tablespace on read-only 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-only tablespace was read/write when the control file was backed up. What should you consider?()

  • A、 take data files from the read-only tablespace offline before performing a recovery
  • B、 recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
  • C、 drop the read-only tablespace and re-create the tablespace after recovery
  • D、 perform a recovery; status of the tablespace in control file will be changed automatically

正确答案:A

第6题:

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes?()

  • A、ONLINE
  • B、REVERSE
  • C、PARALLEL
  • D、COMPRESS
  • E、NOLOGGING
  • F、COMPUTE STATISTICS

正确答案:C,E

第7题:

Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday, you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday, you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning, you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table?()

  • A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
  • B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
  • C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
  • D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup, but the rows inserted on Tuesday need to be inserted again.

正确答案:C

第8题:

You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery :Type screen?()

  • A、 Whole database
  • B、 Tablespaces
  • C、 Datafiles
  • D、 Archive logs
  • E、 Redo logs

正确答案:E

第9题:

In the parameter file of your production database, the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery, you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files?()

  • A、the V$LOG view
  • B、the V$DBFILE view
  • C、the V$LOGFILE view
  • D、the V$INSTANCE_RECOVERY view
  • E、Oracle Enterprise Manager Database Control

正确答案:D,E

第10题:

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()

  • A、Open the database in NORMAL mode
  • B、Open the database in read-only mode
  • C、Open the database in RESTRICTED mode
  • D、Open the database with the RESETLOGS option

正确答案:D

更多相关问题