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

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

Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()

  • A、V$BACKUPSET
  • B、RC_DATABASE
  • C、V$BACKUP_SET
  • D、RC_BACKUP_SET

参考答案

更多 “Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()A、V$BACKUPSETB、RC_DATABASEC、V$BACKUP_SETD、RC_BACKUP_SET” 相关考题
考题 Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?() A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

考题 Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.) A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

考题 Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database.   RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’;   Which two statements are true regarding the backup created using this command?()A、 The copy of the datafile created is stored in the RMAN repository.B、 The copy of the datafile created can be viewed using the LIST BACKUP command.C、 The copy of the datafile created using this COPY command can be placed only on the disk.D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

考题 In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()A、a tablespace is taken offlineB、the database instance is restartedC、a new data file is added to an existing tablespaceD、a successful backup is recorded in the RMAN repositoryE、the RMAN connection is disconnected from the target database

考题 Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN).()A、 You can use RMAN stored scripts.B、 Recovery is faster if data is stored in catalog in addition to the control file.C、 You can store backup Information of all registered databases in one place.D、 Database backups are automatically deleted when they are older than the specified time period.

考题 You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.()A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

考题 Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()A、You need to perform the restore and recover operations manually, because the backup was made manually. B、First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C、First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D、You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information. 

考题 You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

考题 You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

考题 It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A、cannot be used in RMANB、by starting up the database againC、by using the CATALOG command of RMAND、by using the RECOVER CATALOG command in RMANE、by re-creating the target control file to rebuild the RMAN repository

考题 You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A、 When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B、 When a structural change is made to the database, then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D、 When a structural change is made to the database, then a backup of the alert log file will be performed.

考题 You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP;   How does RMAN find the control file autobackup?()A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.

考题 You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

考题 In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()A、 A tablespace is taken offline.B、 The database instance is restarted.C、 A new data file is added to an existing tablespace.D、 A successful backup is recorded in the RMAN repository.E、 The RMAN connection is disconnected from the target database.

考题 You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)A、You can use RMAN stored scriptsB、Recovery is faster if data is stored in catalog in addition to the control fileC、You can store backup information of all registered databases in one placeD、Database backups are automatically deleted when they are older than the specified time period

考题 Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()A、 You can use RMAN stored scriptsB、 Recovery is faster if data is stored in catalog in addition to the control fileC、 You can store backup information of all registered databases in one placeD、 Database backups are automatically deleted when they are older than the specified time period

考题 单选题It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?()A cannot be used in RMANB by starting up the database againC by using the CATALOG command of RMAND by using the RECOVER CATALOG command in RMANE by re-creating the target control file to rebuild the RMAN repository

考题 单选题RMAN automatically propagate information about the database structure, archived redo logs, backup sets, and data file copies into the recovery catalog from the target database’s control file. This information can also be propagated to the catalog manually by using the ()command.A LISTB SWITCHC VALIDATED CONFIGUREE RESYNC CATALOGF UPGRADE CATALOG

考题 单选题You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A  rman TARGET / NOCATALOGB  rman TARGET sys/passwordC  rman TARGET sys/password AS SYSDBAD  rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 多选题In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()AA tablespace is taken offline.BThe database instance is restarted.CA new data file is added to an existing tablespace.DA successful backup is recorded in the RMAN repository.EThe RMAN connection is disconnected from the target database.

考题 单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup?()A  online redo log filesB  alert log filesC  control fileD  datafiles associated with the SYSTEM tablespace

考题 单选题Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()A V$BACKUPSETB RC_DATABASEC V$BACKUP_SETD RC_BACKUP_SET

考题 多选题You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)ATo store the backup information of multiple databaseBTo restrict the amount of space that is used by the backupsCTo maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.DTo list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

考题 单选题You issued the following RMAN command:  RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;     What is NOT an impact of using the above command?()A  When a successful backup is recorded in the RMAN repository, then a backup of the current control file is performed.B  When a structural change is made to the database, then a backup of the current control file is performed.C  When a successful backup is performed in the RMAN repository, then a backup of the spfile is performed.D  When a structural change is made to the database, then a backup of the alert log file will be performed.

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

考题 单选题Your database runs in NOARCHIVELOG mode, and is backed up every night using RMAN scripts. However, last night your assistant DBA performed a manual operating system backup, instead of running the scripts. Today your database crashed and you now want to use the backups from last night. What do you need todo?()A You need to perform the restore and recover operations manually, because the backup was made manually. B First you need to resynchronize the catalog with the control file, and then you can use RMAN to recover the database. C First you need to add the backup to the catalog using the CATALOG command, and then you can use RMAN to recover the database. D You can just use RMAN and recover the database, because RMAN automatically updates the catalog with the backup information.