Examine the following scenario:   -Database is running in AR

题目
单选题
Examine the following scenario:   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure?()
A

 Restore the latest whole backup,perform complete recovery,and open the database normally 

B

 Restore the latest whole backup,perform incomplete recovery,and open the database with the  RESETLOGS option.

C

 Restore the latest backups control file,perform complete recovery,and open the database with the RESETLOGS option.

D

 Restore the latest backup control file,perform incomplete recovery using backup control file,and open the database with the RESETLOG option.

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

第1题:

Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?()

A. Implement RMAN multiplexing

B. Set the DEBUG ON in the RMAN script

C. Specify the command ID in the RMAN script

D. Use a tag with the RMAN BACKUP command


参考答案:C

第2题:

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

第3题:

Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()

A. Provide a password for the encryption

B. Set up an Oracle wallet for the encryption

C. No setup is required as it is a default encryption method

D. Both Oracle wallet and password must be set up for the encryption


参考答案:B

第4题:

Examine the following RMAN command:   RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;   Which prerequisite must be met before accomplishing the backup?()

  • A、 Provide a password for the encryption
  • B、 Set up an Oracle wallet for the encryption
  • C、 No setup is required as it is a default encryption method
  • D、 Both Oracle wallet and password must be set up for the encryption

正确答案:B

第5题:

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()

  • A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
  • B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
  • C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
  • D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

正确答案:B,D

第6题:

Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?()

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.


参考答案:B

第7题:

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?()

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


参考答案:B

第8题:

Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? ()

A. The data files of the read-only tablespaces in the target database are not duplicated

B. The read-only tablespaces in the target database are still defined in new the database

C. The read-only tablespaces in the target database are changed to online after duplication

D. The data files of the read-only tablespaces in the target database get duplicated

E. The read-only tablespaces in the target database are not defined in the new database


参考答案:A, B

第9题:

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:   RESTORE CONTROLFILE FROM AUTOBACKUP;   Which of the following statements is true?() 

  • A、 The command restores only the missing control file.
  • B、 The command restores all the control files.
  • C、 The command fails because the database is running.
  • D、 This is the correct way to address this problem.
  • E、 This is not the correct way to address this problem.

正确答案:C,E

第10题:

Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? ()(Choose two)

  • A、The data files of the read-only tablespaces in the target database are not duplicated
  • B、The read-only tablespaces in the target database are still defined in new the database
  • C、The read-only tablespaces in the target database are changed to online after duplication
  • D、The data files of the read-only tablespaces in the target database get duplicated
  • E、The read-only tablespaces in the target database are not defined in the new database

正确答案:A,B

更多相关问题