For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）

相似题目

• For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）

  A .  RMAN image copies. B .  RMAN database backups. C .  RMAN tablespace backups. D .  User-managed backups placed in the flash recovery area. E .  User-managed backups that have been cataloged with RMAN. F .  User-managed data file backups for which the pull path name is specified.

  查看最佳答案

• You are performing an incomplete recovery because certain important tables were deleted and purged from the Recycle Bin. In which mode will you perform the recovery？（）

  A .  MOUNT mode B .  RESTRICTED mode C .  OPEN mode D .  NOMOUNT mode

  查看最佳答案

• You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

  A .  A user table was lost at the specified time. B .  A redo log file was lost at the specified time. C .  The backup control file is on a faster disk than the current one. D .  The current control file has a different path compared with the intended time of recovery. E .  The current control file does not match the physical structure of the database at the intended time of recovery.

  查看最佳答案

• When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）

  A . Thread number. B . Log Sequence number. C . Control file sequence number. D . Name of the last archived log.

  查看最佳答案

• You performed an incomplete recovery on your Oracle Database 10g database using the following command：  SQL> RECOVER DATABASE  2 UNTIL TIME ’2004­08­05：12：10：03’  3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required？（）

  A . A user table was lost at the specified time. B . A redo log file was lost at the specified time. C . The backup control file is on a faster disk than the current one. D . The current control file has a different path compared with the intended time of recovery. E . The current control file does not match the physical structure of the database at the intended time of recovery.

  查看最佳答案

• 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 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 maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  A .  The target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

  查看最佳答案

• 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 option B .  open the database with the RESETLOGS option C .  recover to the required SCN only that data file in which the error occurred D .  recover all the data files to the same system change number （SCN）

  查看最佳答案

• You took the DATA1 tablespace offline at 10：00 A.M. At 12：30 P.M.， a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2：00 P.M. and decided to perform an incomplete recovery.  Which datafiles will you recover？（）

  A .  all the datafiles in the database B .  the datafiles associated with the SYSTEM tablespace C .  the datafiles associated with the DATA1 tablespace D .  all the datafiles in the database except those associated with the DATA1 tablespace

  查看最佳答案

• Which command is used to open the database after an incomplete recovery？（）

  A .  alter database open B .  alter database open repairlog C .  alter database open resetlogs D .  alter database open resetlog E .  alter database resetlogs ope

  查看最佳答案

• In which scenario will you perform an incomplete recovery？（）

  A .  when a table is dropped and stored in the Recycle Bin B .  when all the control files are deleted C .  when a member of a multiplexed redo log group is dropped D .  when you are required to recover a table to its previous state

  查看最佳答案

• An RMAN backup job fails， displaying the following error message：  ORA­19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）

  A . increase the value of UNDO_RETENTION B . change the value of WORKAREA_SIZE_POLICY to AUTO C . increase the value of DB_RECOVERY_FILE_DEST_SIZE D . increase the value of CONTROL_FILE_RECORD_KEEP_TIME

  查看最佳答案

• You are using Recovery wizard for performing incomplete recovery. Which of the following object types is NOT available in the Perform Recovery ：Type screen？（）

  A .  Whole database B .  Tablespaces C .  Datafiles D .  Archive logs E .  Redo log

  查看最佳答案

• An RMAN backup job fails， displaying the following error：  ORA­19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）

  A . take the backup of the flash recovery area less frequently B . increase the value of the UNDO_RETENTION initialization parameter C . change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO D . change the backup retention policy to retain the backups for a smaller period of time  E . increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter F . increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

  查看最佳答案

• In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

  A .  when all the online redo log groups are multiplexed and one of the members of a group is missing B .  when all the online redo log groups are not multiplexed and one log group is missing C .  when all the control files are missing D .  when some important tables are deleted from the database and purged from the Recycle Bi

  查看最佳答案

• You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

  A .  NOMOUNT B .  MOUNT C .  OPEN D .  RESTRICTED

  查看最佳答案

• When performing an incomplete recovery of the whole database， what must be true about the data files that are restored？（）https://assets.asklib.com/images/image2/201808011106595682.jpg

  A . A B . B C . C D . D

  查看最佳答案

• In which three situations is incomplete recovery required？（）

  A . After a shutdown abort. B . When recovering to an SCN. C . When recovering until a specific time. D . When a required archived log is missing.

  查看最佳答案

• 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 option B . open the database with the RESTRICTED option C . 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

  查看最佳答案

• 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.

  查看最佳答案

• A customer has a requirement for Disaster Recovery for compliance within their industry. Theyhave an RPO of 4 hours and an RTO of 24 hours. Cost is a consideration. What is the most costeffective DR implementation？（）

  A . a disk-to-disk backup solution keeping all storage in the data center B . a backup solution that includes magnetic tape that is shipped to an off-site storage facility C . a less powerful copy environment at a hot site with asynchronous mirroring and cluster technology D . an exact copy of the primary environment at a hot site with remote mirroring and cluster technology

  查看最佳答案

• You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）

  A .  UNTIL CANCEL B .  UNTIL SCN C .  UNTIL SEQUENCE D .  UNTIL TIME

  查看最佳答案

• According to Bakhtin,_____is the only into an incomplete state.

  查看最佳答案