You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A、loss of a tempfileB、loss of a system data fileC、loss of one of the control filesD、loss of one of the tablespacesE、loss of a member from each redo log groupF、loss of the only member of an unarchived redo log group
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）
- A、loss of a tempfile
- B、loss of a system data file
- C、loss of one of the control files
- D、loss of one of the tablespaces
- E、loss of a member from each redo log group
- F、loss of the only member of an unarchived redo log group
相关考题：
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 corrupted-The 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 normallyB. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:Which statement is true regarding what this command accomplishes?（）A. All archived redo log files backed up at least twice to tape are deleted.B. All archived redo log files backed up at least once to tape are eligible for deletion.C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? ()(Choose two) A. Control filesB. Password filesC. Inactive online redo log fileD. Archived log files required to perform recoveryE. Newly created tablespace which is not backed up
You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number （SCN）
The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 Control filesB、 Password filesC、 Inactive online redo log fileD、 Archived log files required to perform recoveryE、 Newly created tablespace which is not backed up
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）A、This operation resets the SCN for the database.B、This operation creates a new incarnation of the database.C、This operation moves all the redo log files to a different location.D、This operation deletes the old redo log files and creates new redo log files.E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）A、SYSDATE should not be used with TIMESTAMP.B、The database must have multiplexed redo log files.C、The database must be in the MOUNT state to execute the command.D、The database must be opened with the RESETLOGS option after the flashback operation.E、The entire database needs to be restored from the most recent backup before the flashback operation.
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 performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’. Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.
In which two cases would you perform only consistent backup？（）A、You are working on a database where downtime is not tolerated.B、You are working on a database where downtime can be tolerated.C、You are working on a database that operates in ARCHIVELOG mode.D、You are working on a database that operates in NOARCHIVELOG mode.E、You are working on a database where all the tablespaces are locally managed.F、You are working on a database where control files and redo log files are multiplexed.G、You are working on a database where control files and redo log files are not multiplexed.
You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）A、open the database with the RESETLOGS optionB、open the database with the RESTRICTED optionC、recover all the data files to the same system change number （SCN）D、recover to the required SCN only that data file in which the error occurred
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.
The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 control filesB、 password fileC、 archived log filesD、 system-critical data files for which all the redo entries are presentE、 non-system-critical data files for which all the redo entries are present
You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A、 loss of one of the tablespacesB、 loss of a system data fileC、 loss of one of the control filesD、 loss of a tempfileE、 loss of the only member of an unarchived redo log groupF、 loss of a member from each redo log group
多选题The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）AControl filesBPassword filesCInactive online redo log fileDArchived log files required to perform recoveryENewly created tablespace which is not backed up
多选题You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？ （）AThis operation resets the SCN for the database.BThis operation creates a new incarnation of the database.CThis operation moves all the redo log files to a different location.DThis operation deletes the old redo log files and creates new redo log files.EThis operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
单选题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 corrupted - The 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?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.CRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.DRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
单选题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 corrupted -The 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?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionCRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionDRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）Aloss of a tempfileBloss of a system data fileCloss of one of the control filesDloss of one of the tablespacesEloss of a member from each redo log groupFloss of the only member of an unarchived redo log group
多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all the redo entries are present
单选题You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）A loss of one of the tablespacesB loss of a system data fileC loss of one of the control filesD loss of a tempfileE loss of the only member of an unarchived redo log groupF loss of a member from each redo log group
多选题You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）ASYSDATE should not be used with TIMESTAMP.BThe database must have multiplexed redo log files.CThe database must be in the MOUNT state to execute the command.DThe database must be opened with the RESETLOGS option after the flashback operation.EThe entire database needs to be restored from the most recent backup before the flashback operation.
多选题You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The FlashRecovery Area is specified as the destination for the archived redo log files. You notice this warning in thealert log file： ORA-19815： WARNING:// db_recovery_file_dest_size of 3221225472 bytes is 100.00% used， and has 0remaining bytes available. What would you do to reclaim the used space in the Flash Recovery Area（）ABack up the Flash Recovery Area.BDecrease the retention time for the database backup and flashback log files.CManually delete all the archived log files from the Flash Recovery Area by using operating system （OS）commands.DManually delete all the expired backup sets from the Flash Recovery Area by using operating system（OS） commands.
多选题The database is configured in ARCHIVELOG mode and regular complete database backups are taken. Theloss of which two types of files may require a recovery with the RESETLOGS option? （）(Choose two)AControl filesBPassword filesCInactive online redo log fileDArchived log files required to perform recoveryENewly created tablespace which is not backed up