违法和不良信息举报 联系客服
免费注册 登录

Because of a logical corruption in your production database,

题目
单选题
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
A

Perform Export before TSPITR and Import after TSPITR

B

Move objects to another schema that has the same tablespace assigned

C

Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

D

Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

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

第1题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database


参考答案：C, D

第2题：

When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）

  • A、The database has a subset of the tables in the production server database.
  • B、The database has a copy of selected data from the production database
  • C、The database logs changes for later propagation.
  • D、The database is accessed as read-only to prevent data corruption.
  • E、The database includes all user and order data for offline processing.

正确答案:B,C

第3题：

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:Which option illustrates the correct sequence that you must use?（）

A. 8, 1, 3, 2, 4, 5, 7, 6

B. 1, 8, 3, 4, 2, 5, 7, 6

C. 1, 3, 4, 2, 8, 5, 6, 7

D. 1, 3, 2, 4, 6, 5, 7, 8


参考答案：A

第4题：

A data file become 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？（）

  • A、 Flash back all the tables in the data file， one by one.
  • B、 Restore the data file to a new location and perform a media recovery.
  • C、 Flash back the database， there is no need to restore the data file.
  • D、 Restore the data file from the most recent backup and flash the database.

正确答案:B

第5题：

Which of the following are correct about block media recovery？（）

  • A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
  • B、 Logical corruptions are repairable by BMR
  • C、 Physical corruptions are repairable by BMR
  • D、 RMAN can use any backup for a BMR restore
  • E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

正确答案:A,C

第6题：

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

  • A、flash back all the tables in the data file， one by one
  • B、restore the data file to a new location and perform a media recovery
  • C、flash back the database; there is no need to restore the data file
  • D、restore the data file from the most recent backup and flash back the database

正确答案:B

第7题：

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

  • A、 The block change tracking feature must be enabled.
  • B、 OMF must be configured on your database.
  • C、 The database must be in ARCHIVELOG mode.
  • D、 A USERID must be supplied.

正确答案:D

第8题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option


参考答案：A

第9题：

You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

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

正确答案:A

第10题：

Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

  • A、mount the new disk group in the ASM instance
  • B、restart the ASM instance and the production database instance
  • C、register the new disk groups in the production database instance
  • D、restart the ASM instance without restarting the production database instance
  • E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

正确答案:A

更多相关问题
相关内容