CMS专题

单选题You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could b

题目
单选题
You executed the following command to perform a backup of the USERS tablespace:SQL> ALTER TABLESPACE users BEGIN BACKUP;ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error()
A

The MTTR Advisor is disabled.

B

The database is in NOARCHIVELOG mode.

C

The tablespace is already in backup mode.

D

The Flash Recovery Area is not configured

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

第1题:

You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:RMAN> REPORT NEED BACKUP days 3;What would be the output of this command?()

  • A、 a list of files that require a backup within three days
  • B、 a list of files that have not been backed up for three days
  • C、 a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
  • D、 a list of files for which a backup has already been performed and may need a backup after three days

正确答案:B

第2题:

Which command is used to configure RMAN to perform a compressed backup for every backup executed?()

  • A、 BACKUP AS COMPRESSED BACKUPSET DATABASE
  • B、 BACKUP AS COMPRESSED COPY OF DATABASE
  • C、 CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
  • D、 CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS 
  • E、 BACKUP DATABASE COMPRESS

正确答案:C

第3题:

View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()

A. 4

B. 8

C. 7

D. 0


参考答案:A

第4题:

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()

  • A、You should perform a log switch
  • B、You should make a backup of the database
  • C、You should switch the database to the NONARCHIVELOG mode
  • D、You should shut down the database instance and perform a complete database recovery

正确答案:B

第5题:

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)

  • A、The backup piece size will be limited to 300 MB
  • B、The RMAN uses multiplexing to perform backup
  • C、The operation is accomplished using the default channel available
  • D、The RMAN parallelizes the backup although the parallelism is not set for a channel

正确答案:A,C

第6题:

You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:  RMAN> BACKUP TABLESPACE DETTBS;  Under which conditions would this command execute successfully? ()

  • A、The database is in NOMOUNT state.
  • B、The database is in ARCHIVELOG mode and the tablespace is online.
  • C、The database is in ARCHIVELOG mode and the tablespace is offline.
  • D、The database is in NOARCHIVELOG mode and the tablespace is online.
  • E、The database is in NOARCHIVELOG mode and the tablespace is offline.

正确答案:B,C,E

第7题:

You executed the following command to back up the control file: ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What do you find in the trace file?()

  • A、Image of the control file
  • B、Location of the control file
  • C、Contents of the control file in text format
  • D、SQL command to re-create the database
  • E、SQL command to re-create the control file
  • F、Contents of the control file in binary format

正确答案:E

第8题:

You executed the following command to perform a backup of the USERS tablespace:  SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP *  ERROR at line 1:  ORA-01123: cannot start online backup; media recovery not enabled  What could be the reason for this error()

  • A、The MTTR Advisor is disabled.
  • B、The database is in NOARCHIVELOG mode.
  • C、The tablespace is already in backup mode.
  • D、The Flash Recovery Area is not configured.

正确答案:B

第9题:

You executed the following command to back up your control file:  ALTER DATABASE BACKUP CONTROLFILE TO TRACE;  Which initialization parameter is used to specify the location of the trace file?()

  • A、USER_DUMP_DEST
  • B、CORE_DUMP_DEST
  • C、TRACE_DUMP_DEST
  • D、BACKUP_DUMP_DEST
  • E、BACKGROUND_DUMP_DEST

正确答案:A

第10题:

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; }   What is the multiplexing level in the preceding backup process?()

  • A、 4
  • B、 8
  • C、 7
  • D、 0

正确答案:A

更多相关问题