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 f

题目

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.
相似考题

1.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.

2.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. 

3.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.

4.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.

更多“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 f”相关问题

  • 第1题：

    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）

    • A、Only the SET command must be within a RUN block.
    • B、All commands should be executed at the RMAN prompt.
    • C、All three commands must be within a single RUN block.
    • D、Only the RESTORE and RECOVER commands must be within a single RUN block.

    正确答案:C

  • 第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题：

    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

  • 第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？（）   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、a， c， f， g
    • B、b， c， f， h
    • C、a， b， c， f， g
    • D、a， b， c， f， g， h
    • E、b， c， f， e， g

    正确答案:B

  • 第6题：

    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.

    正确答案:B,E

  • 第7题：

    Your developers have asked you to restore the development database， which is in NOARCHIVELOG mode， back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do？（）

    • A、 Restore the 19ths backup， restore all archived redo logs， recover the database to the 20th，and open the database.
    • B、 Tell them that their request cannot be met with the current backup strategy.
    • C、 Restore the 19ths backup， apply the online redo logs，and open the database.
    • D、 Switch the database into ARCHIVELOG mode，restore the 19th’s backup，restore all archived redo  logs，and recover the database to the 20th.
    • E、 Use the recover database command to roll back the database from today to the 19th of the month.

    正确答案:B

  • 第8题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第9题：

    多选题
    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.


    正确答案： B,D
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You lost the PRODSTD tablespace， which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace？（）
    A

     restore the tablespace from the backup， and then perform an incomplete recovery

    B

     restore the tablespace from the backup， and then apply all the redo information

    C

     restore all the data files in the database， and then perform an incomplete recovery

    D

     restore the tablespace from the backup


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    Which command is used to begin a tablespace point-in-time recovery？（）  

    • A、 Restore tablespace
    • B、 Recover tablespace
    • C、 Tablespace recover
    • D、 Recover to time
    • E、 recover datafile

    正确答案:B

  • 第15题：

    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

    • A、Restore the data file and perform incomplete recovery.
    • B、Restore the data file and perform point-in-time recover.
    • C、Drop the tablespace and lose all data in the tablespace.
    • D、Restore the database and lose all data since the last backup.

    正确答案:C,D

  • 第16题：

    You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command：       RMAN>BACKUP DATABASE；  At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）

    • A、 Start the database in the MOUNT stage.
    • B、 Back up the control file to trace.
    • C、 Set the DBID
    • D、 Issue the RECOVER DATABASE command.

    正确答案:C

  • 第17题：

    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 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

    正确答案:D

  • 第18题：

    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

    正确答案:D

  • 第19题：

    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、a， b， e， c
    • B、b， e， d
    • C、a， b， d， c
    • D、b， g， c， f
    • E、a， b， d， f

    正确答案:A

  • 第20题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You have lost datafiles 1 and 3 from your database，and the database has crashed.  In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline.  2. startup mount the database  3. Issue the alter database open command. 4. Restore the datafiles that were lost  5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online.  7. Recover the database with the recover database command.
    A

     2，1，3，4，5，6

    B

     2，4，5，3

    C

     4，7，3

    D

     2，4，7，3

    E

     2，7，3


    正确答案： E
    解析： 暂无解析

相关内容