搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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

查看正确答案
更多“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？（）”相关的问题
第1题
[单选题] One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

A、LOST  B、INVALID  C、EXPIRED  D、DELETED  E、CORRUPT  F、UNKNOWN  H、OBSOLETE  

点击查看答案
第2题
[单选题] Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）

A、 Restore all the datafiles from the backup.  B、 Restore only the lost datafile from the backup.  C、 Restore all the datafiles for the lost tablespace from the backup.  D、 Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.  

点击查看答案
第3题
[单选题] At database startup， you discover that one of the disks containing an index tablespace has been lost due to a media failure. A backup of the lost index tablespace is not available. You have all the necessary scripts to recreate the indexes. You need to re-create the indexes in a new index tablespace. Which action must you perform before re-creating the indexes？（）

A、 Start the database in OPEN mode， and create a new index tablespace.  B、 Start the database in OPEN mode， and drop the lost index tablespace from the database.  C、Start the database in MOUNT mode， create a new index tablespace， and drop the lost index tablespace from the database.  D、 Start the database in MOUNT mode， drop the lost index tablespace from the database， open the database， and create a new index tablespace.  

点击查看答案
第4题
[单选题] When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

A、Until SCN  B、Until time  C、Until cancel  D、Recover using backup control file.  

点击查看答案
第5题
[] Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）

A、A.SMON would automatically restore the lost file.  B、B.You would need to restore the whole database from the last backup.  C、C.You would need to restore the file from the last full database backup.  D、D.You would need to use flashback technology to restore the lost redo log member.  E、E.You would need to use Recovery Manager （RMAN） to restore the lost redo log member.  F、F.You would need to restore the missing log file by copying one of the remaining files from the same group.  

点击查看答案
第6题
[多选题] You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）

A、 SQL scripts  B、 Recovery Manager （RMAN） script  C、 Data Pump  D、 SQL*Loader  E、 Flashback database  

点击查看答案
第7题
[] Which statement about recovering from the loss of a redo log group is true？（）  

A、A. If the lost redo log group is ACTIVE， you should first attempt to clear the log file.  B、B. If the lost redo log group is CURRENT， you must clear the log file.  C、C. If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.  D、D. If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.  

点击查看答案
第8题
[单选题] If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）

A、 TS_OBJECTS_TO_BE_DROPPED  B、 TS_PTTR_OBJECT_DROPPED  C、 TS_PITR_OBJECTS_TO_BE_DROPPED  D、 TS_OBJECTS_DROPPED  E、 TS_DROPPED_OBJECTS  

点击查看答案
第9题
[单选题] You work as a database administrator for Supportcenter.cn. 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？（）

A、Restore all the data files and open the database  B、Create the data file and perform tablespace recovery  C、No need to restore any file， just recover the database  D、Restore only the system data file and recover the database  E、Restore only lost date file and performtablespacerecovery  

点击查看答案
第10题
[单选题] As soon as you discover that you have lost an online redo log， if the database is still functioning， what should be your first action？（）  

A、 Shut down the database  B、 Clear the online redo log  C、 Back up the database  D、 Checkpoint the database  E、 Call Oracle support  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服