单选题Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：   1. Take data file DF1 offline.  2. Copy a backup copy of DF1 into the current DF1 location.  3. Execute RECOVER DAT

题目
单选题
Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：   1. Take data file DF1 offline.  2. Copy a backup copy of DF1 into the current DF1 location.  3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.  4. Bring DF1 online.  5. Execute ALTER DATABASE OPEN RESETLOGS.   To guarantee that the database is recoverable in the future， what is the least amount of work needed？（）
A

Back up the data file.

B

Bring tablespace TS1 online.

C

Copy redo logs to the backup directory.

D

Make a complete backup right after opening the database.

相似考题

1. Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）A、2, 4, 3B、1, 4, 3, 2C、2, 5, 4, 3, 6D、5, 2, 4, 3, 6E、1, 5, 4, 3, 6, 2

2.Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）A、Redo logsB、Control fileC、The latest backup of only the damaged data fileD、The latest backup of all the data file in the USERS tablespaceE、Temporary files of temporary tablespaceF、Archive Logs since the latest backup to point of failure

3.Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）A、Until last commitB、Until the time you perform recoveryC、Until the time the date file got corruptedD、Until the point where the last transaction begunE、You cannot recover the SYSTEMtablespaceand must re-create the database.

4. Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）A、Take the USERS tablespace offline and re-create the lost data file.B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

更多“单选题Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：   1. Take data file DF1 offline.  2. Copy a backup copy of DF1 into the current DF1 location.  3. Execute RECOVER DAT”相关问题

  • 第1题：

    Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

    • A、 redo logs
    • B、 control file
    • C、 temporary files of temporary tablespace
    • D、 the latest backup of only the damaged data file
    • E、 the latest backup of all the data files In the USERS tablespace

    正确答案:A,B,D

  • 第2题：

    Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）

    • A、2，4，3
    • B、1，4，3，2
    • C、2，5，4，3，6
    • D、5，2，4，3，6
    • E、1，5，4，3，6，2

    正确答案:E

  • 第3题：

    Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

    • A、Take the USERS tablespace offline and re-create the lost data file.
    • B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
    • C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
    • D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

    正确答案:C

  • 第4题：

    The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is available. How do you recover the data file？（）

    • A、The data file cannot be recovered.
    • B、The date file can be restored from the SYSTEM auto backup.
    • C、Take thetablespaceoffline，drop，kand re-create it.
    • D、Recovery Manager （RMAN） is used to recover the data file.
    • E、The ALTER DATABSE CREATE DATAFILE..commandis used to recover the data file.

    正确答案:A

  • 第5题：

    Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：   1. Take data file DF1 offline.  2. Copy a backup copy of DF1 into the current DF1 location.  3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.  4. Bring DF1 online.  5. Execute ALTER DATABASE OPEN RESETLOGS.   To guarantee that the database is recoverable in the future， what is the least amount of work needed？（）

    • A、Back up the data file.
    • B、Bring tablespace TS1 online.
    • C、Copy redo logs to the backup directory.
    • D、Make a complete backup right after opening the database.

    正确答案:D

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

    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

  • 第8题：

    单选题
    Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）
    A

    2，4，3

    B

    1，4，3，2

    C

    2，5，4，3，6

    D

    5，2，4，3，6

    E

    1，5，4，3，6，2


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

  • 第9题：

    单选题
    Your Certkiller .com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEMtablespacehas become corrupted. Up to what point can you recover the database？（）
    A

    Until last commit

    B

    Until the time you perform recovery

    C

    Until the time the date file got corrupted

    D

    Until the point where the last transaction begun

    E

    You cannot recover the SYSTEMtablespaceand must re-create the database.


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

  • 第10题：

    单选题
    You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database.
    A

    a， b， f， g

    B

    c， f， g

    C

    a， d， f， g

    D

    a， f， g

    E

    a， e， g


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

  • 第11题：

    单选题
    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）
    A

    Only bring the tablespace back online.

    B

    Only recover the tablespace and then bring the tablespace back online.

    C

    Shut down the database， recover the data file and then start up the database.

    D

    Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.

    E

    Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.


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

  • 第12题：

    单选题
    Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）
    A

    2，4，3

    B

    1，4，3，2

    C

    2，5，4，3，6

    D

    5，2，4，3，6

    E

    1，5，4，3，6，2


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

  • 第13题：

    Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows：   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files？（）

    • A、 2，4，3
    • B、 1，4，3，2
    • C、 2，5，4，3，6
    • D、 5，2，4，3，6
    • E、 1，5，4，3，6，2

    正确答案:E

  • 第14题：

    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）

    • A、Until last commit
    • B、Until the time you perform recovery
    • C、Until the time the date file got corrupted
    • D、Until the point where the last transaction begun
    • E、You cannot recover the SYSTEMtablespaceand must re-create the database.

    正确答案:A

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

    The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）

    • A、No transaction on the tablespace is allowed but you can perform queries.
    • B、The tablespace will automatically come out of backup mode when the file copy is complete.
    • C、The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
    • D、The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

    正确答案:A,C

  • 第17题：

    In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this：   1） Mount the database  2） Take the data file offline  3） Bring the data file online  4） Use the RMAN SWITCH TO command to switch the image copy  5） Apply the archived redo logs  6） Open the database  7） Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow？（）

    • A、 2， 6， 4， 5， 3
    • B、 1， 2， 4， 5， 3， 6
    • C、 1， 2， 4， 6， 3
    • D、 1， 2， 7， 5， 3， 6

    正确答案:B,D

  • 第18题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第19题：

    单选题
    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
    解析： 暂无解析

  • 第20题：

    单选题
    Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace?（）
    A

    6，5，4，7

    B

    10，1，2，5，8

    C

    10，1，2，5，4，9，8

    D

    10，1，5，8，10


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

  • 第21题：

    单选题
    Data file DF1 belongs to tablespace TS1.，and the database is in ARCHIVELOG mode. You did an incomplete recover in the following steps：   1. Take data file DF1 offline.  2. Copy a backup copy of DF1 into the current DF1 location.  3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.  4. Bring DF1 online.  5. Execute ALTER DATABASE OPEN RESETLOGS.   To guarantee that the database is recoverable in the future， what is the least amount of work needed？（）
    A

    Back up the data file.

    B

    Bring tablespace TS1 online.

    C

    Copy redo logs to the backup directory.

    D

    Make a complete backup right after opening the database.


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

  • 第22题：

    单选题
    Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）
    A

    Until last commit

    B

    Until the time you perform recovery

    C

    Until the time the date file got corrupted

    D

    Until the point where the last transaction begun

    E

    You cannot recover the SYSTEMtablespaceand must re-create the database.


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

  • 第23题：

    多选题
    In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this：   1） Mount the database  2） Take the data file offline  3） Bring the data file online  4） Use the RMAN SWITCH TO command to switch the image copy  5） Apply the archived redo logs  6） Open the database  7） Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow？（）
    A

    2， 6， 4， 5， 3

    B

    1， 2， 4， 5， 3， 6

    C

    1， 2， 4， 6， 3

    D

    1， 2， 7， 5， 3， 6


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

  • 第24题：

    单选题
    Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）
    A

    2, 4, 3

    B

    1, 4, 3, 2

    C

    2, 5, 4, 3, 6

    D

    5, 2, 4, 3, 6

    E

    1, 5, 4, 3, 6, 2


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

相关内容