You realize that the control file is damaged in your product

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

参考答案和解析
正确答案: C
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()

  • A、Redo logs
  • B、Control file
  • C、The latest backup of only the damaged data file
  • D、The latest backup of all the data file in the USERS tablespace
  • E、Temporary files of temporary tablespace
  • F、Archive Logs since the latest backup to point of failure

正确答案:A,C,F

第2题:

Your database is running In ARCIIIVELOG mode. One of the data files, USBRDATAOI. DBF, in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?() 

  • A、 redo logs
  • B、 control file
  • C、 temporary files of temporary tablespace
  • D、 the latest backup of only the damaged data file
  • E、 the latest backup of all the data files In the USERS tablespace

正确答案:A,B,D

第3题:

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()

A. Redo logs

B. Control file

C. The latest backup of only the damaged data file

D. The latest backup of all the data file in the USERS tablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backup to point of failure


参考答案:A, C, F

第4题:

You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()

  • A、Datafiles
  • B、 Current control file
  • C、 Server parameter file (spfile)
  • D、 Password file

正确答案:D

第5题:

You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required.   Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter?()

  • A、 0
  • B、 1
  • C、 NONE
  • D、 DEFAULT

正确答案:A

第6题:

Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)

  • A、Redo logs
  • B、Control file
  • C、The latest backup of only the damaged data file
  • D、The latest backup of all the data file in the USERS tablespace
  • E、Temporary files of temporary tablespace
  • F、Archive Logs since the latest backup to point of failure

正确答案:A,C,F

第7题:

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()

  • A、 Zero
  • B、 One or more
  • C、 NONE
  • D、 DEFAULT

正确答案:B

第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题:

You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  

  • A、 You will need to open the database with the resetlogs command.
  • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
  • C、 You will use the resetlogs version of the create controlfile command.
  • D、 You will use the noresetlogs version of the create controlfile command.
  • E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

正确答案:D

更多相关问题