多选题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
多选题
The loss of which two types of files may require a recovery with the RESETLOGS option？（）
A
control files
B
password file
C
archived log files
D
system-critical data files for which all the redo entries are present
E
non-system-critical data files for which all the redo entries are present
参考解析
解析：
暂无解析
相关考题：
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?() A. Alert log fileB. Archived redo log filesC. Control file autobackupsD. Server Parameter file (SPFILE)E. Recovery Manager (RMAN) backup piece
Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? () A. failures because a data file is renamed by errorB. failures when no standby database is configuredC. failures that require no archive logs to be applied for recoveryD. failures due to loss of connectivity-for example, an unplugged disk cable
Identify two situations in which you can use Data Recovery Advisor for recovery. ()(Choose two.) A. The user has dropped an important table that needs to be recovered.B. The database files are corrupted when the database is open.C. You are not able to start up the database instance because the required database files are missing.D. The archived log files are missing for which backup is not available.
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 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 daysB、 a list of files that have not been backed up for three daysC、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatilityD、 a list of files for which a backup has already been performed and may need a backup after three days
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
For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）A、RMAN image copiesB、RMAN database backupsC、RMAN tablespace backupsD、usermanaged backups placed in the flash recovery areaE、usermanaged backups that have been cataloged with RMANF、usermanaged data file backups for which the full path name is specified
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
Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？（）A、 The database writer writes to a trace file， indicating that the temporary file is not found.B、 The database prompts for a database recovery.C、 The database opens normally.D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.
Which two are characteristics of user-managed backup and recovery operations？（）A、Recovery is initiated using SQL*Plus.B、Database files are backed up using SQL commands.C、Database files are backed up with Recovery Manager.D、Database files are restored using Recovery Manager.E、Database files are backed up using operating system commands.
Identify two situations in which you can use Data Recovery Advisor for recovery.（） A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)A、Alert log fileB、Archived redo log filesC、Control file autobackupsD、Server Parameter file (SPFILE)E、Recovery Manager (RMAN) backup piece
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）A、Alert log fileB、Archived redo log filesC、Control file autobackupsD、Server Parameter file (SPFILE)E、Recovery Manager (RMAN) backup piece
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
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)A、Creating the control file for the duplicate databaseB、Restoring the target data files to the duplicate databaseC、Performing complete recovery using all available backupsD、Generating a new, unique DBID for the duplicate databaseE、Copying the online redo log files from the target database to the duplicate database
Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)A、The user has dropped an important table that needs to be recovered.B、The database files are corrupted when the database is open.C、You are not able to start up the database instance because the required database files are missing.D、The archived log files are missing for which backup is not available.
多选题Identify two situations in which you can use Data Recovery Advisor for recovery.（）AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
多选题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
多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for recoveryDfailures due to loss of connectivity-for example, an unplugged disk cable
多选题Which two operations require undo data？（）Acommitting a transactionBrolling back a transactionCrecovering from failed transactionsDrecording a transaction to redo log filesErolling forward during instance recovery
多选题Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database instance because the required database files are missing.DThe archived log files are missing for which backup is not available.
多选题Which two are characteristics of user-managed backup and recovery operations？（）ARecovery is initiated using SQL*Plus.BDatabase files are backed up using SQL commands.CDatabase files are backed up with Recovery Manager.DDatabase files are restored using Recovery Manager.EDatabase files are backed up using operating system commands.
多选题For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）ARMAN image copiesBRMAN database backupsCRMAN tablespace backupsDusermanaged backups placed in the flash recovery areaEusermanaged backups that have been cataloged with RMANFusermanaged data file backups for which the full path name is specified
多选题Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)ACreating the control file for the duplicate databaseBRestoring the target data files to the duplicate databaseCPerforming complete recovery using all available backupsDGenerating a new, unique DBID for the duplicate databaseECopying the online redo log files from the target database to the duplicate database
单选题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
多选题Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（）AAlert log fileBArchived redo log filesCControl file autobackupsDServer Parameter file (SPFILE)ERecovery Manager (RMAN) backup piece
单选题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？（）Aa list of files that require a backup within three daysBa list of files that have not been backed up for three daysCa list of files that RMAN recommends be backed up only once in every three days， based on low volatilityDa list of files for which a backup has already been performed and may need a backup after three days