多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
多选题
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）
A
The command restores only the missing control file.
B
The command restores all the control files.
C
The command fails because the database is running.
D
This is the correct way to address this problem.
E
This is not the correct way to address this problem.
参考解析
解析：
暂无解析
相关考题：
Examine the following RMAN command:Which two statements are true regarding the backup taken by using the above RMAN command?() A. Only data files and the control file are backed up.B. Archived redo logs are backed up only I f the database is open during the backup.C. The backup is deleted after one day, regardless of the default retention policy settings.D. The backup becomes obsolete after one day, regardless of the default retention policy settings.
You issued the following RMAN command to back up the database:Which two statements are true regarding the backup performed?() A. Archived redo log files are backed up along with data files.B. Only data files are backed up and a restore point named FY06Q4 is created.C. Archived log files are backed up along with data files, and the archived log files are deleted.D. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）A. Data files that belong to only the root containerB. Data files that belong to the root container and all the pluggable databases (PDBs)C. Data files that belong to only the root container and PDB$SEEDD. Data files that belong to the root container and all the PDBs excluding PDB$SEED
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（） A、 The command restores only the missing control file.B、 The command restores all the control files.C、 The command fails because the database is running.D、 This is the correct way to address this problem.E、 This is not the correct way to address this problem.
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
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？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile
You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（） A、back up the control file to traceB、bring database to the MOUNT stateC、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
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
Examine the following RMAN command： BACKUP DATABASE TAG TESTDB KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06； Which two statements are true regarding the backup taken by using the above RMAN command？（） A、 Only data files and the control file are backed up.B、 Archived redo logs are backed up only if the database is open during the backup.C、 The backup is deleted after one day，regardless of the default retention policy settings. D、 The backup becomes obsolete after one day，regardless of the default retention policy settings.
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?（）A、Data files that belong to only the root containerB、Data files that belong to the root container and all the pluggable databases (PDBs)C、Data files that belong to only the root container and PDB$SEEDD、Data files that belong to the root container and all the PDBs excluding PDB$SEED
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.
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 are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
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 have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（） A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E、 Issue the restore spfile from autobackup command from the RMAN prompt.
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 fileB、by using the alert log fileC、by using the database IDD、by using the server parameter fileE、by using the V$CONTROLFILE viewF、by using the autobackup format configuration setting
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
单选题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
多选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE； Which two operations do you need to perform after restoring the control file from backup？（）Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode
多选题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
多选题Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）AThe command restores only the missing control file.BThe command restores all the control files.CThe command fails because the database is running.DThis is the correct way to address this problem.EThis is not the correct way to address this problem.
单选题You executed the following command in Recovery Manager （RMAN）： RMAN RESTORE CONTROLFILE； Which operation must you perform before this command is executed？（）A back up the control file to traceB bring database to the MOUNT stateC open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target databaseD set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
多选题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.
多选题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 offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database
多选题Examine the following RMAN command： BACKUP DATABASE TAG TESTDB KEEP UNTIL ’SYSDATE+1’ RESTORE POINT TESTDB06； Which two statements are true regarding the backup taken by using the above RMAN command？（）AOnly data files and the control file are backed up.BArchived redo logs are backed up only if the database is open during the backup.CThe backup is deleted after one day，regardless of the default retention policy settings.DThe backup becomes obsolete after one day，regardless of the default retention policy settings.
多选题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 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？（）Aby using the trace fileBby using the alert log fileCby using the database IDDby using the server parameter fileEby using the V$CONTROLFILE viewFby using the autobackup format configuration setting
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A You will need to open the database with the resetlogs command.B All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C You will use the resetlogs version of the create controlfile command.D You will use the noresetlogs version of the create controlfile command.E You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command