单选题Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three databa

题目

单选题

Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database： a. Restore the three database datafiles that were lost. b. Issue the Startup Mount command to mount the database. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command. g. Take the datafiles offline. Which is the correct order of these steps in this case？（）

a， b， e， c

b， e， d

a， b， d， c

b， g， c， f

a， b， d， f

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

相似问题和答案

第1题：

The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）

A、 The block change tracking feature must be enabled.
B、 OMF must be configured on your database.
C、 The database must be in ARCHIVELOG mode.
D、 A USERID must be supplied.

正确答案:D

第2题：

If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）

A、 Complete database recovery.
B、 Incomplete database recovery.
C、 Approximate database recovery.
D、 Archived database recovery.
E、 The database could not be recovered with RMAN.

正确答案:B

第3题：

Tom () since he lost his job three weeks ago.

A、has employed

B、was unemployed

C、had been unemployed

D、has been unemployed

参考答案：D

第4题：

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
G、OBSOLETE

正确答案:B

第5题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

A、 online redo log files
B、 alert log files
C、 control file
D、 datafiles associated with the SYSTEM tablespace

正确答案:C

第6题：

You performed an incomplete recovery on your Oracle Database 10g database using the following command： SQL> RECOVER DATABASE 2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE； In which situation would the above recovery be required？（）

A、 A user table was lost at the specified time.
B、 A redo log file was lost at the specified time.
C、 The backup control file is on a faster disk than the current one.
D、 The current control file has a different path compared with the intended time of recovery.
E、 The current control file does not match the physical structure of the database at the intended time of recovery.

正确答案:E

第7题：

Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（）

A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
B、 Just back up the database datafiles without shutting down the database.
C、 You will have to wait until you can shut down the database to perform the backup.
D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup

正确答案:C

第8题：

Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement： SQL> DROP TABLE SCOTT.EMP PURGE； After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）

A、 the datafiles associated with the SYSTEM tablespace
B、 the datafiles associated to the DATA1 tablespace
C、 the datafiles associated to the SYSTEM and DATA1 tablespaces
D、 all the datafiles in the database

正确答案:D

第9题：

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A、renaming the control files
B、dropping a user in your database
C、enabling or disabling redo log archiving
D、dropping a tablespace in your database
E、re-creating the control files， after you lost all the control files in your database

正确答案:C

第10题：

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

A、import the database from the last export
B、restore all the members in the group from the last backup
C、drop the lost member from the database， and then add a new member to the group
D、restore all the database files from the backup， and then perform a complete recovery
E、restore all the database files from the backup， and then perform an incomplete recovery

正确答案:C

Your ARCHIVELOG-mode database has lost three datafiles and s

题目

相似问题和答案

更多相关问题

相关内容