多选题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.()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 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 database
B
To restrict the amount of space that is used by the backups
C
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.
参考解析
解析:
暂无解析
相关考题:
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 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.
Where do you find information about a missing redo log file?()A、trace fileB、audit trailC、control fileD、alert log fileE、event viewer
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?() a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database. A、a, b, f, gB、c, f, gC、a, d, f, gD、a, f, gE、a, e, g
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.
In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days
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 metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()A、 ZeroB、 One or moreC、 NONED、 DEFAULT
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
You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()A、 by using the STATUS command of the Listener control utilityB、 by using the STATUS L1 command of the Listener control utilityC、 by using the SHOW RULES command of the Listener control utilityD、 by using the SET PASSWORD command of the Listener control utilityE、 by searching for the PASSWORD_LISTENER entry in the listener.ora file
You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file
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 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
You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement: SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400; What is the outcome of this statement? ()A、 The statement will not execute successfully.B、 The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC、 The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D、 Backups will be deleted from the media after 400 days.
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
单选题In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A to configure RMAN to maintain backup information in the RMAN repository for seven daysB to configure RMAN to maintain backup information in the control file for at least seven daysC to display the list of files that have not been backed up for the last seven daysD to display the list of files that must be backed up within seven days
单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()AStart the instance and open the database, instance recovery automatically recovers control files BCreate a file based on the contents of the trace file and save it to the control file locations and start the database CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task?()Aby using the STATUS command of the Listener control utilityBby using the STATUS L1 command of the Listener control utilityCby using the SHOW RULES command of the Listener control utilityDby using the SET PASSWORD command of the Listener control utilityEby searching for the PASSWORD_LISTENER entry in the listener.ora file
单选题You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement: SQLALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400; What is the outcome of this statement? ()A The statement will not execute successfully.B The statement will execute successfully, and the backups metadata will be maintained in the control file for 400 daysC The statement will execute successfully, and the backups metadata will be maintained in the recovery catalog for 400 days.D Backups will be deleted from the media after 400 days.
单选题ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?()AIssue ALTER DATABASE BACKUP CONTROLFILE TO filenameBMake a copy of the control file with the database shut downCIssue ALTER DATABASE BACKUP CONTROLFILE TO traceDMake a copy of the control file with the database still running
单选题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
单选题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 work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()AStart the instance and open the database, instance recovery automatically recoverscontrol filesBCreate a file based on the contents of the trace file and save it to the control file locations and start the databaseCRe-create the database (The recovery of the control file is not possible because you have lost all the control files.)DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.EStart the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused, and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter?()A ZeroB One or moreC NONED DEFAULT
多选题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.
单选题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.ALISTBSWITCHCVALIDATEDCONFIGUREERESYNC CATALOGFUPGRADE CATALOG
单选题Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()AV$BACKUPSETBRC_DATABASECV$BACKUP_SETDRC_BACKUP_SET