You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.

题目

You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.   Your colleague asks for you to comment on his plan.  Which response would be correct？（）

  • A、 The plan will work as is.
  • B、 The plan needs to be modified to allow for an archive-log switch after step 3.
  • C、 The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.
  • D、 The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.
  • E、 The plan cannot work as presented.
相似考题

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

2. Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）A、backup of offline tablespacesB、backup of read­only tablespacesC、backup of system­critical tablespacesD、backup of online， locally managed tablespacesE、backup of read/write dictionary­managed tablespaces

3. You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）A、You can perform consistent backups only.B、You can perform a complete database backup without shutting down the database instance.C、You can back up data files only when all data files have the same SCN recorded in the control file.D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

4.Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）A、 Backup of offline tablespaces.B、 Backup of read-only tablespaces.C、 Backup of system-critical tablespaces.D、 Backup of online， locally managed tablespaces.E、 Backup of read/write dictionary-managed tablespaces.

更多“You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs. ”相关问题

  • 第1题：

    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

  • 第2题：

    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

    • A、 The target database must be in NOARCHIVELOG mode.
    • B、 No backup is required of the database before you perform a TSPITR.
    • C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
    • D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
    • E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

    正确答案:A,B

  • 第3题：

    Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database？（）  

    • A、 Oracle will automatically take the datafile out of hot backup mode，generate a warning message，and then open the database.
    • B、 Oracle will automatically take the datafile out of hot backup mode and then open the database.
    • C、 Oracle will generate an error when trying to open the database，indicating that a datafile is in hot backup mode.You will need to correct this error before you can open the database.
    • D、 The database will open with the file in hot backup mode. You can restart the backup at any time.
    • E、 The datafile in hot backup mode will be corrupted and you will have to recover it.

    正确答案:C

  • 第4题：

    Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）  

    • A、 13：00 on Tuesday.
    • B、 15：00 on Tuesday.
    • C、 Up until the last available archived redo log on Sunday.
    • D、 To any point； all the redo should still be available in the online redo logs.
    • E、 The database is not recoverable.

    正确答案:E

  • 第5题：

    Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）

    • A、 Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 
    • B、 Datafiles are not written to during hot backups.
    • C、 Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
    • D、 The datafile headers are not updated during the backup.
    • E、 The way data is written to the online redo logs is unchanged during the backup.

    正确答案:D

  • 第6题：

    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

  • 第7题：

    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

    • A、 all the data files belonging to the USERS tablespace
    • B、 password file
    • C、 online redo log files
    • D、 the current control file
    • E、 archived redo log files
    • F、 the current server parameter file
    • G、 data files belonging to the USERS tablespace and all the default tablespaces

    正确答案:A,D,F

  • 第8题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

  • 第9题：

    单选题
    You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database， as shown here：   Put the tablespaces in backup mode.  Back up the datafiles for all tablespaces. Take the tablespaces out of backup mode. Back up all archived redo logs.   Your colleague asks for you to comment on his plan.  Which response would be correct？（）
    A

     The plan will work as is.

    B

     The plan needs to be modified to allow for an archive-log switch after step 3.

    C

     The plan needs to be modified so that a backup of the archived redo logs occurs before step 1.

    D

     The plan needs to be adjusted to shut down the database after step 1 and to restart the database after step 2.

    E

     The plan cannot work as presented.


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

  • 第10题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.


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

  • 第11题：

    单选题
    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
    A

     backup database all

    B

     backup compressed database

    C

     backup as compressed backupset database

    D

     backup as compressed backup database plus archivelog all

    E

     backup as compressed backupset database plus compress archivelog all


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

  • 第12题：

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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）  

    • A、 backup database
    • B、 backup database and archivelogs
    • C、 backup database plus archivelogs
    • D、 backup database plus archivelog delete input
    • E、 backup database and archivelog delete input

    正确答案:D

  • 第16题：

    A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

    • A、 backup database all
    • B、 backup compressed database
    • C、 backup as compressed backupset database
    • D、 backup as compressed backup database plus archivelog all
    • E、 backup as compressed backupset database plus compress archivelog all

    正确答案:C

  • 第17题：

    You backed up the database at 8 a.m. today using an online backup. Accounting made a large change to the underlying data between 10 a.m. and noon.  Which of the following actions would ensure that the changes could be recovered using the 8 a.m. backup？（）  

    • A、 Create a manual incremental online database backup.
    • B、 Back up all the archived redo logs generated since the 8 a.m. backup.
    • C、 Create a brand-new backup after all the changes have been applied.
    • D、 There is no way to make the changes recoverable based on the 8 a.m. backup.
    • E、 Perform an online backup of the tablespace（s） that contained changed data.

    正确答案:B

  • 第18题：

    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）  

    • A、 alter tablespace MY_DATA begin backup
    • B、 alter tablespace MY_DATA start backup
    • C、 alter tablespace MY_DATA backup begin
    • D、 alter MY_DATA begin backup
    • E、 You cannot back up individual tablespaces

    正确答案:A

  • 第19题：

    单选题
    Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
    A

     backup database

    B

     backup database and archivelogs

    C

     backup database plus archivelogs

    D

     backup database plus archivelog delete input

    E

     backup database and archivelog delete input


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

  • 第20题：

    单选题
    Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
    A

     Restore all the datafiles from the backup.

    B

     Restore only the lost datafile from the backup.

    C

     Restore all the datafiles for the lost tablespace from the backup.

    D

     Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.


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

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

    多选题
    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）
    A

    The target database must be in NOARCHIVELOG mode.

    B

    No backup is required of the database before you perform a TSPITR.

    C

    You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.

    D

    If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.

    E

    If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.


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

  • 第23题：

    单选题
    Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode？（）
    A

     Archive log generation is suspended until the tablespaces are taken out of hot backup mode. 

    B

     Datafiles are not written to during hot backups.

    C

     Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.

    D

     The datafile headers are not updated during the backup.

    E

     The way data is written to the online redo logs is unchanged during the backup.


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

相关内容