niusouti.com

单选题Which step is required for recover from an instance failure？ （）A Start up only.B Restore needed data files， then start up.C Complete restore from backup， then start up.D Perform point in time recovery， then start up.

题目
单选题
Which step is required for recover from an instance failure？ （）
A

Start up only.

B

Restore needed data files， then start up.

C

Complete restore from backup， then start up.

D

Perform point in time recovery， then start up.

相似考题

1.You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

2.Which of the following locations contains the System Restore option in Windows XP？（）A、Control Panel Administrative tools.B、Control Panel Security Center.C、System Properties， Start up and Recovery.D、Help and support from the Start menu.

3.In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）A、 import the database from the last exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery

4.A user reports that every time they start up their computer it stops with a bluescreen error. Whichof the following methods will give an alternate method of trying to start up a Windows computer?（）A、Press the F4 key during start up.B、Hold down the left Shift key during start up.C、Press the F2 key during start up.D、Press the F8 key during start up.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题Which step is required for recover from an instance failure？ （）A Start up only.B Restore needed data files， then start up.C Complete restore from backup， then start up.D Perform point in time recovery， then start up.”相关问题

  • 第1题：

    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

    • A、recovery cannot be performed because a backup was not performed after the last incomplete recovery
    • B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
    • C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
    • D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

    正确答案:B

  • 第2题：

    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

    • A、recover using Oracle Flashback Database technology
    • B、restore the data files from backup and perform a complete recovery
    • C、restore only the corrupted data file and perform tablespace recovery
    • D、restore the data files from backup and perform cancel-based recovery
    • E、restore the entire database from the most recent backup and start the instance and open the database

    正确答案:E

  • 第3题：

    Which step is required for recover from an instance failure？ （）

    • A、Start up only.
    • B、Restore needed data files， then start up.
    • C、Complete restore from backup， then start up.
    • D、Perform point in time recovery， then start up.

    正确答案:A

  • 第4题：

    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

    • A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
    • B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
    • C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
    • D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

    正确答案:D

  • 第5题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）

    • A、 restore the tablespace from the backup； there is no need to apply the redo information
    • B、 restore the full database to recover the data up to the point when you performed the backup
    • C、 restore the tablespace from the backup and then perform a recovery using the backup control file
    • D、 restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第6题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第7题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）
    A

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.

    B

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    C

     Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.

    D

     Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available.What would you do in this scenario？（）
    A

     recovery cannot be performed because a backup was not performed after the last incomplete recovery

    B

     restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday

    C

     restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

    D

     restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You lost the PRODSTD tablespace， which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup； there is no need to apply the redo information

    B

     restore the full database to recover the data up to the point when you performed the backup

    C

     restore the tablespace from the backup and then perform a recovery using the backup control file

    D

     restore the tablespace from the backup and then recover the tablespace； all the redo information from the point when the tablespace was made read/write is applied


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）
    A

     Restore the latest whole backup，perform complete recovery，and open the database normally 

    B

     Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.

    C

     Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.

    D

     Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）
    A

     import the database from the last export

    B

     restore all the members in the group from the last backup

    C

     drop the lost member from the database and then add a new member to the group

    D

     restore all the database files from the backup and then perform a complete recovery

    E

     restore all the database files from the backup and then perform an incomplete recovery


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

    • A、 Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
    • B、 Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
    • C、 Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
    • D、 Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

    正确答案:B

  • 第14题：

    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

    • A、Restore the data file and perform incomplete recovery.
    • B、Restore the data file and perform point-in-time recover.
    • C、Drop the tablespace and lose all data in the tablespace.
    • D、Restore the database and lose all data since the last backup.

    正确答案:C,D

  • 第15题：

    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：       RMAN>BACKUP 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 DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第16题：

    You lost the PRODSTD tablespace， which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace？（）

    • A、restore the tablespace from the backup; there is no need to apply the redo information 
    • B、restore the full database to recover the data up to the point when you performed the backup 
    • C、restore the tablespace from the backup， and then perform a recovery using the backup control file
    • D、restore the tablespace from the backup， and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

    正确答案:D

  • 第17题：

    In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

    • A、import the database from the last export
    • B、restore all the members in the group from the last backup
    • C、drop the lost member from the database， and then add a new member to the group
    • D、restore all the database files from the backup， and then perform a complete recovery 
    • E、restore all the database files from the backup， and then perform an incomplete recovery

    正确答案:C

  • 第18题：

    You have a computer that runs Windows 7. You have a system image backup of the computer. You install anew application that is configured to run as a service. You restart the computer and  receive a STOP errormessage. You need to successfully start Windows 7 in the minimum amount of time. What should you do?（　）

    • A、Start the computer from the Windows 7 installation media and select Startup Repair.
    • B、Start the computer and select Last Known Good Configuration from the advanced startup options.
    • C、Start the computer and select Safe Mode from the advanced startup options. Restore a restore point.
    • D、Start the computer and select Safe Mode from the advanced startup options. Restore the system image.

    正确答案:B

  • 第19题：

    单选题
    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：       RMAN>BACKUP 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 DBID

    D

     Issue the RECOVER DATABASE command.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel­based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    Which of the following locations contains the System Restore option in Windows XP？（）
    A

    Control Panel Administrative tools.

    B

    Control Panel Security Center.

    C

    System Properties， Start up and Recovery.

    D

    Help and support from the Start menu.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup， and then perform an incomplete recovery

    B

     restore the tablespace from the backup， and then apply all the redo information

    C

     restore all the data files in the database， and then perform an incomplete recovery

    D

     restore the tablespace from the backup


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）
    A

     Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.

    B

     Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.

    C

     Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.

    D

     Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    Which step is required for recover from an instance failure？ （）
    A

    Start up only.

    B

    Restore needed data files， then start up.

    C

    Complete restore from backup， then start up.

    D

    Perform point in time recovery， then start up.


    正确答案： B
    解析： 暂无解析

相关内容