单选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： In what sequence would you use this process to perform the recovery？（）A7， 2， 3， 1， 4， 6， 5B7， 1， 3， 2， 6， 5， 4C2， 1， 7， 6， 3， 5， 4D2， 7， 3， 5， 1， 6， 4
单选题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： In what sequence would you use this process to perform the recovery？（）
A
7， 2， 3， 1， 4， 6， 5
B
7， 1， 3， 2， 6， 5， 4
C
2， 1， 7， 6， 3， 5， 4
D
2， 7， 3， 5， 1， 6， 4
参考解析
解析：
暂无解析
相关考题：
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： In what sequence would you use this process to perform the recovery？（）A、7， 2， 3， 1， 4， 6， 5B、7， 1， 3， 2， 6， 5， 4C、2， 1， 7， 6， 3， 5， 4D、2， 7， 3， 5， 1， 6， 4
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
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.
You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task.（）A、 Reregistering the target database in recovery catalogB、 Transporting the new tablespaces to the recovery catalog databaseC、 Syncronizing the recovery catalog with the target database control fileD、 Performing a fresh backup of the target database to include the new data files in the catalog 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
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A、 2， 7， 3， 5， 1， 6， 4B、 2， 1， 7， 6， 3， 5， 4C、 7， 1， 3， 2， 6， 5， 4D、 7， 2， 3， 1， 4， 6， 5
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 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 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 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？（）A、shut down and restart the instanceB、add new tempfiles to the temporary tablespaces after recoveryC、perform a media recovery and open the database with the RESETLOGS optionD、perform a media recovery and bring the database to NOARCHIVELOG mode
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.
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
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)A、Reregistering the target database in recovery catalogB、Transporting the new tablespaces to the recovery catalog databaseC、Syncronizing the recovery catalog with the target database control fileD、Performing a fresh backup of the target database to include the new data files in the catalog database
In the parameter file of your production database， the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager （RMAN）？（）A、 The backup would be retained on the media for 31 days.B、 The backup would be maintained in the recovery catalog for 31 days.C、 The backup metadata would be retained in the control file for 31 days.D、 The backup metadata would be maintained in the recovery catalog for 31 days.E、 Automatic backups of the control file will be retained in the flash recovery area for 31 days.
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
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
单选题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？（）ARMAN would use the current operating system location to place the backup.BRMAN would use the control file of the target database to maintain the backup.CRMAN would use the recovery catalog of the target database to maintain the backup.DRMAN would use the control file of the target database to maintain the backup metadata. ERMAN would use the recovery catalog of the target database to maintain the backup metadata.
单选题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.
单选题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？（）Acannot be used in RMANBby starting up the database againCby using the CATALOG command of RMANDby using the RECOVER CATALOG command in RMANEby re-creating the target control file to rebuild the RMAN repository
多选题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 file.BBy using the alert log file.CBy using the database IDDBy using the server parameter file.EBy using the V$CONTROLFILE view.FBy using the autobackup format configuration setting.
单选题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 your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A 2， 7， 3， 5， 1， 6， 4B 2， 1， 7， 6， 3， 5， 4C 7， 1， 3， 2， 6， 5， 4D 7， 2， 3， 1， 4， 6， 5
多选题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.
多选题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
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database