单选题
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message：
Which is the recommended sequence of operations you need to perform for the query successfully？（）A Drop the affected tablespace，re-create the tablespace，restore the datafiles，and the tablespace.
B Take the affected datafile offline（if not already offline），restore the damaged image of the datafile，and then bring it online.
C Restart the database in MOUNT mode，restore the damaged datafile，recover the datafile and then open the database with resetlogs.
D Put the database in RESTRICTED mode，restore all the datafiles in the affected datafile and recover the tablespace，and then put the database in normal operational mode.
正确答案
答案解析
略
相似试题
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）
单选题查看答案
Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（） a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogs
单选题查看答案
You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）
单选题查看答案
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
多选题查看答案
View the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）
单选题查看答案
You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
多选题查看答案
Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（） a. Issue a checkpoint. b. Shut down the database. c. Issue an alter database open command to open the database. d. Startup mount the database. e. Issue an alter database clear logfile command. f. Recover all database datafiles.
单选题查看答案
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）
多选题查看答案
You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
单选题查看答案
You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command： SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）; Which two statements are true？ （）
多选题查看答案