502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow. 1) Restore the corrupted redo log group. 2) Restore from a whole database backup. 3) Perform incomplete recovery. 4) Relocate by renaming the member of the damaged online redo log group to a new location. 5) Open the database with the RESETLOGS option. 6) Restart the database instance. 7) Issue a checkpoint and clear the log. Identify the option with the correct sequential steps to accomplish the task efficiently. redo log 损坏恢复数据库 B. 7,3,4. and 5 Recovering from Loss of Active Logs in ARCHIVELOG Mode In this scenario,the database archiving mode is ARCHIVELOG. To recover from loss of an active online redo log group in ARCHIVELOG mode: Begin incomplete media recovery,recovering up through the log before the damaged log. Ensure that the current name of the lost redo log can be used for a newly created file. If not,then rename the members of the damaged online redo log group to a new location. For example,enter: ALTER DATABASE RENAME FILE "/disk1/oradata/trgt/redo01.log" TO "/tmp/redo01.log"; ALTER DATABASE RENAME FILE "/disk1/oradata/trgt/redo02.log" TO "/tmp/redo02.log"; Open the database using the RESETLOGS option: ALTER DATABASE OPEN RESETLOGS; 503.Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager (RMAN). (Choose two.) A. You can use RMAN stored scripts. 存储rman脚本 C. You can store backup Information of all registered databases in one place. 备份信息在一个地方 504.View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure,you executed the following as the first command in the RMAN session: RMAN> REPAIR FAILURE; Which statement。。。。。。 D.The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command. Answer: D 505.You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous同时的 duplicate backup of the data files when the RMAN BACKUP command is used. 同时复制备份的数据文件 怎么配置 What must you set using the RMAN CONFIGURE command to achieve this? C. RETENTION POLICY TO REDUNDANCY 2; 保留策略为冗余2个 506.Examine the following ALTER command; sql> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command? A. It cancels all pending disk drops within the disk group. 取消掉盘过程 507.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)? (Choose three.) 运行在归档模式， 从失败点恢复， 备份可用 dba需要哪三个文件 A. redo logs B. control file D. the latest backup of only the damaged data file 508.You want to set the following Initialization parameters for your database Instance LOG_ARCHIVE_DEBT_1 =,LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 =,LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 =,LOCATION=/disk3/arch LOG_ARCHIVE DBST_ =,LOCATION=/disk3/arch Identify the statement that correctly describes this setting. D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination. Answer: D 此题题意有问题，第四个路径应为LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY' 如果两个路径相同，如题中3和4是一样的/disk3/arch，是不对的。 sys@TEST1107> alter system set log_archive_dest_1='LOCATION=/u01/rmanbak/d1'; System altered. sys@TEST1107> alter system set log_archive_dest_2='LOCATION=/u01/rmanbak/d1'; alter system set log_archive_dest_2='LOCATION=/u01/rmanbak/d1' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16033: parameter LOG_ARCHIVE_DEST_2 destination cannot be the same as parameter LOG_ARCHIVE_DEST_1 destination 509.Which of the following cannot be used as input to the sql Tuning Advisor? (Choose all that apply.) C. A preprocessed Database Replay workload D. A schema name 510.You executed the following command in Recovery Manager (RMAN): RMAN> REPORT NEED BACKUP days 3; What is the output of this command? 报告3天内需要备份的 A. a list of files that require a backup within three days 511.You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance: LOG_ARCHIVE_DEST 1 =,LOCATION=/disk1/arch MANDATORY强制的托管的' LOG _ARCHIEVE_DEST 2 =,LOCATION=/disk2/arch' LOG_ARCHIVK_DEST_3 =,LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch' LOG_ARCHIVE_MIN-SUCCEED_DEST = 2 While the database instance is functional,you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used. What happens in an event of log switch? D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success. Answer: D 忽略第一个，在另外两个位置创建 MANDATORY Specifies that filled online log files must be successfully archived to the destination before they can be reused. If MANDATORY is not specified,then,by default,the destination is considered to be optional. At least one destination must succeed,even if all destinations are optional. If archiving to an optional destination fails,the online redo log file is still available for reuse and may be overwritten eventually. However,if the archival operation of a mandatory destination fails,online redo log files cannot be overwritten. 512.Which two statements correctly describe the relationship among the Scheduler components: job,program,and schedule? (Choose two) A. A job is specified as part of a program definition B. A program can be used in the definition of multiple jobs C. A program and job can be specified as part of a schedule definition D. A program and schedule can be specified as part of a job definition 正确答案BD 调度程序使用以下基本组件： • “作业”指定要执行的操作。它可以是PL/sql 过程、纯二进制可执行文件、Java 应用程序或Shell 脚本。可以将程序（内容）和调度（时间）指定为作业定义的一部分， 也可以改用现有的程序或调度。可以使用作业的参数来定制其运行时行为。 • “调度”指定作业的执行时间和次数。调度可以基于时间或事件。可以为作业定义调度，方法是使用一系列日期、一个事件，或两者相结合，以及表示重复间隔的附加说 明。可以单独存储作业的调度，然后对多个作业使用同一个调度。 • “程序”是有关特定可执行文件、脚本或过程的元数据集合。自动作业将执行某个任务。使用程序，无需修改作业本身即可修改作业任务或者“内容”。可以定义程序的参数，使用户可以修改任务的运行时行为。 513.What RMAN command is used to execute a tablespace point-in-time recovery? A. recover 514.A user performs an update on a table. Shortly after committing the transaction,they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its prevIoUs state? E. Flashback Table Answer: E 515.A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take? D. Perform a Flashback Drop operation. 516.In a Database Replay workload capture,what client request information is gathered? (Choose all that apply.) A. sql text C. Bind variable values D. Information about transactions 517.Which of the following are true concerning关于 block media recovery? (Choose all that apply.) B. If a gap缺口 in archive logs is encountered,遇到 RMAN will search forward for newer versions of the blocks that are not corrupt. C. Uncorrupted blocks from the flashback logs may be used to speed recovery. 在闪回日志中没有损坏的块 可以用快速恢复 关于RMAN的块恢复。Block是oracle数据库最小恢复单位。鉴于此，BMR可以大大缩短恢复的时间，另外，在进行BMR时不需要停掉数据库，可以直接在数据库open状态对数据文件进行恢复，只是需要恢复的块被锁定无法访问，可以说对应用的影响非常小。 何时需要进行BMR？ Block media recovery 不适合用在丢失数据的起点的情况，比如数据文件丢失了，这种情况下做数据文件的介质恢复会是最好的选择。BMR并不是用来取代传统方法的，而是有益的补充。 大多数情况下，数据库将一个block打上坏块的标记，那么对整个数据库来说这个块都是不可以用的，数据库会offline该坏块，阻止用户对该块进行访问。而在随后对该块的读取都会出现错误，大部分会报I/O错误，直到该坏块被修复。这个时候你只能使用BMR对坏块进行修复（之所以说你只能是因为你的数据库不能因为这个而停止服务）。一般我们会在以下文件中发现坏块报告： 1.Error messages in standard output; 2.Alert.log文件中 3.用户的trace文件 4.在使用 analyze table 和 analyze index时可能会出现 5.在使用 dbverify工具对数据文件进行检查时 6.第三方的介质管理软件中 以下是user trace文件中出现的坏块错误： ORA-01578: ORACLE data block corrupted (file # 7,block # 3) ORA-01110: data file 7: '/oracle/oradata/trgt/tools01.dbf' ORA-01578: ORACLE data block corrupted (file # 2,block # 235) ORA-01110: data file 2: '/oracle/oradata/trgt/undotbs01.dbf' 一旦发现有坏块的存在，就可以使用blockrecover对坏块进行恢复 Blockrecover datafile 7 block 3 datafile 2 block 235; Blockrecover是基于redo的,如果在恢复时，发现找不到redo，则恢复不一定会成功。这里说不一定是因为在blockrecover过程中，所有的block在blockrecover过程中都是独立的，不会去与其他文件的文件进行比较的，所以blockrecover都是成功的。但在blockrecover之后，RMAN会将进行后续的检查工作，这个时候，如果RMAN发现该块的ckp与其他不一致，则rman会自动查找相关的redo，如果该block有被format过，那么则会主动忽略丢失的redo，则恢复成功，如果不是这样则会恢复失败。 518.The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA,based on the amount of memory available on the system? E. 80% SGA,20% PGA Answer: E For OLTP systems,the PGA memory typically accounts for a small fraction of the total memory available (for example,20%),leaving 80% for the SGA. 519.You notice that a long-running transaction is suspended due to a space constraint,and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value. Which of these actions is appropriate? B. Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend延迟 the time-out超时 for the session while you fix the problem. 你注意到由于空间的限制，一个长久运行的事务被挂起，也没有AFTER SUSPEND触发器去解决这个问题。你也注意到关键事务快达到RESUMABLE_TIMEOUT 的值 使用DBMS_RESUMABLE.SET_SESSION_TIMEOUT程序包来延长超时的会话，来解决问题 520.Which of the following are not disabled by default? E. Schedule Answer: E 521.You notice that a job in a chain has not completed on a nonconstrained非约束 RAC database. Which of these are valid reasons why that might occur? C. The job affinity is to an instance and that instance is unavailable. C、 这个任务存活在其中一个实例上，而这个实例是无效的不运行的 如果把JOB定义在INSTANCE级别上，JOB将运行在指定的实例上 522.The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements? F. All of the above Answer: F NLS_LANGUAGE specifies the default conventions约定 for the following session characteristics: Language for server messages Language for day and month names and their abbreviations (specified in the sql functions TO_CHAR and TO_DATE) Symbols for equivalents of AM,PM,AD,and BC. (A.M.,P.M.,A.D.,and B.C. are valid only if NLS_LANGUAGE is set to AMERICAN.) Default sorting sequence for character data when ORDER BY is specified. (GROUP BY uses a binary sort unless ORDER BY is specified.) Writing direction Affirmative and negative response strings (for example,YES and NO) 523.The NLS_TERRITORY地域 parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.) A. Date format 日期格式 B. Decimal character 十进制分隔符 C. Group separator 组分隔符 524.What are three benefits of using ASM? (Choose three.) A. Ease of disk administration and maintenance B. Load balancing across physical disks C. Software RAID-1 data redundancy with double or triple mirrors 525.What components are present in an ASM instance? (Choose three.) A. SGA B. Database processes C. Database datafiles D. Control files E. Database parameter file or spfile Answer: ABE 526.Which of the following is a benefit of ASM fast disk resync? A. Failed disks are taken offline immediately but are not dropped. 527.What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation? C. The ASM rebalance operation will be parallelized and should complete in a shorter amount of time. 528.What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group? E. 1MB default,64MB maximum Answer: E 529.Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup? B. ASM_DISKGROUP 530.When an ASM instance receives a SHUTDOWN NORMAL command,what command does it pass on to all database instances that rely on the ASM instances disk groups? C. ABORT 531.When starting up your ASM instance,you receive the following error: ora-15063 insufficient 不足的 D. The ASM_DISKSTRING parameter is not set; therefore disk discovery is not possible. 532.As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database.增加冗余 Using ASM,you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you,unfortunately). ASM数据有最大冗余 Which of the following commands would create a disk group that would offer the maximum in data redundancy? C. CREATE DISKGROUP dg_alliance1 HIGH REDUNDANCY failgroup diskcontrol1 DISK 'c:\oracle\asm_disk\_file_disk1' NAME file_ disk1 failgroup diskcontrol2 DISK ' c:\oracle\asm_disk\_file_disk2' NAME file_ disk2 failgroup diskcontrol2 DISK ' c:\oracle\asm_disk\_file_disk3' NAME file_ disk3; 题中说要provide for the greatest amount of redundancy for your ASM data 即使用 最高级别的冗余来创建磁盘组 指定冗余度，有三个选择：HIGH(高度冗余>三路)、NORMAL(标准冗余--双路)和XTERNAL(外部存储冗余)； 533.You want to migrate your database to ASM,so you have done a clean shutdown,made a closed backup of the entire You wa database,noted the location of your control files and online redo log files,and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion转换. Using the following steps,what is the correct order in which the following RMAN commands should be executed? 1. STARTUP NOMOUNT 2. ALTER DATABASE OPEN RESETLOGS 3. sql "ALTER DATABASE RENAME,logfile1 path TO,+dgrp4," # plus all other logfiles 4. SWITCH DATABASE TO COPY 5. BACKUP AS COPY DATABASE FORMAT,+dgrp4 6. ALTER DATABASE MOUNT 7. RESTORE CONTROLFILE FROM,controlfile_location 迁移数据库到ASM B. 1,7,6,5,4,2 534.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed? B. Issue the ALTER DISKGROUP ... UNDROP DISKS command 535.To reference existing ASM files,you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A,the database name is DEV19,and the ASM file that you want to reference is a datafile for the USERS02 tablespace. Which of the following is a valid ASM filename for this ASM file? B. +DG2A/dev19/datafile/users02.701.2 ASM文件的全文件名和路径 536.Which background process coordinates the rebalance activity for disk groups? C. RBAL RBAL，此进程负责规划和协调磁盘组的重新平衡活动。 537.On the development database rac0,there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each,and the rest are 6GB each. An existing disk group +DATA1,of NORMAL REDUNDANCY,uses /dev/raw/raw1 and /dev/raw/raw2. Which series of the following commands will drop one of the failure groups for +DATA1,create a new disk group +DATA2 using two of the remaining four raw devices,and then cancel the drop operation from +DATA1? A. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001; CREATE DISKGROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK,/dev/raw/raw3 FAILGROUP DATA1B DISK,/dev/raw/raw4; ALTER DISKGROUP DATA1 UNDROP DISKS; 538.Which type of database file is spread across all disks in a disk group? A. All types of files are spread across all disks in the disk group. 539.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed? A. Issue the ALTER DISKGROUP ... ADD DISK command. 540.Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation? A. ADD DIRECTORY V$ASM_OPERATION是记录当前磁盘的操作信息。 B,C,D,E都会涉及到磁盘的操作，只有A是涉及目录的操作，所以选A 541.If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string,what happens to disks that are already a part of the same or another disk group? D. The other disks,already part of the disk group,are ignored. Answer: D 542.You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch. What do you do? 磁盘控制器坏了 ，磁盘正常 24小时后替换控制器，不希望重头重建磁盘 E. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours. Answer: E 设置失败修复时间超过24小时 543.As the DBA,you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.) sql> select group_number,name,state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED A. The DGROUP1 disk group was unmounted by another DBA. E. A disk associated with a disk group was discovered after the ASM instance initially opened. Answer: AE 544.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? 非归档模式下的 备份 不能关闭数据库 C. You will have to wait until you can shut down the database to perform the backup. 等待 545.When performing an online backup,what is the proper order of the following steps? 在线备份的正常步骤 A. Issue the alter database end backup command. B. Back up the archived redo logs. C. Issue the alter database begin backup command. D. Back up the database files. E. Determine the beginning log sequence number. F. Determine the ending log sequence number. G. Force a log switch with the alter system switch logfile command. e c d a g f b Answer ：D 记下开始的日志序列号 然后开始备份数据库 sys@TEST1107> alter database begin backup; Database altered. 开始讲数据库置为备份状态 OS级拷贝文件 结束数据库的备份状态 sys@TEST1107> alter database end backup; Database altered. 切换日志，使日志归档 sys@TEST1107> alter system switch logfile; System altered. 记下结束的日志序列号 在OS级别拷贝归档日志文件 546.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; 547.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? B. Back up all the archived redo logs generated since the 8 a.m. backup. 548.What are the different logging modes available in Oracle Database 11g? (Choose two.) B. NOARCHIVELOG mode E. ARCHIVELOG mode Answer: BE 549.Which is the correct command to put the database in ARCHIVELOG mode? A. alter database archivelog 550.What is the correct order of steps to perform an online database backup? A. alter database begin backup; B. alter database end backup; C. Back up the database datafiles. D. Back up the archive log files. E. alter system switch logfile; a c b e d Answer: E 551.Which command will result in a trace file being created with the create controlfile command contained in it? B. alter database backup controlfile to trace; 备份控制文件到跟踪文件 552.Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode? C. alter tablespace DAVE_TBS begin backup; 553.Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database? C. No,the backup is not usable in any way. C 每个星期天Unix系统管理员有个工作，去执行整个Unix系统完全备份，你的数据库运行在该系统上面。这份备份能 用于你的数据库的备份和恢复吗？ C. No,the backup is not usable in any way. 不， 备份无论如何都不可以使用 554.Which is not a valid way of backing up a control file? 不是备份方式 B. Copying the existing control file of the database to the backup location during a hot backup 热拷贝无用 555.Which of the following parameters defines the location where Oracle should create archived redo logs? D. LOG_ARCHIVE_DEST_1 Answer: D 556.Archived redo logs can be copied to more than one destination by Oracle. A. True B. False Answer: A 557.What will be the result of the following configuration? Log_archive_dest_1=location=c:\oracle\arch\mydb Log_archive_dest_2=location=z:\oracle\arch\mydb C. Archived redo logs will be created in two different locations by the ARCH process. 558.Which view provides information on the backup status of the datafiles in the database? A. V$BACKUP 559.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? 在线备份模式下 强制关闭 重启发生什么 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. 560.What is the proper command to shut down the database in a consistent manner?一致的方式 D. shutdown immediate 561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alter database archivelog? A. The alter database archivelog command will fail. 562.Your archive-log destination directory runs out of space.归档日志目的目录空间用完 What is the impact of this on the database? E. Once Oracle has cycled through all online redo logs,it will stop processing any DML or DDL until the out-of-space condition is corrected. 停止任何DML操作 Answer: E 563.How many individual archive-log destination directories are supported by Oracle Database11g? 11g支持多少个独立的归档日志路径 C. 10 564.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? 1. Shut down the database. 2. Take the users_01.dbf datafile offline with the alter database command. 3. Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4. Restore all users tablespace-related datafiles from backup media. 5. Issue the recover tablespace users command. 6. Issue the recover datafile users_01.dbf command. 7. Start up the database. 8. Bring the users_01.dbf datafile online with the alter database command. A.1,7 B.2,8 C.1,2,7 D.1,8 E.2,7 Answer: B 565.As soon as you discover that you have lost an online redo log,if the database is still functioning,what should be your first action? 丢失一个联机日志 仍然工作者 D. Checkpoint the database 如果在线日志丢失，第一就是切换日志，不让继续写在丢失的日志上。 566.You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation? A. Mount the database with the startup mount command. B. Take the SYSTEM datafile offline with the alter database command. C. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs. D. Restore all SYSTEM tablespace-related datafiles from backup media. E. Issue the recover tablespace SYSTEM command. F. Issue the recover datafile SYSTEM_01.dbf command. G. Open the database with the alter database open command. H. Open the database with the alter database open resetlogs command. 恢复SYSTEM表空间的数据文件 d a e g I. a,c,f,g J. b,d,e,h K. a,b,g L. d,a,g M. b,g Answer: D 567.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 e g L. a关闭数据库,e创建新的副本,g启动数据库 Answer: E 568.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.) A. Database datafiles B. Control files C. Archived redo logs D. Online redo logs E. Flashback logs 非归档模式下的全备份需要 数据文件 控制文件 在线日志文件 ABD 569.Which are the correct steps,in order,to deal with the loss of an online redo log if the database has not yet crashed? 丢失一个联机日志 A. Issue a checkpoint. B. Shut down the database. C. Issue an alter database open command to open the database. D. Startup mount the database. E. Issue an alter database clear logfile command. F. Recover all database datafiles. C. a,c 执行检查点 --关闭数据库--mount启动--执行清理日志文件---执行打开命令 570.What methods of point-in-time recovery are available? (Choose all that apply.) A. Change-based B. Cancel-based C. Time-based D. Sequence number-based E. Transaction number-based Answer: ABCD 571.Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.) A. Database datafiles B. Online redo logs C. Archived redo logs D. Backup control file E. Control file from a backup Answer: ACD 归档模式下的全恢复 数据文件 归档日志文件 备份的控制文件 572.What is the proper正当的 procedure过程 to recover a lost tempfile? E. Re-create the tempfile with the alter tablespace command. Answer: E 重新创建临时文件 573.Upon starting your database,you receive the following error: sql> startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 。 ORA-00313: open Failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log' ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log' You can choose from the following steps: Which is the correct order of these steps in this case? A. Restore the database datafiles. B. Issue the alter database clear unarchived logfile group 1 command. C. Issue the alter database open command. D. Issue the alter database open resetlogs command. E. Recover the database using point-in-time recovery. F. Issue the Startup Mount command to mount the database. G. Back up the database. J. f,g mount数据库 --- 清理未归档的日志文件---打开数据库---备份数据库 Answer: C 574.A user sends you an email with the following error message: create table idtable(id number) * ERROR at line 1: ORA- 01110: data file 4:,/oracle01/oradata/orcl/users01.dbf ORA-27041: 01116: error in opening database file 4 ORA-unable to open file Linux Error: 2: No such file or directory Additional information: 3 You can choose from the following steps: Which is the correct order of these steps in this case? 丢失数据文件的正确步骤 A. Restore the missing database datafiles. B. Take the missing datafile offline. C. Shut down the database. D. Issue the recover tablespace USERS command. E. Issue the Startup Mount command to mount the database. F. Bring the USERS tablespace online. G. Issue the alter database open command. b,f 将丢失的数据文件离线---还原丢失的文件---恢复表空间---表空间上线 Answer: A 575.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? 控制文件备份到跟踪文件中 D. You will use the noresetlogs version of the create controlfile command. 使用norestlogs 重做控制文件 576.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? B. Tell them that their request cannot be met with the current backup strategy. 因为数据库是非归档模式，所有不能恢复 577.What methods are available to recover lost control files? (Choose all that apply.) C. The create controlfile command. D. The restore controlfile sql*Plus command 丢失一个控制文件就OS级别cp 全部丢失就restore或者重新创建 578.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: 归档模式 丢失3个数据文件 一个system 两个user空间的 恢复步骤 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. a b e c 还原restore丢失的3个数据文件 --- mount数据库---恢复recover数据库---打开数据库 H. a,c I. b,d J. a,c K. b,g,f L. a,f Answer: A 579.You have lost all your online redo logs. As a result,your database has crashed. You have tried to restart the database and clear the online redo log files,but when you try to open the database you get the following error. sql> startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313: open Failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1:,/oracle01/oradata/orcl/redo02a.log ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 ORA-00312: online log 2 thread 1:,/oracle01/oradata/orcl/redo02.log ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 sql> alter database clear logfile group 2; alter database clear logfile group 2 * ERROR at line 1: ORA-01624: log 2 needed for crash recovery of instance orcl (thread 1) ORA-00312: online log 2 thread 1:,/oracle01/oradata/orcl/redo02.log ORA-00312: online log 2 thread 1:,/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error? 丢失所有联机日志， A. Issue the recover database redo logs command. B. Issue the Startup Mount command to mount the database. C. Restore the last full database backup. D. Perform a point-in-time recovery,applying all archived redo logs that are available. E. Restore all archived redo logs generated during and after the last full database backup. F. Open the database using the alter database open resetlogs command. G. Issue the alter database open command. H. b,f I. e,f J. e,g K. b,g L. c,f Answer: E 还原全部数据库c---还原所有的在全备份之后的归档日志文件e---mount数据库b---执行基于时间点的恢复d---- resetlogs 打开数据库 580.What does the SCN represent? A. The system change number,which is a point in time relative to transactions within a given database. SCN（System Change Number 简称 SCN）是当Oracle数据库更新后，由DBMS自动维护去累积递增的一个数字。在Oracle中，有四种SCN，分别为：系统检查点SCN、数据文件检查点SCN、启动SCN、终止SCN。 系统检查点scn 当一个检查点动作完成后，Oracle就把系统检查点的SCN存储到控制文件中。 数据文件检查点scn 当一个检查点动作完成后，Oracle就把每个数据文件的scn单独存放在控制文件中。 启动scn Oracle把这个检查点的scn存储在每个数据文件的文件头中，这个值称为启动scn，因为它用于在数据库实例启动时，检查是否需要执行数据库恢复。 终止scn 每个数据文件的终止scn都存储在控制文件中。 581.You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? A. Restore and recover the datafile. 582.You are trying to recover your database. During the recovery process,you receive the following error: ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289: suggestion: /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-00280: change 5033391 for thread 1 is in sequence #11 ORA-00278: log file,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log: {<RET>=suggested | filename | AUTO | CANCEL} ORA-00308: cannot open archived log,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 How do you respond to this error? (Choose two.) A. Restore the archived redo log that is missing and attempt recovery again. 还原归档日志 C. Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo log if available. 恢复需要redo的日志不可用，尝试应用所有的联机日志 Answer: AC 583.During recovery,you need to know if log sequence 11 is in the online redo logs,and if so,you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.) A. V$LOGFILE E. V$LOG Answer: AE 确定日志序列号，和日志文件名称 的视图 584.How is block-change tracking enabled? A. With alter database enable block change tracking --Block change tracking 会记录data file里每个block的update 信息，这些tracking信息保存在tracking 文件里。 当启动block change tracking 后，RMAN 使用trackingfile里的信息，只读取改变的block信息，而不用在对整个data file进行扫描，从而提高了RMAN 备份的性能。 --block change tracking 文件是针对整个数据库，默认情况下，changetracking file 会作为Oracle managed file，在DB_CREATE_FILE_DEST指定的目录下创建。 可以放到放到其他的目录。 Oracle 不建议使用rawdevice 来存放change tracking file -数据库在open 或者 mounted 状态都可以启用blockchange tracking. sql> alter database enable block changetracking; Database altered. 在使用RMAN 增量备份的情况下，启动block change tracking，在做增量备份时会缩短RMAN 备份的时间， 因为不用扫描整个data file。 但是block tracking 也会带来其他的一些开销。 所以要根据实际情况决定是否启用block change tracking。 585.What type of backup is stored in a proprietary RMAN format? A. Backup set 586.Consider the following command: Backup database plus archivelog delete input; How many backup sets would be created by this command if the following were true: Control-file a NN uto backups were enabled. NN The size of backup sets was not restricted. NN One channel was allocated. D. 4 几个备份集 4个 解析： 这四个分别是 数据文件 控制文件 服务器参数文件 以及归档日志文件 当你开启自动备份控制文件时，默认会自动备份spfile 587.Compressed backups work with which of the following commands? C. backup 压缩备份 588.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? D. backup database plus archivelog delete input 备份之后 删除归档日志 589.Which of the following best describes a full backup? D. All the used blocks in a datafile Answer: D 全备所有用过的块 590.Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower? 只备份修改过的数据库 ，相同或低级备份之后 A. Differential incremental backup 差异增量备份 591.Which type of backup must be performed first with an incremental backup? B. Level 0 增量备份之前必须要全备份 592.Which backup option defines a user-defined name for a backup? C. TAG 备份增加标签 593.Given the following steps,which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode? 非归档模式下的数据备份 登录RMAN ---关闭数据库---mount数据库rman--备份数据库---打开数据库 A. shutdown immediate from RMAN B. Log into RMAN C. startup mount from RMAN D. backup database E. alter database open F. backup database plus archivelog delete input b a c d e Answer: E 594.Which of the following most closely represents an image copy?下列哪个最密切的代表一个图像拷贝？ A. Unix cp command of a file B. Bit-by-bit copy of a file C. Windows COPY command of a file D. All of the above Answer: D image copy实际上就是文件的拷贝，ABC都属于拷贝。故选D 595.Which dynamic view displays the status of block-change tracking? B. V$BLOCK_CHANGE_TRACKING 596.What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels? A. Channel failover 在使用三种不同的通道的备份中三个备份设备之一失效的情况下，什么特性发挥作用以帮助确保完成备 份？ A. Channel failover通道失效转移 597.What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device? 永久设置，备份都被写入到磁带设备 C. CONFIGURE DEFAULT DEVICE TYPE TO SBT 598.The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.) C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog. E. The initialization parameter should never be set to 0 if you are using RMAN. Answer: CE Oracle基于RMAN的备份方式，可分为以catalog 和nocatalog的两种方式进行备份管理。其中，catalog的方式需要一个catalog目录数据库，这个数据库一般运行在另外一台服务器上，这种方式可以用于用户有多个Oracle数据库的环境，同时对数据库的备份恢复信息也可以长久的保存，也就是RMAN把对数据库A的备份恢复记录保留在catalog目录数据库中。 而基于nocatalog的备份管理方式，是将RMAN的备份信息放在控制文件中，由于控制文件的大小不能无限增大，所以在控制文件中只能保留一段时间的备份与恢复信息，而这个时间的控制，由一个参数为参考依据，这个参数就是control_file_record_keep_time，通过在sqlplus中show parameter control_file_record_keep_time 可以查到这个参数的值，默认为7天。 599.Given the following steps,which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled? A. backup archivelog all; B. backup database all; C. backup controlfile; D. backup archivelog,database,controlfile delete input; E. backup database plus archivelog delete input F. e G. a,c H. d I. b,c J. b,e Answer: A 600.Which of the following statements are true about the BACKUP command? (Choose all that apply.) B. The BACKUP command can improve performance by multiplexing backup files. C. The BACKUP can take advantage of the block-change tracking capability. Answer: BC 601.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? (Choose two) C. You must ensure that the SALES database is mounted or open D. You must have full or level 0 backups for RMAN to restore blocks Answer: CD 块介质恢复 执行这个操作的先决条件