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 databas

题目

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

1.You are working on the PROD database， which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database？（）A、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， open the database with the RESETLOGS option after performing a cancel-based recovery.B、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C、 Restore the database from a whole consistent backup and start the database in MOUNT mode. Then， clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D、 Do nothing. You do not need to recover the database in this case； an instance recovery will be performed by the SMON process on startup.

2.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 exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery

3. Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

4. You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process？（）A、 Database Identifier （DBID）B、 names and location of datafilesC、 names and location of control filesD、 names and location of online redo log files

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

  • 第1题：

    You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

    • A、This operation resets the SCN for the database.
    • B、This operation creates a new incarnation of the database.
    • C、This operation moves all the redo log files to a different location.
    • D、This operation deletes the old redo log files and creates new redo log files.
    • E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

    正确答案:B,E

  • 第2题：

    Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

    • A、 Database datafiles
    • B、 Control files
    • C、 Archived redo logs
    • D、 Online redo logs
    • E、 Flashback logs

    正确答案:A,B,D

  • 第3题：

    You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

    • A、Open the database in NORMAL mode
    • B、Open the database in read-only mode
    • C、Open the database in RESTRICTED mode
    • D、Open the database with the RESETLOGS option

    正确答案:D

  • 第4题：

    Which files are required for a full recovery of the database in ARCHIVELOG mode？（）

    • A、 Database datafiles
    • B、 Online redo logs
    • C、 Archived redo logs
    • D、 Backup control file
    • E、 Control file from a backup

    正确答案:A,C,D

  • 第5题：

    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第6题：

    When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）  

    • A、 To indicate the location of the auxiliary-instance online redo logs.
    • B、 To indicate the location of the target database datafiles.
    • C、 To indicate the location of the auxiliary-instance control file and online redo logs.
    • D、 To indicate the location of the auxiliary-instance database datafiles.
    • E、 This is not a valid parameter when duplicating a database.

    正确答案:D

  • 第7题：

    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  

    • A、 You will need to open the database with the resetlogs command.
    • B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
    • C、 You will use the resetlogs version of the create controlfile command.
    • D、 You will use the noresetlogs version of the create controlfile command.
    • E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command

    正确答案:D

  • 第8题：

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


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

  • 第9题：

    单选题
    You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）
    A

    Only the data files.

    B

    Only the data files and the online logs.

    C

    The data files， control files， and the online logs.

    D

    The data files and control files， but not the online logs.


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

  • 第10题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


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

  • 第11题：

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

  • 第12题：

    单选题
    You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）
    A

     You will need to open the database with the resetlogs command.

    B

     All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

    C

     You will use the resetlogs version of the create controlfile command.

    D

     You will use the noresetlogs version of the create controlfile command.

    E

     You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command


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

  • 第13题：

    You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP  FORMAT ’/BACKUP/df_%d_%s_%p.bus’  DATABASE filesperset = 2；  Which components are included in the backup？（）

    • A、Only the data files.
    • B、Only the data files and the online logs.
    • C、The data files， control files， and the online logs.
    • D、The data files and control files， but not the online logs.

    正确答案:D

  • 第14题：

    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

  • 第15题：

    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第16题：

    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）

    • A、Database Datafiles 
    • B、Database Control Files 
    • C、Online redo logs
    • D、Archived redo logs 
    • E、The database SPFILE 
    • F、None of the above, all these files are backed up. 

    正确答案:C

  • 第17题：

    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

    • A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
    • B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
    • C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
    • D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

    正确答案:D

  • 第18题：

    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

  • 第19题：

    Which of the following files cannot be backed up by RMAN? （）(Choose all that apply.）

    • A、Database datafiles
    • B、Control files
    • C、Online redo logs
    • D、Database pfiles
    • E、Archived redo logs

    正确答案:C,D

  • 第20题：

    多选题
    You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？ （）
    A

    This operation resets the SCN for the database.

    B

    This operation creates a new incarnation of the database.

    C

    This operation moves all the redo log files to a different location.

    D

    This operation deletes the old redo log files and creates new redo log files.

    E

    This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.


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

  • 第21题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）
    A

    Database Datafiles 

    B

    Database Control Files 

    C

    Online redo logs

    D

    Archived redo logs 

    E

    The database SPFILE 

    F

    None of the above, all these files are backed up. 


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

  • 第22题：

    单选题
    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）
    A

    only the control file, the current SPFILE, and data files

    B

    only the current SPFILE and data files if autobackup is disabled

    C

    only the data files and the archived redo logs

    D

    the control file, current SPFILE file, data files, and archived redo logs


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

  • 第23题：

    单选题
    You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup？（）
    A

     Database Datafiles

    B

     Database Control Files

    C

     Online redo logs

    D

     Archived redo logs

    E

     The database SPFILE

    F

     None of the above，all these files are backed up


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

相关内容