Oracle 053 595-667译文

QUESTION NO:595

Examine the followingscenario:

- Database is running inARCHIVELOG mode.

- Complete consistentbackup is taken every Sunday.

- On Tuesday theinstance terminates abnormally because the disk on which control files are locatedgets corrupted

- The disk having activeonline redo log files is also corrupted.

- The hardware isrepaired and the paths for online redo log files and control files are stillvalid.

Which option would youuse to perform the recovery of database till the point of failure?

检查下列场景：

-数据库运行在archivelog模式

-完全一致性的备份每周日发生

-周2实例异常中断（因为控制文件位于的磁盘已经损坏）

-有活动online 重做日志的磁盘也损坏

-硬件被修复和在线重做日志文件路径和控制文件仍然有效。

 

你使用哪个选项去执行数据库的恢复直到失败点：

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

B. Restore the latest whole backup, perform incompleterecovery, and open the database with the RESETLOGS option.

C. Restore the latest backups control file, perform completerecovery, and open the database with the RESETLOGS option.

D. Restore the latest backup controlfile, perform incomplete recovery using backup control file,and open thedatabase with the RESETLOG option.

 

Explanation:

QUESTION NO:596

You are managing a 24*7database. The backup strategy for the database is to perform user managed backups.Identify two prerequisites to perform the backups. (Choose two.)

你正在管理一个24*7数据库。数据库的备份策略是去执行用户管理的备份。识别执行备份的2个先决条件。

A. The database must be opened in restricted mode.

B. The database must be configured torun in ARCHIVELOG mode.

C. The tablespaces are required to bein backup mode before taking the backup.

D. The tablespaces are required to be in read-only modebefore taking the backup

 

Explanation:

QUESTION NO:597

Examine the following commands and their output:

SQL> SELECTename, sal  FROM  emp WHERE ename='JAMES';

 ENAME SAL JAMES 1050

SQL> UPDATE empSET sal=sal+sal*1.2 WHERE ename='JAMES';

1 row updated.

SQL> SELECTename, sal FROM emp WHERE ename='JAMES'; ENAME SAL JAMES 2310

View the exhibit andexamine the Flashback Version Query that was executed after the preceding commands.

What could be thepossible cause for the query not displaying any row?

Exhibit:

A. Flashback logging is not enabled for the database.

B. The changes made to the table arenot committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

 

Explanation:

QUESTION NO:598

Using the LIST commandin Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed? (Choose two.)

使用list命令（在RMAN）,列举RMAN仓储中的信息？

A. Stored scripts in the recoverycatalog

B. Backups that can be deleted from disk

C. Backup sets and images copies that are obsolete

D. Backups that do not have theAVAILABLE status in the RMAN repository

 

Explanation:

Section: Backup, Recovery & Recovery Manager (RMAN)

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28273/rcmsynta027.htm#i82460

Prerequisites

Execute LIST only at theRMAN prompt. Either of the following conditions must be met:

- RMAN must be connectedto a target database. If RMAN is not connected to a recovery catalog,

and if

you are not executingthe LIST FAILURE command, then the target database must be mounted or

open. If RMAN isconnected to a recovery catalog, then the target database instance must be

started.

- RMAN must be connectedto a recovery catalog and SET DBID must have been run.

Usage Notes

With the exception ofLIST FAILURE, the LIST command displays the backups and copies against

which you can runCROSSCHECK and DELETE commands. The LIST FAILURE command

displays failuresagainst which you can run the ADVISE FAILURE and REPAIR FAILURE

commands.

"RMAN Backups in aData Guard Environment" explains how RMAN handles backups in a Data

Guard environment. Ingeneral, RMAN considers tape backups created on one database in the

environment asaccessible to all databases in the environment, whereas disk backups are

accessible only to thedatabase that created them. In a Data Guard environment, LIST displays

those files that areaccessible to the connected target database. RMAN prints the LIST output to

either standard outputor the message log, but not to both at the same time.

Oracle Press1Z0-053 Exam Guide, Chapter 4:Creating RMAN Backups

The LIST commanddisplays information about backupsets and image copies in the repository and

can also store thecontents of scripts stored in the repository catalog.

Another variation on theLIST command is LIST FAILURE, which displays database failures; LIST

FAILURE, ADVISE FAILURE,and REPAIR FAILURE

 

 

QUESTION NO:599

To accomplishuser-managed backup for the USERS tablespace, you issued the following commandto put the database in backup mode:

SQL> ALTER TABLESPACE users BEGIN BACKUP;

While copying the fileto the backup destination a power outage caused the instance to te minate abnormally.

Which statement is trueabout the next database startup and the USERS tablespace?

A. The database will open, and the tablespace automaticallycomes out of the backup mode.

B. The database will be mounted, and recovery must beperformed on the USERS tablespace.

C. The database will be mounted, anddata files in the USERS tablespace must be taken out of the backup mode.

