SYSTEM-Config中,Use hot start为TRUE、I/O Recovery为RECOVERY ALL,在机器人重启后恢复所有信号的状态。
SYSTEM-Config中,Use hot start为TRUE、I/O Recovery为RECOVERY ALL,在机器人重启后恢复所有信号的状态。
相关考题:
当端口由于违规操作而进入“err-disableb”状态后,使用什么命令手工将其恢复为UP状态?() A.errdisable recoveryB.no shutdownC.recovery reedisableD.recovery
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
YouareworkingasaDBAonOracleDatabase9i.Youplantoupgradeyour9idatabasetoOracle10g.Tobefamiliarwiththenewdatabasetechnology,youdecidetoinstallOracleDatabase10gonyourworkstationathome.Youcreateageneralpurposedatabase.Aftertheinstallation,youmakethefollowingchangesinyourinitializationparameterfile:LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’DB_RECOVERY_FILE_DEST=’LOCATION=d:\product\10.1.0\flash_recovery_area’DB_RECOVERY_FILE_DEST_SIZE=10gWherearethearchivedredologsstoredforyourdatabase?()
当端口由于违规操作而进入“err-disableb”状态后,使用什么命令手工将其恢复为UP状态?()A、errdisable recoveryB、no shutdownC、recovery reedisableD、recovery
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()A、The location can be changed only if the flash recovery area is empty.B、After executing the command, all new flash recovery area files will be created in the new location.C、The command will generate an error because you cannot change the flash recovery area while the database is open.D、All the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.
Which statement is true regarding the Archiver (ARCn) process,archived log files,and recovery? ()A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.
You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()A、On startup, SMON coordinates instance recovery.B、On startup, CKPT coordinates instance recovery.C、On startup, use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup, perform media recovery and then instance recovery.F、On startup, all the files will be synchronized and you get both committed and uncommitted data.
Which of the following is the BEST solution for repairing a hard drive that results in the Could not readfrom selected boot disk display upon booting? ()A、Use recovery console and the bootcfg /rebuild command.B、Use recovery console and the chkdsk command.C、Use recovery console and the fixboot command.D、Use recovery console and the fixmbr command.
Which of the following is the BEST solution for repairing a hard drive that results in the NTLDR ismissing display upon booting?()A、Use recovery console and the fixmbr command.B、Use recovery console and the bootcfg /rebuild command.C、Use recovery console and the fixboot command.D、Use recovery console and the chkdsk command.
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode
You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’; Which statement is true?()A、 The location can be changed only if the flash recovery area is empty.B、 After executing the command, all new flash recovery area files will be created in the new location.C、 The command will generate an error because you cannot change the flash recovery area while the database is open.D、 All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A、Perform Export before TSPITR and Import after TSPITRB、Move objects to another schema that has the same tablespace assignedC、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()A、BMR lowers the mean time to recover (MTTR).B、BMR supports pointintime recovery of individual data blocks.C、BMR enables you to use incremental backups for block recovery.D、BMR enables recovery even when the database is not mounted or open.E、BMR enables you to use proxy backups to perform block media recovery.F、BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
What is the purpose of the RMAN recovery catalog?() A、 It must be used because all RMAN-related backup and recovery metadata information is contained in it.B、 It provides a convenient, optional, repository of backup- and recovery-related metadata.C、 It provides the ability to store RMAN scripts for global use by any database that has access to the repository.D、 It provides a means of storing all RMAN backup sets physically in an Oracle database server. E、 It provides the ability to store backup records for more than a year.
What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()A、 BMR lowers the mean time to recover (MTTR).B、 BMR supports point-in-time recovery of individual data blocks.C、 BMR enables you to use incremental backups for block recovery.D、 BMR enables recovery even when the database is not mounted or open.E、 BMR enables you to use proxy backups to perform block media recovery.F、 BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.
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
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 install a Zip device on your Windows 2000 Professional computer. You reboot your computer only to find out that the computer does not respond at all. You reboot into Safe Mode, and again, the computer does not respond. How do you recover from this problem?()A、Use the listsvc command to disable the Zip device driverB、Select Recovery Console from the Recovery Menu.C、Use the disable command to disable the Zip device driverD、Select the Debug mode from the Windows 2000 Advanced Options menuE、Insert the Emergency Repair Disk and specify the path of the recovery file on the hard diskF、Start the computer using the Windows 2000 Professional CD-ROM.
You have an enterprise subordinate certification authority (CA) configured for key archival. Three key recovery agent certificates are issued. The CA is configured to use two recovery agents. You need to ensure that all of the recovery agent certificates can be used to recover all new private keys. What should you do()A、Add a data recovery agent to the Default Domain Policy.B、Modify the value in the Number of recovery agents to use box.C、Revoke the current key recovery agent certificates and issue three new key recovery agent certificates.D、Assign the Issue and Manage Certificates permission to users who have the key recovery agent certificates.
You are the Exchange administrator of the Xxx Corporation’s Exchange 2010 organization.You need to retrieve all messages from Ann’s mailbox that have the word "classified" in the message body and the subject of "New Project." The message may be either in the Calendar or Inbox folders. What should you do?()A、Use the Exchange Management Console to create a recovery storage groupB、Use the Exchange Management Shell to create a recovery storage groupC、Use the Exchange Management Console to create a recovery databaseD、Use the Exchange Management Shell to create a recovery databaseE、Use the Restore-Mailbox cmdlet to restore only messages that the word "classified" in the message body and the subject of "New Project"F、Use the Export-Message cmdlet to restore only messages that the word "classified" in the message body and the subject of "New Project"
单选题You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()AThe location can be changed only if the flash recovery area is empty.BAfter executing the command, all new flash recovery area files will be created in the new location.CThe command will generate an error because you cannot change the flash recovery area while the database is open.DAll the existing files in the flash recovery area will be moved to the new location, and all new Flash Recovery Area files will be created in the new location.
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery,you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
多选题You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()AOn startup, SMON coordinates instance recovery.BOn startup, CKPT coordinates instance recovery.COn startup, use RMAN to perform instance recovery.DUncommitted changes will be rolled back after the database is opened.EOn startup, perform media recovery and then instance recovery.FOn startup, all the files will be synchronized and you get both committed and uncommitted data.
单选题You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()A Enable the flash recovery area and specify it as the archived redo log destination.B Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C Enable the flash recovery area but do not specify it as the archived redo log destination. D Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.
单选题You decided to change the location of the flash recovery area. You executed the following command: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’; Which statement is true?()A The location can be changed only if the flash recovery area is empty.B After executing the command, all new flash recovery area files will be created in the new location.C The command will generate an error because you cannot change the flash recovery area while the database is open.D All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.
单选题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