单选题Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHI

题目
单选题
Assume your situation can be described as follows: x A full backup taken using RMAN is available on disk.  x The current control files were NOT damaged and do not need to be restored.  x All data files are damaged or lost.  x The database is in NOARCHIVELOG mode.  Which RMAN command would be most appropriate to use in line 3 of the following RMAN command set to restore and fully recover your database?() 1. RMAN> STARTUP MOUNT  2. RMAN> RESTORE DATABASE;  3. RMAN> ()  4. RMAN> ALTER DATABASE OPEN;
A

RECOVER DATABASE;

B

SWITCH DATAFILE ALL;

C

RESTORE CONTROL FILE;

D

RECOVER DATABASE USING BACKUP CONTROL FILE;

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

第1题:

Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()

A. It contains data till the last backup

B. It contains all data from target database until the current time

C. It contains all data from only the committed transactions in the target database

D. It contains all data except that which is used by the transactions in the current online redo file of target database


参考答案:D

第2题:

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

第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 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 read­only tablespace and re­create the tablespace after recovery
  • B、take data files from the read­only 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

正确答案:B

第5题:

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

第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)?()

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

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario?()

  • A、The instance aborts.
  • B、The database cannot be recovered.
  • C、The database can be recovered by restoring the control files from the backup.
  • D、The database remains opened and you have to shut it down with the ABORT option.
  • E、The database can be restored till the point of the last closed whole database backup.

正确答案:A,E

第8题:

Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()

A. only the control file, the current SPFILE, and data files

B. only the current SPFILE and data files if autobackup is disabled

C. only the data files and the archived redo logs

D. the control file, current SPFILE file, data files, and archived redo logs


参考答案:D

第9题:

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2;  Which components are included in the backup?()

  • A、Only the data files.
  • B、Only the data files and the online logs.
  • C、The data files, control files, and the online logs.
  • D、The data files and control files, but not the online logs.

正确答案:D

第10题:

You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()

  • A、Database Datafiles 
  • B、Database Control Files 
  • C、Online redo logs
  • D、Archived redo logs 
  • E、The database SPFILE 
  • F、None of the above, all these files are backed up. 

正确答案:C

更多相关问题