D. The database will not be mounted, and you must restoreall the data files for the USERS tablespace from the backup, and performrecovery.

 

Explanation:

http://www.informit.com/articles/article.aspx?p=30348

DatabaseCrashes During Hot Backup

There can be manyreasons for the database to crash during a hot backup-a power outage or

rebooting of the server,for example. If these were to happen during a hot backup, chances are

that tablespace would beleft in backup mode. In that case you must manually recover the files

involved, and therecovery operation would end the backup of tablespace. It's important to check

the status of the filesas soon as you restart the instance and end the backup for the tablespace if

it's in backup mode.

select a.name,b.statusfrom v$datafile a, v$backup b

where a.file#=b.file#and b.status='ACTIVE';

or

selecta.tablespace_name,a.file_name,b.status from dba_data_files a,

v$backup b

where a.file_id=b.file#and b.status='ACTIVE';

This statement listsfiles with ACTIVE status. If the file is in ACTIVE state, the corresponding

tablespace is in backupmode. The second statement gives the tablespace name also, but this

can't be used unless thedatabase is open. You need to end the backup mode of the tablespace

with the followingcommand:

alter tablespacetablespace_name end backup;

 

QUESTION NO:600

Examine the followingcommand used to perform incremental level 0 backup:

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

 

To enable the blockchange tracking, after the incremental level 0 backup you issued  the following command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USINGFILE '/mydir/rman_change_track.f';

 

To perform incrementallevel 1 cumulativebackup, you issued the following command:

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

 

Which two statements aretrue in the above situation? (Choose two.)

A. The block change tracking data willbe used only from the next incremental 0 backup. 块改变跟踪数据竟被使用，从下次增量0备份开始

B. The incremental backup will use change tracking data foraccomplishing the backup.

C. The incremental backup will not usechange tracking data for accomplishing the backup.这次增量备份将不使用改变跟踪数据

D. The block track file will scan all the blocks and createbitmap for all the blocks backed up in the level 0 backup.

 

Explanation:

Section: Backup, Recovery & Recovery Manager (RMAN)

http://www.pythian.com/documents/Pythian-oracle-block-change.pdf

After enabling changetracking, the first level 0 incremental backup still has to scan the entire

datafile, as the changetracking file does not yet reflect the status of the blocks. Subsequent

incremental backup that usethis level 0 as parent will take advantage of the change tracking file.

When some a chunk needsto be marked dirty for the first time after incremental backup, version

information in bitmapextent headers (X$KRCFBH) is initialized - XFLAGS is set to 2,

CURR_VERCNT andCURR_VERTIME

filled from datafiledescriptor. If file had no changes since last incremental backup - nothing is

written to the bitmap.There is no difference in handling different backup levels. Version is created

in the same way whetherits level 0, level 1 or level 4 backup. By the way, it seems that Oracle

10g documentationofficially mentions only support for levels 0 and 1. However, I checked

incremental backuplevels up to 4 and they do work (10.2.0.2).

Oracle Press1Z0-053 Exam Guide, Chapter 4:Creating RMAN Backups

The first incrementallevel 0 backup reads every block in the datafile, and subsequent incremental

level 1 backups use theblock change tracking file. No reference to create bitmap found.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm#i1032148

RMAN's change trackingfeature for incremental backups improves incremental backup

performance by recordingchanged blocks in each datafile in a change tracking file. If change

tracking is enabled,RMAN uses the change tracking file to identify changed blocks for incremental

backup, thus avoidingthe need to scan every block in the datafile. Using change tracking in no

way changes the commandsused to pe form incremental backups, and the change tracking files

themselves generallyrequire little maintenance after initial configuration.

QUESTION NO:601

You want to use theautomatic management of backup and recovery operations features foryourdatabase.

Which configuration mustyou set?

你想使用备份和恢复操作功能的自动管理功能。你必须设置哪个配置？

A. Enable the flash recovery area andspecify it as the archived redo log destination.

B. Disable the flash recovery area and start the databaseinstance in ARCHIVELOG mode.

C. Enable the flash recovery area but do not specify it asthe archived redo log destination.

D. Disable the flash recovery area and start the databaseinstance in NOARCHIVELOG mode.

 

Explanation:

QUESTION NO:602

Which three types of files can be automatically placed inthe flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)有哪3种类型的文件可以自动放置在flash recovery area

A. Alert log file

B. Archived redo log files

C. Control file autobackups

D. Server Parameter file (SPFILE)

E. Recovery Manager (RMAN) backup piece

 

Explanation:

http://www.pafumi.net/Flash_Recovery_Area.html

The Flash Recovery Area(FRA) is a unified storage location for all recovery related files and

activities in an Oracledatabase.

By defining one init.oraparameter, all RMAN backups, archive logs, control file autobackups, and

datafile copies are automaticallywritten to a specified files system or ASM Disk Group.

