网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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.

参考答案

更多 “ 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.” 相关考题
考题 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 MBB. The RMAN uses multiplexing to perform backupC. The operation is accomplished using the default channel availableD. The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 You issued the following commands to configure setting in RMAN;RMAN CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN CONFIGURE DEFAULT DEVICE TYPE TO sbt;RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;RMAN CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;Then you issued the following command to take the backup:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?()A. The backup will terminate because the FORMAT clause was not configured for the channelB. It backs up two copies of data files to tape and disk, and two copies of archived log file on tapeC. It backs up the data files and archived log files to disk, making two copies of each data file and archived log fileD. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

考题 You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly.  On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3.  Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()A、configure a default device for RMAN backupsB、temporarily disable the retention policy for RMAN backupsC、configure automatic channel allocation for RMAN backupsD、use the CONFIGURE command to reconfigure the recovery window to 60 days

考题 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 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 Examine the following RMAN script: RMAN run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()A、The data file is checked for physical corruption and backed up if found clean.B、The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C、The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D、The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

考题 You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE,Which statement is true of this command?()A、A different procedure is required to restore a database from compressed backups B、The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies. C、Using this command to create backups minimizes the bandwidth consumed.D、Using this command to create backups improves the performance of the backup process 

考题 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 datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

考题 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 the RMAN. To accomplish the backup, you issued the following RMAN command:   RMAN BACKUP SECTION SIZE 300M TABLESPACE users;   Which two statements are true regarding the execution of the above command?()A、 The RMAN parallelizes the backup although the parallelism is not set for a channel.B、 The backup piece size will be limited to 300 MB.C、 The operation is accomplished using the default channel available.D、 Three channels for the tape drive must be configured by setting the parallelism to three.

考题 You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the database files:  $ rman target /  What would be the effect of this command?()A、RMAN would use the current operating system location to place the backup.B、RMAN would use the control file of the target database to maintain the backup.C、RMAN would use the recovery catalog of the target database to maintain the backup.D、RMAN would use the control file of the target database to maintain the backup metadata. E、RMAN would use the recovery catalog of the target database to maintain the backup metadata.

考题 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 NOARCHIVELOG mode and the tablespace is online.C、 The database is in NOARCHIVELOG mode and the tablespace is offline.D、 The database is in ARCHIVELOG mode and the tablespace is offline.E、 The database is in ARCHIVELOG mode and the tablespace is online.

考题 You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this?()  A、 MAXSETSIZE TO 2B、 DEVICE TYPE DISK PARALLELISM 2C、 RETENTION POLICY TO REDUNDANCY 2D、 DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2

考题 You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB.  You issue the following command from the RMAN prompt to perform a backup of the tablespace:   RMAN BACKUP TABLESPACE TS1 MAXSETSIZE 100M;  Which statement is true about executing this command?()A、 The command generates an error.B、 The command backs up the tablespace and creates a backup set of size 200 MBC、 The command backs up the tablespace and creates two backup sets of size 100 MB each.D、 The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.

考题 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、 4B、 8C、 7D、 0

考题 In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN: RMAN CONFIGURE DEVICE TYPE disk PARALLELISM 2 BACKUP TYPE TO BACKUPSET; RMAN CONFIGURE CHANNEL 1 DEVICE TYPE disk FORMAT '/home/oracle/disk1/%U'; RMAN CONFIGURE CHANNEL 2 DEVICE TYPE disk FORMAT '/home/oracle/disk2/%U'; You issue the following RMAN command to backup the database: RMAN RUN 2 { 3 ALLOCATE CHANNEL ch1 DEVICE TYPE disk; 4 BACKUP DATABASE; 5 } Which statement is true about the outcome?()A、Only one channel is allocated and the backup is created in the flash recovery areaB、Only one channel is allocated and the backup is created in the destination specified for channel 1C、Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2D、Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

考题 Your database is in ARCHIVELOG mode. On Friday evening, you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager (RMAN) prompt and close the  database. On Monday, the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles, HR1.DBF and HR2.DBF, both of which belong to a read/write tablespace named HR. The disk also contains a datafile, USERS.DBF, which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database, you issue the following RMAN commands:        RMANRESTORE DATABASE;        RMANRECOVER DATABASE;   After successfully executing these RMAN commands, you issue the following statement using SQL*Plus:        SQLALTER DATABASE OPEN;   You receive the following errors when attempting to open the database:        ORA-01157: cannot identify/lock data file 10 see DBWR trace file        ORA-01110: data file 10: ’D:///USERS.DBF’   What is the cause of these errors?()A、 The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B、 The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C、 The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D、 The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

考题 You perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process

考题 You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A、 target databaseB、 auxiliary databaseC、 third-party databaseD、 recovery catalog database

考题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

考题 You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting?()A、 configure a default device for RMAN backupsB、 temporarily disable the retention policy for RMAN backupsC、 configure automatic channel allocation for RMAN backupsD、 use the CONFIGURE command to reconfigure the recovery window to 60 days

考题 多选题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? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

考题 单选题Examine the following RMAN script: RMAN run { debug on; allocate channel c1 type disk; backup datafile 5; } Which statement describes the purpose of the script?()A The data file is checked for physical corruption and backed up if found clean.B The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

考题 单选题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  4B  8C  7D  0

考题 单选题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.

考题 单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A The backup status will be marked expired in RMAN recovery catalog.B The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

考题 多选题Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt:     RMAN CONFIGURE CONTROLFILE AUTOBACKUP OFF;   RMAN BACKUP DATABASE;   Which files from the database will be backed up as a result of this BACKUP command?()Acontrol fileBall datafilesCpassword fileDonline redo log fileEarchive redo log fileFserver parameter fileGonly the SYSTEM datafile

考题 单选题You administer an Oracle Database 10g and a third-party database. You use Recovery Manager (RMAN) to perform backup and recovery operations. You have configured a recovery catalog to act as an RMAN repository. To which of the following databases can you NOT connect using the RMAN CONNECT command?()A  target databaseB  auxiliary databaseC  third-party databaseD  recovery catalog database

考题 单选题You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used.  What must you set using the RMAN CONFIGURE command to achieve this?()A  MAXSETSIZE TO 2B  DEVICE TYPE DISK PARALLELISM 2C  RETENTION POLICY TO REDUNDANCY 2D  DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2