单选题What is the proper procedure to recover a lost tempfile?（）ARestore the backup copy of the tempfile from the backup media. BRe-create the tempfile with the create tempfile command. CCopy an existing tempfile from another database. DRe-create the tempfile with the create tablespace command. ERe-create the tempfile with the alter tablespace command.
单选题
What is the proper procedure to recover a lost tempfile?（）
A
Restore the backup copy of the tempfile from the backup media.
B
Re-create the tempfile with the create tempfile command.
C
Copy an existing tempfile from another database.
D
Re-create the tempfile with the create tablespace command.
E
Re-create the tempfile with the alter tablespace command.
参考解析
解析：
暂无解析
相关考题：
What methods are available to recover lost control files？（） A、 Backup control file.B、 Emergency control file.C、 The create controlfile command.D、 The restore controlfile SQL*Plus command.E、 No backup is required. The database will re-create the control file when it is discovered to be lost.
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）A、A text copy of the control file.B、A binary copy of the control file.C、A file containing a SQL statement which will re-create the database.D、A file containing a SQL statement which will re-create the control file.
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database. A、a， b， f， gB、c， f， gC、a， d， f， gD、a， f， gE、a， e， g
The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner？（） A、 Allow the database to continue running，drop the TEMP tablespace，and then re-create it with new tempfilesB、 Shut down the database， restore and recover the tempfile from backup，and then open the database with RESETLOGSC、 Allow the database to continue running，take the TEMP tablespace offline，drop the missing tempfile，and then create a new tempfileD、 Allow the database to continue running，add a new tempfile to TEMP tablespace with a new name，and drop the tempfile that has been corrupted
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
What is the proper procedure to recover a lost tempfile？（） A、 Restore the backup copy of the tempfile from the backup media.B、 Re-create the tempfile with the create tempfile command.C、 Copy an existing tempfile from another database.D、 Re-create the tempfile with the create tablespace command.E、 Re-create the tempfile with the alter tablespace command.
If a backup is expired， which of the following is true？（） A、 It can never be used for a restore/recover operation.B、 Oracle will remove the backup set pieces from the flash recovery area.C、 The backup has been used at least once to restore and recover the database.D、 The backup is no longer valid because of a resetlogs operation.E、 The physical backup set pieces are missing from the media.
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically
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（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
What is the proper procedure to recover a lost tempfile?（）A、Restore the backup copy of the tempfile from the backup media. B、Re-create the tempfile with the create tempfile command. C、Copy an existing tempfile from another database. D、Re-create the tempfile with the create tablespace command. E、Re-create the tempfile with the alter tablespace command.
What is the purpose of the recover command？（） A、 Recover database datafiles from physical disk backup sets.B、 Recover required incremental backups from physical disk backup sets.C、 Recover required archived redo logs from physical disk backup sets.D、 Apply incremental backups to recover the database. E、 Apply archived redo logs to recover the database.
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 a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）A、 Restore the lost data file from the backup， and then flash back the database.B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
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， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）Aflash back the databaseBperform point-in-time recoveryCperform a full database recoveryDdrop and re-create the tablespaceEuse Recovery Manager （RMAN） to recover the database
单选题You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）AA text copy of the control file.BA binary copy of the control file.CA file containing a SQL statement which will re-create the database.DA file containing a SQL statement which will re-create the control file.
单选题You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A take data files from the read-only tablespace offline before performing a recoveryB recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC drop the read-only tablespace and re-create the tablespace after recoveryD perform a recovery； status of the tablespace in control file will be changed automatically
单选题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（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.
单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup. What would you do to recover the data file（）ATake the USERS tablespace offline and re-create the lost data file.BShut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.CShut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.DTake the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online
单选题What is the proper procedure to recover a lost tempfile？（）A Restore the backup copy of the tempfile from the backup media.B Re-create the tempfile with the create tempfile command.C Copy an existing tempfile from another database.D Re-create the tempfile with the create tablespace command.E Re-create the tempfile with the alter tablespace command.
多选题What methods are available to recover lost control files？（）ABackup control file.BEmergency control file.CThe create controlfile command.DThe restore controlfile SQL*Plus command.ENo backup is required. The database will re-create the control file when it is discovered to be lost.
单选题You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database.Aa， b， f， gBc， f， gCa， d， f， gDa， f， gEa， e， g
单选题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
单选题The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）AAllow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfilesBShut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGSCAllow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfileDAllow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.
单选题If a backup is expired， which of the following is true？（）A It can never be used for a restore/recover operation.B Oracle will remove the backup set pieces from the flash recovery area.C The backup has been used at least once to restore and recover the database.D The backup is no longer valid because of a resetlogs operation.E The physical backup set pieces are missing from the media.
单选题You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）A AB BC CD D