单选题Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（）

题目

单选题

Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（） a. Shut down the database. b. Take the users_01.dbf datafile offline with the alter database command. c. Restore the users_01.dbf datafile from backup media with the required archived redo logs. d. Restore all users tablespace-related datafiles from backup media. e. Issue the recover tablespace users command. f. Issue the recover datafile users_01.dbf command. g. Start up the database. h. Bring the users_01.dbf datafile online with the alter database command.

a， c， f， g

b， c， f， h

a， b， c， f， g

a， b， c， f， g， h

b， c， f， e， g

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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

正确答案:F

第2题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

A、Restore and recover the datafile.
B、Restore and recover the tablespace.
C、Restore and recover the database.
D、Restore and recover the control file.
E、Restore and recover the parameter file.

正确答案:A

第3题：

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）1.Shut down the database.2.Take the users_01.dbf datafile offline with the alter database command.3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.4.Restore all users tablespace-related datafiles from backup media.5.Issue the recover tablespace users command.6.Issue the recover datafile users_01.dbf command.7.Start up the database.8.Bring the users_01.dbf datafile online with the alter database command.

A.1，3，6，7

B.2，3，6，8

C.1，2，3，6，7

D.1，2，3，6，，7，8

E.2，3，6，5，7

参考答案：B

第4题：

Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）

A、 shutdown restore datafile 4； recover datafile 4； alter database open；
B、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；
C、 Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；
D、 Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；
E、 Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；

正确答案:E

第5题：

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.

A、1，3，6，7
B、2，3，6，8
C、1，2，3，6，7
D、1，2，3，6，，7，8
E、2，3，6，5，7

正确答案:B

第6题：

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

A、 open the database with the RESTRICTED option
B、 open the database with the RESETLOGS option
C、 recover to the required SCN only that data file in which the error occurred
D、 recover all the data files to the same system change number （SCN）

正确答案:B,D

第7题：

In which case would you use the Flashback Database feature to perform a recovery？（）

A、to recover a dropped tablespace
B、to recover data from a truncated table
C、to recover a data file that has been shrunk
D、to recover a database to the state that existed before the RESETLOGS operation

正确答案:B

第8题：

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.Which three steps should you perform to recover the control file and make the database fully operational?（）

A. Mount the container database (CDB) and restore the control file from the control file auto backup.

B. Recover and open the CDB in NORMAL mode.

C. Mount the CDB and then recover and open the database, with the RESETLOGS option.

D. Open all the pluggable databases.

E. Recover each pluggable database.

F. Start the database instance in the nomount stage and restore the control file from control file auto backup.

参考答案：C, D, F

第9题：

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？（）

A、Restore all the data files and open the database
B、Create the data file and performtablespacerecovery
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

正确答案:A

第10题：

A、open the database with the RESETLOGS option
B、open the database with the RESTRICTED option
C、recover all the data files to the same system change number （SCN）
D、recover to the required SCN only that data file in which the error occurred

正确答案:A,C

单选题Your database has experienced a loss of datafile users_01.dbf， which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error？（）

题目

相似问题和答案

更多相关问题

相关内容