oracle11g OCP 认证 1Z0-053考试笔记6

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