677.What are the prerequisites for performing flashback transactions?(Choose all that apply)
A.Supplemental log must be enabled
B.Supplemental log must be enabled for the primary key
C.Undo retention guarantee for the database must be configured
D.EXECUTE permission on the DBMS_FLASHBACK package must be granted to the user
Answer:ABD
答案解析：
参考：/rlhua/article/details/12224763
要使用闪回回退事务处理功能，必须启用补充事件记录功能并建立正确的权限。例如，HR方案中的HR 用户决定对REGIONS表使用闪回事务处理。SYSDBA可确保数据库处于归档日志模式， alter database add supplemental log data;
alter database add supplemental log data(primary key)columns;
grant execute on dbms_flashback to hr;
grant select any transaction to hr;
678.Which are the two prerequisites before setting up Flashback Data Archive?(Choose two.)
A.Flash recovery area must be defined
B.Undo retention guarantee must be enabled.
C.Database must be running in archivelog mode.
D.Automatic undo management must be enabled.
E.The tablespace in which the Flashback Data Archive is created must have automatic segment space Management(ASSM).
Answer:DE
答案解析：
A，错误，闪回数据归档跟FRA区没有关系，闪回归档的数据是保存在闪回数据表空间的数据文件里。B，错误，闪回数据归档和undo数据没关系。
C，错误，在非归档模式下也能创建闪回数据归档。
D，正确，必须是自动还原管理自动管理下能创建成功，切换到手动管理后，创建失败。
E，正确。TESTUNDOTBS为手动管理的，在此上面创建闪回数据归档，报错。所以必须在ASSM表空间下使用
679.Which mode of database shutdown requires an instance recovery at the time of the next database startup?
A.ABORT
B.NORMAL
C.IMMEDIATE
D.TRANSACTIONAL
Answer:A
680.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?(Choose Two)
A.Creating the control file for the duplicate database
B.Restoring the target data files to the duplicate database
C.Performing complete recovery using all available backups
D.Generating a new,unique DBID for the duplicate database
E.Copying the online redo log files from the target database to the duplicate database
Answer:CE
答案解析：
参考：/rlhua/article/details/13509067
当执行DUPLICATE命令时，RMAN会执行下列操作：1A.为辅助实例创建服务器参数文件（对于活动数据库和使用目标连接执行的基本备份的复制），或：1B.从备份中还原（对于备用数据库和没有目标连接的基于备份的复制）2.装载备份控制文件3.对于基于备份的复制：选择用于将数据文件还原到辅助实例的备份4.将目标数据文件还原到副本数据库5.使用所有可用的增量备份和归档重做日志文件执行不完全恢复6.关闭辅助实例并以NOMOUNT模式重新启动它7.新建一个控制文件，然后控制文件在数据文件中创建并存储新的DBID8.通过RESETLOGS选项打开副本数据库9.为副本数据库创建联机重做日志文件 注：数据库复制过程在重新执行时尝试从故障点继续。
C应该为不完全恢复。因为源数据库为open状态，只能热备份，恢复时恢复到目的数据库，因为联机重做日志无法应用，故只能不完全恢复。E，因为源数据库中的联机重做日志文件未备份且无法应用于副本数据库，就算复制也没用，所以RMAN执行数据库时间点恢复必需的。副本数据库的最远恢复点是由源数据库归档的最近重做日志文件。
681.The environmental variable ORACLE-BASE is set.You want to check the diagnostic files created as part of the Automatic Diagnostic Repository(ADR).Vi ew the Exhibit and note the various parameters set in your database.
What will be the location of the ADR base?
A.It is set to ORACLE-BASE.
B.It is set to ORACLE_HOME/log.
C.It is set to/u01/app/oracle/admin/orcl/adump.
D.It is set to/u01/app/oracle/flash_recovery_area.
Answer:C
答案解析：
参考：/cd/E11882_01/server.112/e25494/diag.htm#CHDIABAA
既然题中已经说明The environmental variable ORACLE-BASE is set，那么
根据If environment variable ORACLE_BASE is set,DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
此题应该选A。
682.Identify the scenarios in which the RMAN CROSSCHECK comm and is useful.(Choose all that apply.)
A.To check that the obsolete backups are deleted from the repository records and from the disk.
B.To update the RMAN repository if you delete archived redo logs with operating system commands.
C.To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.
D.To synchronize the actual files on disk or in the media management catalog with the RMAN repository for which the backup was not taken using RMAN.
Answer:AD
答案解析：
参考：/cd/E11882_01/backup.112/e10642/rcmmaint.htm#BRADV287
正确答案应为BC
Crosschecks are useful because they can do the following:
Update outdated information about backups that disappeared from disk or tape or became corrupted Update the repository if you delete archived redo logs or other files with operating system commands
683.Your production database it f unctional on the SHOST1host.Y ou are backing up the production database by using Recovery Manager(RMAN)with the recovery catalog.You want to replicate the production database to anther host,SHOST2,for testing new applications.
After you ensured that the backups of the target database are accessible on the new host,what must you do to restore and recover the backup for the test environment?
A.Restoring the control file from the backup by using the NOCATAL OG option to restore,and recovering the data files
B.Restoring the data files by us ing the NOCATALOG option and us ing the SET NEWNAME command to change the location
C.Restoring the server parameter file from the backup by using the recovery catalog to restore,and recovering the data files
D.Restoring the data files from the backup by using the recovery catalog to recover the files,and using the SWITCH command to change the location.
Answer:D
答案解析：
参考：/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV370
正确答案选A
你的生产库在SHOST1，你使用rman的恢复目录来备份生产库。你想复制生产库到另一台主机上SHOST2作为测试用之后你确定在新的主机上你的目标数据库的备份能够被访问，什么是你必须要在测试环境还原和恢复的？Start RMAN on hostb and connect to the target database without connecting to the recovery catalog.C错D错If the file systems on the destination system are set up to have the same paths as the source host,then do not use SET NEWNAME for those files restored to the same path as on the source host.B错误
684.Your database is running in ARCHIVELOG mode.You have been taking backups of all the data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been dropped on February28,2007at10.30AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL>RECOVER DATABASE UNTIL TIME‘2007-02-28:10:15:00’;
Identify the files that must be restored to recover the missing tables successfully.
A.Restore the backup of all the data files.
B.Restore the backup of all the data files and the control file.
C.Restore the backup of only the data files that contain the dropped tables.
D.Restore the backup of all the data files belonging to the tablespace containing the dropped tables. Answer:D
答案解析：
你的数据库运行在归档模式，并且定期备份了所有的数据文件和控制文件。
你被通知一些在BILLING表空间的重要的表在ebruary28,2007at10.30AM丢失，并且要求恢复。你决定使用以下命令执行不完全恢复SQL>RECOVER DATABASE UNTIL TIME
‘2007-02-28:10:15:00’;
从以下实验中看出，如果是recover database，则必须先restore databse，则是restore所有备份的数据文件。此题应该选A
685.In your test database:
-You are using Recovery Manager(RMAN)to perform incremental backups of your test database
-The test database is running in NOARCHIVELOG mode
-One of the data files is corrupted
-All online redo log files are lost because of a media failure
Which option must you consider in this scenario?
A.Configuring the database in ARCHVIELOG mode and then using incremental backup to recover the database
B.Using incremental backup to recover the damaged data file and then manually creating the online redo log files
C.Creating a new test database because the database is not recoverable du e to the fact that the database is configured in NOARCHIVELOG mode
D.Using incremental backups to recover the database by using the RECOVER DATABASE NOREDO command and then using the RESETLOGS option to open the database.
Answer:C
答案解析：
参考：/cd/E11882_01/backup.112/e10643/rcmsynta2001.htm#RCMRF90258
根据官方文档，此题应该选D
686.You execute the following FLASHBACK TABLE command:
Which two statements are correct?(Choose two.)
A.The EMP table that was dropped by mistake earlier is restored.
B.The FLASHBACK TABLE statement is executed as a single transaction.
C.The FLASHBACK TABLE statement does not maintain existing indexes on the EMP table.
D.The changes made to the EMP table since the specified time are undone if no constraint is violated during flashback.
Answer:AD
答案解析：
排除法：A错，C错，D正确
正确选BD
A，应该使用TO BEFORE DROP来恢复，利用回收站原理。A错
参考：/cd/E11882_01/backup.112/e10642/rcmflash.htm#BRADV89742
687.Users are connected to a database instance that is using Automatic Storage Management(ASM). The DBA executes the command as follows to shut down the ASM instance:
SQL>SHUTDOWN IMMEDIATE;
What happens to the database instance?
A.It shuts down long with the ASM instance.
B.It is aborted and the ASM instance shuts down normally.
C.It stays open and SHUTDOWN command for the ASM instance fails.
D.It shuts down only after all pending transactions are completed and the ASM instance waits for this before shutting down.
Answer:D
答案解析：
豫公网安备41160202000603
站长QQ:729038198
关于我们
投诉建议