Oracle Press1Z0-053 Exam Guide, Chapter 4:Creating RMAN Backups

The following permanentitems are stored in the flash recovery area:

- Control file:Oracle stores one copy of the control file in the flash recovery area during aninstallation, which specifies the flash recovery area.

- Online redo logfiles You can store one mirrored copy from each redo log file group in theflash recovery area.

The following transientitems are stored in the flash recovery area:

- Archived redo logfiles When you configure the flash recovery area, one set of archived redo

log files is stored inthe flash recovery area.

- Flashback logs Flashbacklogs are stored in the flash recovery area when Flashback Database

is enabled.

- Control fileautomatic backups RMAN stores control file automatic backups in the flash

recovery area.

When RMAN backs up thefirst datafile, which is part of the SYSTEM tablespace, the control file is

automatically includedin the RMAN backup.

- Datafile copies Whenyou use the RMAN command BACKUP AS COPY, the datafile copies are

stored in the flashrecovery area by default.

- RMAN backupsets Filescreated with the BACKUP AS BACKUPSET command are stored in

the flash recovery area.

- RMAN files Bydefault, RMAN uses the flash recovery area as a staging area for backup and

recovery of the archivelog files from disk or tape.

QUESTION NO:603

 

Before a Flashback Tableoperation, you execute the following command:

ALTER TABLE employeesENABLE ROW MOVEMENT;

Why would you need thisto be executed?快速闪回表操作之前，你执行下列命令：

Alter table employees enable row movement;为什么你需要执行这个命令？

A. Because row IDs may change during the flashbackoperation

B. Because the object number changes after the flashbackoperation

C. Because the rows are retrieved from the recycle binduring the flashback operation

D. Because the table is moved forward and back to atemporary during the flashback opertion

 

Explanation:

QUESTION NO:604

The EMP table has somediscrepancy矛盾 in data entry with a particular employee ID.You execute the query as shown in the Exhibit to retrieve all versions of therow that exist between two SCNs.

View the Exhibit.

 

Which two statementsabout the results of the query shown in the Exhibit are correct? (Choose two.)

Exhibit:

A.  The LAST_SCN value in the first row is NULL, whichmeans that the versions of the row still exist at SCN 6636300.

Lat_scn值首行是null，意味着行的版本仍然存在 在SCN6636300

B. The LAST_SCN value in the second row in NULL, which meansthat the version of the row still exists at SCN 6636300.

C. The LAST_SCN value in the third row is 6636280, whichmeans that the version of row exists above SCN 6636280.

D. The LAST_SCN value in the second rowis NULL, which means that the version of the row no longer exists because itwas deleted.

 

Explanation:

Dunno -

ExhibitReference: Exhibit Located in1Z0-045 Exam - Exact Question/Answer

http://www.oracle-developer.net/display.php?id=320

 If we look at the VERSIONS_OPERATION column,we can see that the second record is actually the delete operation against thelast row

(specified by 'D').

B is Wrong because the record has been deleted.

D is Wrong because the NULL Value does NOT mean the rowno longer exists.

http://www.rampant-books.com/art_otn_flashback_tips.htm

The metadata also givesus an indication that the delete operation was the final version of this data.The end timestamp of the version is NULL which tells us that there is nosuperceding record.

Note that all thechanges to the row are shown here, even when the row was deleted and reinserted.The VERSION_OPERATION column shows what operation (Insert/Update/Delete) was performedon the row. This was done without any need of a history table or additionalcolumns.

 

QUESTION NO:605

A database instance isusing an Automatic Storage Management (ASM) instance, which has a disk group,DGROUP1, created as follows:

数据库实例使用一个ASM实例，有一个磁盘组DGROUP1

SQL> CREATEDISKGROUP dgroup1 NORMAL REDUNDANCY

FAILGROUP controller1DISK '/devices/diska1', '/devices/diska2'

FAILGROUPcontroller2 DISK '/devices/diskb1', '/devices/diskb2' ;

What happens when thewhole CONTROLLER1 Failure group is damaged?

A. The transactions that use the disk group will halt.

B. The mirroring of allocation units occurs within theCONTROLLER2 failure group.

C. The data in the CONTROLLER1 failuregroup is shifted to the CONTROLLER2 failure group and implicit明确的 rebalancing istriggered.

D. The ASM does not mirror any data and newly allocatedprimary allocation units (AU) are stored in the CONTROLLER2 failure group.

 

Explanation:

Section: Database Architecture & Resource Management, RAC, ASM

Oracle Press1Z0-053 Exam Guide, Chapter 1:Database Architecture and ASM

Whenever you change theconfiguration of a disk group-whether you are adding or removing a failuregroup or a disk within a failure group-dynamic rebalancing occurs automaticallyto  proportionally reallocate data fromother members of the disk group to the new member of the disk

group. This rebalanceoccurs