Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.
第1题:
Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?()
第2题:
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()
第3题:
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: SQL>ALTER DATABASE OPEN RESETLOGS; Which of the following options is true about using the RESETLOGS option?()
第4题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第5题:
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?()
第6题:
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?()
第7题:
Restore all the datafiles from the backup.
Restore only the lost datafile from the backup.
Restore all the datafiles for the lost tablespace from the backup.
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
第8题:
Restore all the data files and open the database
Create the data file and perform tablespace recovery
No need to restore any file, just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
第9题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online.
第10题:
The log sequence is reset to 0.
All the online redo logs are deleted.
All the archived redo logs from a previous incarnation become useless.
The full database backup taken from a previous incarnation can be used in future.
Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
第11题:
import the database from the last export
restore all the members in the group from the last backup
drop the lost member from the database, and then add a new member to the group
restore all the database files from the backup, and then perform a complete recovery
restore all the database files from the backup, and then perform an incomplete recovery
第12题:
13:00 on Tuesday.
15:00 on Tuesday.
Up until the last available archived redo log on Sunday.
To any point; all the redo should still be available in the online redo logs.
The database is not recoverable.
第13题:
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator ()(DBA)? (Choose Three)
第14题:
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?()
第15题:
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup. What would you do to recover the data file()
第16题:
Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database?()
第17题:
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible?()
第18题:
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.
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.
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.
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.
第19题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online
第20题:
Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th,and open the database.
Tell them that their request cannot be met with the current backup strategy.
Restore the 19ths backup, apply the online redo logs,and open the database.
Switch the database into ARCHIVELOG mode,restore the 19th’s backup,restore all archived redo logs,and recover the database to the 20th.
Use the recover database command to roll back the database from today to the 19th of the month.
第21题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online
第22题:
Restore the data file for the SYSTEM tablespace then open the database.
Restore all redo logs form last night's backup, then restart the database.
Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.
Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
第23题:
The instance aborts.
The database cannot be recovered.
The database can be recovered by restoring the control files from the backup.
The database remains opened and you have to shut it down with the ABORT option.
The database can be restored till the point of the last closed whole database backup.
第24题:
import the database from the last export
restore all the members in the group from the last backup
drop the lost member from the database and then add a new member to the group
restore all the database files from the backup and then perform a complete recovery
restore all the database files from the backup and then perform an incomplete recovery