You execute the following command to perform a backup by usi

题目
单选题
You execute the following command to perform a backup by using Recovery Manager (RMAN): RMAN> run  {allocate channel c1 type sbt;  backup datafile 1;  }  The command errors out. A part of the error message is as follows:  RMAN/x7f03009: failure of allocate command on c1 channel  ORA/x7f19554: error allocating device, device type: SBT_TAPE, device name:  What could explain why the statement failed?()
A

sbt is not a valid device type.

B

Media Management Library was not loaded.

C

The sbt device cannot be used for data file backups.

D

No path was defined in the ALLOCATE CHANNEL command.

E

The channel is currently being used by another RMAN session.

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

第1题:

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

第2题:

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

第3题:

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?()

A. Restore the backup control file and open the database with RESETLOGS option.

B. Perform point-in-time recovery because flashback cannot be performed again on this table

C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571


参考答案:D

第4题:

You execute the following command to start an Automatic Storage Management (ASM) instance:   SQL>STARTUP;   In which of the following modes will the ASM instance start?()

  • A、 OPEN
  • B、 MOUNT
  • C、 NORMAL
  • D、 NOMOUNT

正确答案:B

第5题:

You plan to execute the following command to perform a Flashback Database operation in your database:   SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);   Which two statements are true about this?()

  • A、 The database must have multiplexed redo log files
  • B、 The database must be in the MOUNT state to execute the command
  • C、 The database must be in the NOMOUNT state to execute the command
  • D、 The database must be opened in RESTRICTED mode before this operation
  • E、 The database must be opened with the RESETLOGS option after the flashback operation

正确答案:B,E

第6题:

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?()

  • A、The backup is deleted.
  • B、The backup is marked unavailable.
  • C、The backup overrides the backup retention policy.
  • D、the backup becomes eligible for deletion according to the existing retention policy

正确答案:D

第7题:

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

第8题:

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

第9题:

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()

  • A、 when you change the name of a datafile
  • B、 when you drop a table from the database
  • C、 when you take an export of the database
  • D、 when you back up the database using OS utilities
  • E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
  • F、 when you issue a BACKUP command from inside the RMAN run block

正确答案:A,E,F

第10题:

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

更多相关问题