单选题Which step is required for recover from an instance failure？ （）AStart up only.BRestore needed data files， then start up.CComplete restore from backup， then start up.DPerform 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.
参考解析
解析：
暂无解析
相关考题：
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.
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.
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.
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
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 recoveryB、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 ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、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
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.
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 technologyB、restore the data files from backup and perform a complete recoveryC、restore only the corrupted data file and perform tablespace recoveryD、restore the data files from backup and perform cancel-based recoveryE、restore the entire database from the most recent backup and start the instance and open the database
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.
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.
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： RMANBACKUP 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 DBIDD、 Issue the RECOVER DATABASE command.
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.
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 fileD、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
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 informationB、 restore the full database to recover the data up to the point when you performed the backupC、 restore the tablespace from the backup and then perform a recovery using the backup control fileD、 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
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 recovery E、restore all the database files from the backup， and then perform an incomplete recovery
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.
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.
单选题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？（）AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut 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. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
单选题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： RMANBACKUP 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 DBIDD Issue the RECOVER DATABASE command.
单选题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.
单选题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？（）Arecover using Oracle Flashback Database technologyBrestore the data files from backup and perform a complete recoveryCrestore only the corrupted data file and perform tablespace recoveryDrestore the data files from backup and perform cancelbased recoveryErestore the entire database from the most recent backup and start the instance and open the database
单选题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 recoveryB restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayC 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 SundayD 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
单选题Which of the following locations contains the System Restore option in Windows XP？（）AControl Panel Administrative tools.BControl Panel Security Center.CSystem Properties， Start up and Recovery.DHelp and support from the Start menu.
单选题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 informationB restore the full database to recover the data up to the point when you performed the backupC restore the tablespace from the backup and then perform a recovery using the backup control fileD 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
单选题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 recoveryB restore the tablespace from the backup， and then apply all the redo informationC restore all the data files in the database， and then perform an incomplete recoveryD restore the tablespace from the backup
单选题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.
单选题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.
单选题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