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 while the database is online and available to users. Any impact to

ongoing database I/O canbe controlled by adjusting the value of the initialization parameter

ASM_POWER_LIMIT to alower value.

QUESTION NO:606

 

You want to set thefollowing initialization parameters for your database instance:

LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch'

LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch'

LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch'

LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'

Identify the statementthat correctly describes this setting.

A. The MANDATORY location must be a flash recovery area.

B. The optional destinations may not use the flash recoveryarea.

C. This setting is not allowed because the first destinationis not set as MANDATORY.

D. The online redo log file is notallowed to be overwritten if the archived log cannot be created in  the fourth destination.

 

Explanation:

QUESTION NO:607

View the Exhibit andnote the contents of V$DIAG_INFO.Which statement is true about the ADR?

Exhibit:

A. The text alert log file will beavailable in Diag Trace

B. A copy alert log file will be kept in Diag Incident forevery incident.

C. The XML version of the alert log file will be availablein Diag Trace.

D. An Automatic Database Diagnostic Management (ADDM) reportis generated and stored in the

Health Monitor wheneveran incident occurs.

 

Explanation:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/diag001.htm

The V$DIAG_INFO viewlists all important ADR locations for the current Oracle Database

instance.

The following tabledescribes some of the information displayed by this view.

Oracle 1z0-053 Exam

"Pass Any Exam.Any Time." - www.actualtests.com 309

The alert log is an XMLfile that is a chronological log of database messages and errors. It is

stored in the ADR andincludes messages about the following:

- Critical errors(incidents)

- Administrativeoperations, such as starting up or shutting down the database, recovering

the database, creatingor dropping a tablespace, and others.

- Errors duringautomatic refresh of a materialized view

- Other database events

You can view the alertlog in text format (with the XML tags stripped) with Enterprise Manager and

with the ADRCI utility.There is also a text-formatted version of the alert log stored in the ADR for

backward compatibility.However, Oracle recommends that any parsing of the alert log contents be

done with theXML-formatted version, because the text format is unstructured and may change

from release to release.In 11g the default alert log is now in xml format, text is provided for

backward compatibility.

QUESTION NO:608

You are using thecontrol file to maintain information about the database backups that are being performedby Recovery Manager (RMAN). Identify two scenarios is which you must have a recoverycatalog. (Choose two.)

你正在使用控制文件去维护数据库备份的信息（通过RMAN执行）。识别2个场景，你必须有一个recovery catalog。

A. To store the backup information ofmultiple database

B. To restrict the amount of space that is used by thebackups

C. To maintain a backup for a certain time is set by theCONTROL_FILE_RECORD_KEEP_TIME

parameter.

D. To list the data files that were ina target database at a given time by using the AT option of REPORT SCHEMAcommand.  通过使用report schema命令的at选项来列举给定时间的目标库的数据文件。

 

Explanation:

SYBEX1Z0-053 Study Guide, Chapter 5:Using the RMAN Recovery Catalog

Identifysituations that will require the RMAN recovery catalog. Understand that the recovery

catalog is largelyoptional. A recovery catalog will be needed for storing scripts, and it willbe

required ifyou want to store backup records longer than one year or beyond the setting of

CONTROL_FILE_RECORD_KEEP_TIME.Oracle Press 1Z0-053 Exam Guide, Chapter 3:

Creating and Maintainingan RMAN Catalog Finally, using a recovery catalog permits you to use

the following RMANcommands: - BACKUP...KEEP UNTIL TIME Keep a backup for a period of

time that differs fromthe configured retention policy.

- BACKUP...KEEP FOREVER Keep a backup indefinitely or untilyou manually remove it.

- REPORT SCHEMA...AT Show the structure of the database ata specific time in the past.

QUESTION NO:609

 

 

You have enabled backupoptimization for the RMAN environment. Identify two criteria on which RMAN willskip the file, if it has already been backed up. (Choose two.)你已经启用了RMAN环境下的备份优化。识别两个准则，RMAN跳过此文件（如果他已经备份过）

A. The data file backup is done with multiple channels

B. The data files is in the read-write mode after beingbacked up in the read only mode

C. The backup was taken after the datafiles was taken offline-normal or is in the read only mode 在数据文件offline-normal或者处于readonly时，备份发生

D. The data file backup complies with遵从服从 the backretention policy and the backup duplexing feture  数据文件备份遵从备份保留策略和备份转接特征

 

Explanation:

QUESTION NO:610

You need to maintain arecord of all transactions on some tables for at least three years. Automaticundo management is enabled for the database.

What must you doaccomplish this task?

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where thetables are stored.

D. Create Flashback Data Archive andenable Flashback Data Archive for specific tables

 

Explanation:

QUESTION NO:611？？？理解

You issued the followingcommands to configure setting in RMAN;

 

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FORDEVICE TYPE sbt TO 2;

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE sbt TO 2;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FORDEVICE TYPE DISK TO 2;

Then you issued thefollowing command to take the backup:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;理解

Which statement is trueabout the execution of the above command?

A. The backup will terminate because the FORMAT clause wasnot configured for the channel

B. It backs up two copies of data files to tape and disk,and two copies of archived log file on tape

C. It backs up the data files and archived log files todisk, making two copies of each data file and archived log file

D. It backs up the data files andarchived log files to tape, making two copies of each data file and archivedlog file

 

Explanation:

QUESTION NO:612

You work with a newlycreated database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide tocollect

recommendations that canbe implemented to improve application performance.

What action must youtake to achieve this?

A. Run Segment Advisor

B. Run the SQL Tuning Advisor (STA)

C. Run the Automatic Workload Repository (AWR) report

D. Run the SQL Access Advisor with ahypothetical假想的 workload

 

Explanation:

QUESTION NO:613？？？为啥不是ADF？？

 

Your database is runningin ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERStablespace is damaged and you need to recover the file until the point offailure. The

backup for the datafileis available. Which three files would be used in the user-managed recovery

process performed by thedatabase administrator (DBA)? (Choose Three)

A. Redo logs

B. Control file

C. The latest backup of only thedamaged data file

D. The latest backup of all the data file in the USERStablespace

E. Temporary files of temporary tablespace

F. Archive Logs since the latest backupto point of failure

 

Explanation:

QUESTION NO:614

Which options must youconfigure while performing an automated Tablespace Point-in-Time  Recovery (TSPITR) by using Recovery Manager(RMAN)?

A. New channels for restore and recovery tasks

B. New name for the data files of the tablespace

C. Auxiliary name for the data files of the tablespace

D. Auxiliary destinations for anauxiliary set of data files

 

Explanation:

Use the AUXILIARYDESTINATION parameter to set a location for RMAN to use for the auxiliary

set datafiles. Theauxiliary destination must be a location on disk with enough space to hold

auxiliary set datafiles.Even if you use other techniques to rename some or all of the auxiliary set

datafiles, specifying anAUXILIARY DESTINATION parameter provides a default location for

auxiliary set datafilesfor which names are not specified. TSPITR will not fail if you inadvertently do

not provide names forall auxiliary set datafiles.

Oracle Press1Z0-053 Exam Guide,

 Chapter7: Miscellaneous RMAN Features

Auxiliarydestination A temporary location tostore the auxiliary set of files, including online and

archived redo log files,and a copy of the control file during created the recovery process.

 

QUESTION NO:615

In Recovery Manager(RMAN), you are taking image copies of the data files of your production databaseand rolling them forward at regular intervals. You attempt to restart yourdatabase. After a regular maintenance task, you realize that one of the datafiles that belongs to the USERS tablespace is damaged and you need to recoverthe data file by using the image copy. Because a

media failure caused thedata file to be damaged, you want to place the data file in a different locationwhile resto ing the file.

Which option must youconsider for this task?

在RMAN，你可以进行image copy（你生产库的数据文件，前滚tameness岛一个定期间隔）。你尝试重启你的数据库。一个定期的维护任务之后，你认识到users表空间中的某个数据文件损坏，你需要使用imagecopy来进行数据文件的恢复。因为一个介质管理失败引起数据文件损坏，你想放置数据文件到不同的位置（当还原文件时）。

哪个选项你必须考虑为这个任务？

A. using only the RMAN SWITCH command to set the newlocation for the data file

B. placing the database in the MOUNT state for the restoreand recovery operations.

C. using an RMAN RUN block with the SETNEWNAME and then the SWITCH command.

D. configuring two channels: one for the restore operationand the other for the recovery operation

 

Explanation:

http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc2.htm

RMAN automates theprocedure for restoring files. You do not need to go into the operating

system, locate thebackup or copy that you want to use, and manually copy files into the

appropriate directories.When you issue a RESTORE command, RMAN directs a server session

to restore the correctbackups and copies to either: The default location, overwriting the files with

the same name currentlythere A new location, which you can specify with the SET NEWNAME

command To restore adatafile, either mount the database or keep it open and take the datafile to

be restored offline.When RMAN performs a restore, the RESTORE command creates the

restored files asdatafile copies and records them in the repository. The following tabledescribes

the behavior of theRESTORE, SET NEWNAME, and SWITCH commands.

For example, if yourestore datafile ?/oradata/trgt/tools01.dbf to its default location, then RMAN

restores the file?/oradata/trgt/tools01.dbf and overwrites any file that it finds with the same

filename. If you run aSET NEWNAME command before you restore a file, then RMAN creates a

datafile copy with thename that you specify. For example, assume that you run the following

commands:

SET NEWNAME FOR DATAFILE'?/oradata/trgt/tools01.dbf' TO '/tmp/tools01.dbf';

RESTORE DATAFILE'?/oradata/trgt/tools01.dbf';

In this case, RMANcreates a datafile copy of ?/oradata/trgt/tools01.dbf named /tmp/tools01.dbf

and records it in therepository.

 

To change the name fordatafile ?/oradata/trgt/tools01.dbf to /tmp/tools01.dbf in the control file,run

a SWITCH command so thatRMAN considers the restored file as the current database file. For

example:

SWITCH DATAFILE'/tmp/tools01.dbf' TO DATAFILECOPY '?/oradata/trgt/tools01.dbf';

The SWITCH command isequivalent to the SQL statement ALTER DATABASE RENAME FILE.

 

 

QUESTION NO:616

The database is runningin the ARCHIVELOGmode. It has three redolog groups with one member each. One of the redo log groups has becomecorrupted. You have issued the following

command during therecovery of a damaged redo log file:

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Which action should youperform immediately after using this command?

A. You should perform a log switch

B. You should make a backup of thedatabase

C. You should switch the database to the NONARCHIVELOG mode

D. You should shut down the database instance and perform acomplete database recovery

 

Explanation:

SQL> ALTER DATABASECLEAR LOGFILE UNARCHIVED GROUP 3;

Immediately back up alldatafiles in the database with an operating system utility, so that you have

a backup you can use forcomplete recovery without relying on the cleared log group. For

example, enter:

% cp/disk1/oracle/dbs/*.dbf /disk2/backup

http://www.oracle-dba-online.com/managing_redo_logfiles.htm

This statement clearsthe corrupted redo logs and avoids archiving them. The cleared redo logs

are available for useeven though they were not archived. If you clear a log file that is needed for

recovery of a backup,then you can no longer recover from that backup. The database writes a

message in the alert logdescribing the backups from which you cannot recover.

QUESTION NO:617

 

Which option is bestpractice for creating a recovery catalog owner in the catalog database?哪个选项是创建一个recovery catalog属主（在catalog数据库中）的最佳实践？

A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to theowner

B. Allocating the SYSTEM tablespace as the defaulttablespace and granting the SYSDBA  privilegeto the user

C. Creating a new tablespace,allocating this as the default, and granting UNLIMITED QUOTA on  this tablespace to the user

D. Allocating the SYSAUX tablespace as the defaulttablespace and granting UNLIMITED QUOTA on this tablespace to the user

 

Explanation:

Section: Backup, Recovery & Recovery Manager (RMAN)

SQL> CREATE USER vpc1IDENTIFIED BY password

2 DEFAULT TABLESPACEvpcusers

3 QUOTA UNLIMITED ONvpcusers;

http://www.dba-oracle.com/real_application_clusters_rac_grid/recovery_catalog.html

The RMAN schema owner iscreated in the RMAN database using the following steps:

1. Start SQL*Plus andconnect as a user with administrator privileges to the database containing

the recovery catalog:

CONNECT SYS/oracle@catdbAS SYSDBA

2. Create a user andschema for the recovery catalog. For example, enter:

CREATE USER rmanIDENTIFIED BY cat

TEMPORARY TABLESPACEtemp

DEFAULT TABLESPACE tools

QUOTA UNLIMITED ONtools;

3. Grant therecovery_catalog_owner role to the user.

This role provides allof the privileges required to maintain and query the recovery catalog:

SQL> GRANTRECOVERY_CATALOG_OWNER TO rman; Once the owner user is created, the

RMAN recovery catalogschema can be added:

1. Connect to thedatabase that contains the catalog owner. For example, using the RMAN user

from the above example,enter the following from the operating system command line. The use of

the

CATALOG keyword tellsOracle this database contains the repository: % rman CATALOG

rman/cat@catdb

2. It is also possibleto connect from the RMAN utility prompt: % rman RMAN> CONNECT

CATALOG rman/cat@catdb

3. Now, the CREATECATALOG command can be run to create the catalog. The creation of the

catalog may take severalminutes. If the catalog tablespace is this user's default tablespace, the

command would look likethe following: CREATE CATALOG;

Each database that thecatalog will track must be registered.

 

1. Make sure therecovery catalog database is open.

2. Connect RMAN to boththe target database and recovery catalog database. For example, with a

catalog database ofRMANDB and user RMAN, owner of the catalog schema, and the target

database, AULT1, whichis the database to be backed up, database user SYS would issue: %

rman TARGETsys/oracle@ault1 CATALOG rman/cat@rmandb

3. Once connected, ifthe target database is not mounted, it should be opened or mounted:

RMAN> STARTUP; --or--RMAN> STARTUP MOUNT;

4. If this targetdatabase has not been registered, it should be registered in the connected

recovery catalog:RMAN> REGISTER DATABASE;

 

QUESTION NO:618

 

 

Which two statements aretrue about encrypting RMAN backup? (Choose two.)关于加密RMAN备份描述正确的是：

A. The transparent encryption ofbackups uses the encryption wallet备份的透明加密使用加密钱包

B. The database uses the same encryption key for everyencrypted backup

C. The password encryption of backupsonly uses the password while creating and restoring backup  备份的密码加密只用于当创建和还原备份时使用密码

D. If transparent encryption is configured, you cannot usethe SET ENCRYPTION BY PASSWORD command to make password-protected backups.

 

Explanation:

http://www.di.unipi.it/~ghelli/didattica/bdldoc/B19306_01/backup.102/b14191/rcmbackp006.htm

A)Transparent Encryption of Backups

This is the default modeand uses the Oracle wallet. A wallet is a password-protected container

used to storeauthentication and signing credentials, including private keys, certificates,and

trusted certificatesneeded by SSL.

C) PasswordEncryption of Backups

This mode uses onlypassword protection. You must provide a password when creating and

restoring encryptedbackups.

Dual ModeEncryption of Backups

Dual-mode encryptedbackups can be restored either transparently or by specifying a password.

When restoring adual-mode encrypted backup, you can use either the Oracle Encryption Wallet

or a password fordecryption.

 

QUESTION NO:619

View the Exhibit andexamine the output of the query in different times when the following commandruns in an

RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2;

The database has sevendata files. Why is the %_COMPLETE refreshed to 13.59 in the third output afterreaching 88.77?

 

Exhibit:

A. Because the progress is reported for each data file

B. Because the progress is reported foreach backup set

C. Because other RMAN sessions have issued the same BACKUPcommand

D. Because new data files have been added to the databasewhile the RMAN backup is in

progress

 

Explanation:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/advmaint.htm#i1008347

While the RMAN job isrunning, start SQL*Plus and connect to the target database, and execute

the longops script tocheck the progress of the RMAN job.

If you repeat the querywhile the RMAN job progresses, then you see output such as the following:

 

If you run the longopsscript at intervals of two minutes or more and the %_COMPLETE column

does not increase, thenRMAN is encountering a problem. Refer to "Monitoring RMAN Interaction

with the MediaManager" on page 23-8 to obtain more information. If you frequentlymonitor the

execution oflong-running tasks, then you could create a shell script or batch file underyour host

operating system thatruns SQL*Plus to execute this query repeatedly.

QUESTION NO:620

Note the followingparameter settings:

Which setting is NOTallowed?

A. ALTER SYSTEM SET DB_CACHE_SIZE=50M;

B. ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;

C. ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;

D. ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;

 

Explanation:

Section: Initialization, Parameters, File Location & ServerConfiguration

http://www.akadia.com/services/ora_asm_multiple_block_sizes.html

db_block_size integer8192 - is the db default so you can't have 8K subcache.

 

QUESTION NO:621

Which three statementsmust be true before transporting a tablespace from a database on one  platform to a database on another platform?(Choose three.)

A. Both source and target database mustbe the same character set

B. Both source and target database musthave the same endian format

C. The COMPATIBLE parameter must be the same in the sourceand target databases.

D. The minimum compatibility level forboth the source and target database must be 10.0.0.

E. All read-only and offline data files that belong to thetablespace to be transported must be platform aware.

 

Explanation:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN01101

Limitationson Transportable Tablespace Use

The source and targetdatabase must use the same character set and national character set.

 

You cannot transport atablespace to a target database in which a tablespace with the same name

already exists. However,you can rename either the tablespace to be transported or the

destination tablespacebefore

the transport operation.Objects with underlying objects (such as materialized views) or contained

objects (such aspartitioned tables) are not transportable unless all of the underlying orcontained

objects are in thetablespace set. Encrypted tablespaces have the following the limitations:Before

transporting anencrypted tablespace, you must copy the Oracle wallet manually to thedestination

database, unless themaster encryption key is stored in a Hardware Security Module (HSM)

device instead of anOracle wallet. When copying the wallet, the wallet password remains the

same in the destinationdatabase. However, it is recommended that you change the password on

the destination databaseso that each database has its own wallet password. See Oracle

Database AdvancedSecurity Administrator's Guide for information about HSM devices, about

determining the locationof the Oracle wallet, and about changing the wallet password with Oracle

Wallet Manager. Youcannot transport an encrypted tablespace to a database that already has an

Oracle wallet fortransparent data encryption. In this case, you must use Oracle Data Pump to

export the tablespace'sschema objects and then import them to the destination database. You

can optionally takeadvantage of Oracle Data Pump features that enable you to maintain

encryption for the datawhile it is being exported and imported. See Oracle Database Utilities for

more information. Youcannot transport an encrypted tablespace to a platform with different

endianness. Tablespacesthat do not use block encryption but that contain tables with encrypted

columns cannot betransported. You must use Oracle Data Pump to export and import the

tablespace's schemaobjects. You can take advantage of Oracle Data Pump features that enable

you to maintainencryption for the data while it is

being exported andimported. See Oracle Database Utilities for more information.

Beginning with OracleDatabase 10g Release 2, you can transport tablespaces that contain

XMLTypes. Beginning withOracle Database 11g Release 1, you must use only Data Pump to

export and import thetablespace metadata for tablespaces that contain XMLTypes.

The following tableshows the minimum compatibility requirements of the source and target

tablespace in variousscenarios. The source and target database need not have the same

compatibility setting.

QUESTION NO:622

Your database instanceis running. You are not able to access Oracle Enterprise Manager DatabaseControl because the listener is not started.

Which tool or utilitywould you use to start the listener?

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant

 

Explanation:

http://download.oracle.com/docs/cd/A97630_01/network.920/a96581/lsnrctl.htm

ListenerControl Utility:

The Listener Controlutility enables you to configure listeners to receive client connections. You

can access the utilitythrough Enterprise Manager or as a standalone command-line application.

 

QUESTION NO:623

While Monitoring thespace usage in your database that is in ARCHIVELOG mode you observed that theflash recovery area does not have enough free space to accommodate any morefiles and you do not have necessary permissions to add more space to it.

Identify the two eventsthat can occur in the event of a log switch? (Choose two.)

当监视你数据库中的空间使用情况时，处于归档模式，你观察看到fra没有足够的空间去存放更多地文件，你也米有足够的权限去添加更多的空间给它。识别在日志切换时发生的两个事件？

A. An entry is created in the alert log file and thedatabase instance continues to function no mally

B. The log switch hangs occur fortransactions until free space is available in the flash recovery area

C. The Oracle database server deletes afile that is on the obsolete file list to make free space in  the flash recovery area

D. The database instance status is implicitly changed toRESTRICTED mode and file creations to  theflash recovery area are prevented

 

Explanation:

https://netfiles.uiuc.edu/jstrode/www/oraelmt/redo_log_files.html

Log Switch:

A log switch occurs whenthe database stops writing to one online redo log file and begins writing

to another. Normally, aswitch occurs when the current online redo log file is full and writing must

continue. However, youcan configure log switches to occur at regular intervals, regardless of

 

whether the currentonline redo log file is filled, and force log switches manually.

Incrementalcheckpoints:

An incrementalcheckpoint is a type of thread checkpoint partly intended to avoid writinglarge

numbers of blocks atonline redo log switches. DBWn checks at least every three seconds to

determine whether it haswork to do. When DBWn writes dirty buffers, it advances the checkpoint

position, causing CKPTto write the checkpoint position to the control file, but not to the data file

headers.

QUESTION NO:624

Identify the persistentconfiguration setting for the target database that can be set for the backup  by using RMAN. (Choose all that apply.)

A. Backup retention policy

B. Default backup device type

C. Default destinations for backups

D. Multiple backup device types for single backup

E. Default section size for backups

 

Explanation:

QUESTION NO:625

Which three statementsare true about windows? (Choose three.)

A. Only one window can be open at anygiven time

B. Consumer groups are associated with windows

C. Windows work with job classes tocontrol resource allocation

D. The database service name must be provided during windowscreation

E. Windows can automatically start jobor change resource allocation among jobs for various time

periods.

 

Explanation:

QUESTION NO:626

Which three statementsare true about persistent configuration? (Choose three.)

 

A. A user cannot set privileges on thepersistent lightweight jobs

B. Persistent lightweight jobs generate a large amount ofmetadata

C. It is possible to create fully self-contained persistentlightweight jobs

D. The use of a template is mandatoryto create persistent lightweight jobs

E. Persistent lightweight jobs areuseful when users need to create a large number of jobs in a

short time

 

Explanation:

QUESTION NO:627

You want to enableautomatic PGA memory management in your database. Which setting is required toachieve this?

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGETparameter to nonzero value

 

Explanation:

Automatic PGA MemoryManagement:

When automatic memorymanagement is disabled and PGA_AGGREGATE_TARGET is set to a

nonzero value, the databaseuses automatic PGA memory management.

In this mode, thePGA_AGGREGATE_TARGET specifies a target size for the instance PGA. The

database then tunes thesize of the instance PGA to this target and dynamically tunes the sizes of

individual PGAs. If youdo not explicitly set a target size, then the database automatically

configures a reasonabledefault.

QUESTION NO:628

Examine the parametersetting in your database:

Which statement iscorrect about the database?

A. Automatic memory management is disabled becausePGA_AGGREGATE_TARGET and

SGA_TARGET are not set

B. The instance is started but the database will not beopened until PGA_AGGREGATE_TARGET

and SGA_TARGET are set

C. The database is opened but users cannot performtransactions until

PGA_AGGREGATE_TARGET andSGA_TARGET are set

D. Automatic memory management isenabled and, as per policy, 60% of the memory for System

Global Area (SGA) and 40% of the memory for ProgramGlobal Area (PGA) will be distributed at

startup

 

Explanation:

Not sure about thepolicy stuff, but it's the default behavior when memory_target and

memory_max_target are

set, sga_max_target isalways set automatically to the same value as memory_max_target

http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/memory.htm#47750

ConfiguringAutomatic PGA Memory

When configuring a brandnew instance, it is hard to know precisely the appropriate setting for

PGA_AGGREGATE_TARGET.You can determine this setting in three stages: Make a first

estimate forPGA_AGGREGATE_TARGET, based on a rule of thumb. By default, Oracle uses

20% of the SGA size.However, this initial setting may be too low for a large DSS system.

Run a representativeworkload on the instance and monitor performance, using PGA statistics

collected by Oracle, tosee whether the maximum PGA size is under-configured or overconfigured.

TunePGA_AGGREGATE_TARGET, using Oracle PGA advice statistics.

QUESTION NO:629

Which three functionsare performed by the SQL Tuning Advisor? (Choose three.)通过SQL调优建议器可以执行的3个功能：

 

A. Building the SQL profile

B. Recommending optimization of materialized views

C. Checking query objects for missingand stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending restructuring SQLqueries that are using bad plans

 

Explanation:

SQL Tuning AdvisorAutomatic SQL tuning is exposed through SQL Tuning Advisor.

SQL Tuning Advisor runsautomatically during system maintenance windows as a maintenance

task. During eachautomatic run, the advisor selects high-load SQL queries in the database and

generatesrecommendations for tuning these queries.

SQL Tuning Advisorrecommendations fall into the following categories:

- Statistics analysis

- SQL profiling

- Access path analysis

- SQL structure analysis

A SQL Profile containsadditional statistics specific to a SQL statement and enables the optimizer

to generate a betterexecution plan. Essentially, a SQL profile is a method for analyzing a query.

Both access path and SQLstructure analysis are useful for tuning an application under

development or ahomegrown production application.

A principal benefit ofSQL Tuning Advisor is that solutions come from the optimizer rather than

external tools (see"Overview of the Optimizer" on page 7-10). Thus, tuning is performedby the

database component thatis responsible for the execution plans and SQL performance. The tuning

process can considerpast execution statistics of a SQL statement and customizes the optimizer

settings for thisstatement.

http://www.remote-dba.net/oracle_10g_new_features/tuning_advisor.htm

How the SQLTuning Advisor Works:

The optimizer will workin the new tuning mode wherein it conducts an in-depth analysis to come

up with a set ofrecommendations, the rationale for them and the expected benefit if you followthe

recommendations. Whenworking in tuning mode, the optimizer is referred to as the Automatic

Tuning Optimizer (ATO).

QUESTION NO:630

In your productiondatabase, users report that they are unable to generate reports on an important

table because it doesnot contain any data. While investigating the reason, you realize that

another user executedthe TRUNCATE TABLE command, which accidentally caused the data to

be lost. Now you want torecover the lost data of the table without affecting objects in other

schemas.

Which method must youuse to recover the lost data?

A. Complete Recovery with online redo log

B. Complete Recovery with archived redo log

C. Tablespace Point-in-Time Recovery(TSPITR)

D. Incomplete Recovery with system change number (SCN)

 

Explanation:

RMAN TSPITR is mostuseful for the following situations:

- You want to recoverdata lost after DDL operations that change the structure of tables.

You cannot use FlashbackTable to rewind a table to before the point of a structural change

such as a truncate tableoperation.

QUESTION NO:631

View the Exhibit.

You are creating adatabase by using Database Configuration Assistant (DBCA). You have  chosen the File System option as the storagemechanism. What would be the result of choosingthis option?

Exhibit:

A. Disk mirroring and striping would be done automatically

 

B. The database files would be managedby the operating system's file system

C. DBCA would not save the database files by using OptimalFile Architecture (OFA)

D. The data files are automatically spread across allavailable storage devices to optimize performance and resource utilization

 

Explanation:

QUESTION NO:632

View the Exhibit andexamine the disk groups created at the time of migrating the database  storage to Automatic Storage Management (ASM)

.

 

 

Why does the FRA diskgroup initially最初 have more free space even though both DATAand FRA disk groups are provided with the same size?

 

A. Because the FRA disk group will not support dynamicrebalancing

B. Because the FRA disk group is notconfigured to support mirroring

C. Because disks in the FRA disk group are not formatted atthis stage

D. Because the FRA disk group will support only a singlesize of allocation unit

 

Explanation:

QUESTION NO:633

Which two statements aretrue about a job chain? (Choose two.)

A. A job chain can contain a nestedchain of jobs.

B. The jobs in a job chain cannot have more than onedependency.

C. A job of the CHAIN type can be runusing event-based or time-based schedules.

D. The jobs in a job chain can be executed only by using theevents generated by the Scheduler

 

Explanation:

QUESTION NO:634

View the exhibit andexamine the TRANS table's storage information.

After a massive deleteoperation, you executed the following statement to shrink the TRANS table:

SQL> ALTER TABLEtrans SHRINK SPACE CASCADE;

 

Which statementdescribes the outcome of the command?

Exhibit:

A. An error is produced.

B. The table and all related objectsare compacted and the position of the high-water mark (HWM) for the table isadjusted

C. The table and related indexes are compacted but theposition of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returnedto the tablespace and the data manipulation language (DML) triggers on the tableare fired during the shrinking process

 

Explanation:Exhibit Reference:

CASCADE:

If you specify CASCADE,then Oracle Database performs the same operations on all dependent

objects of table,including secondary indexes on index-organized tables. The CASCADE clause

extends the segmentshrink operation to all dependent segments of the object. For example, if you

specify CASCADE whenshrinking a table segment, all indexes of the table will also be shrunk.

(You need not specifyCASCADE to shrink the partitions of a partitioned table.) To see a list of

dependent segments of agiven object, you can run the OBJECT_DEPENDENT_SEGMENTS

procedure of theDBMS_SPACE package.

QUESTION NO:635

You executed thefollowing commands in a database session:

What could have causedthe recycle bin to clean up?

A. There is demand for space from thenew table

B. The undo tablespace does not have sufficient free space

C. The new table name is the same as the table name in therecycle bin

D. The temporary tablespace that is assigned to you does nothave sufficient free space

 

Explanation:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1019426

Recycle BinCapacity and Space Pressure

There is no fixed amountof space preallocated for the recycle bin. Therefore, there is no

guaranteed minimumamount of time during which a dropped object will remain in the recycle bin.

The rules that governhow long an object is retained in the recycle bin and how and when space is

reclaimed are explainedin this section.

QUESTION NO:636

Note the followingstatements that use flashback technology:

1. FLASHBACK TABLE <table> TO SCN <scn>;

2. SELECT * FROM <table> AS OF SCN 123456;

3. FLASHBACK TABLE <table> TO BEFORE DROP;

4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;

5. SELECT * FROM <table> VERSIONS AS OF SCN 123456AND 123999;

Which of thesestatements will be dependent on the availability of relevant undo data in theundo segment?这些语句将依赖于（undo段中的相关的undo数据）

A. 1, 2, and 5

B. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5

 

Explanation:

QUESTION NO:637

 

Examine the CREATEDISKGROUP command used to create a disk group:

SQL> CREATE DISKGROUP misc  EXTERNAL  REDUNDANCY

DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;

In which situation wouldyou use this method of disk group creation?

哪种场景下你使用这种方案来创建磁盘组？

A. When two-way disk mirroring is required for theallocation units

B. When three-way disk mirroring is required for theallocation units

C. When using hardware mirroring orRAID

D. When disk mirroring is required for the Automatic StorageManagement (ASM) disks

 

Explanation:

QUESTION NO:638

Which three tasks can beperformed using a duplicate database? (Choose three.)使用复制数据库，哪3个任务可以被执行？

A. Testing the backup and recoveryprocedures测试备份和恢复过程

B. Testing the upgrade of an Oracledatabase to a new release测试一个数据库升级到新的发布版本

C. Testing the effect of an applicationchanges on database performance测试一个应用程序改变在一个数据库性能方面。

D. Continuously updating archive log files from the targetdatabase to support failover

 

Explanation:

QUESTION NO:639

The user SYS creates ajob by using the following command:

Which two statements aretrue about the job that was created by the preceding command?(Choose two.)

A. The job is enabled by default after creation

B. The job is automatically dropped afterthe end date   job在结束日自动dropped

C. The job executes with the privilegesof the user SYS  job执行使用SYS权限

D. The globalization environment that exists at the time ofthe job creation prevails at the job runs

 

Explanation:

QUESTION NO:640

Tape streaming is nothappening while performing RMAN tape backup. On investigation, you find that itis not because of the incremental backup or the empty file backup and that RMANis sending data blocks to the tape drive fast enough.当执行RMAN磁带备份时，磁带流没有发生。根据调研，你发现它没有，因为增量备份或空文件备份。 RMAN发送数据块到磁带驱动器 （快速）

What could be a solutionto make tape streaming happen during the backup?

A. Configure backup optimization

B. Configure the channel to increase MAXOPENFILES

C. Configure the channel to increasethe capacity with the RATE parameter配置channel通道去增加容量（用rate参数）

D. Configure the channel to adjust the tape buffer size withthe BLKSIZE option

 

Explanation:

In the ALLOCATE orCONFIGURE CHANNEL commands, the RATE parameter specifies the bytes/ secondthat are read on a channel.You can use this parameter to set an upper limit for bytesread so that RMAN does not consume excessive disk bandwidth and degrade online performance.Essentially, RATE serves as a backup throttle. For example, if you set RATE1500K, and if each disk drive delivers 3 MB/ second, then the channel leavessome disk bandwidth available to the online system.

QUESTION NO:641

 

Which two operations areNOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? (Choose Two)哪两个操作不被支持（RMAN下的DUPLICATE命令），当复制一个运行数据库时

A. Creating the control file for the duplicate database

B. Restoring the target data files to the duplicate database

C. Performing complete recovery usingall available backups

 

D. Generating a new, unique DBID for the duplicate database

E. Copying the online redo log filesfrom the target database to the duplicate database

 

Explanation:

QUESTION NO:642

You are using RecoveryManager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a dailybasis.

Because of mediafailure, you lost your production database completely along with the recovery catalogdatabase. You want to recover the target database and make it functional. Youconsider performing the following steps to accomplish the task:

你正在使用RMAN（用recoverycatalog）去备份你的生产库。备份和归档重做日志被copy到一个磁带驱动器（在一个日常的工作中）。因为介质失败，你完全失去你的生产库（伴随着recovery catalog数据库）。你想恢复目标数据库，使它继续提供服务。你考虑到执行以下步骤完成任务：

1) Restore an autobackupof the server parameter file.还原一个服务器参数文件的自动备份

2) Restore the controlfile还原控制文件

3) Start the targetdatabase instance启动target数据库实例

4) Mount the database绑定数据库

5) Restore the datafiles还原数据文件

6) Open the databasewith RESETLOGS option用resetlogs选项打开文件

7) Recover the datafiles 回复数据文件

8) Set DBID for thetarget database为target数据库设置dbid

 

Which option illustratesthe correct sequence that you must use?

A. 8, 1, 3, 2, 4, 5, 7, 6

B. 1, 8, 3, 4, 2, 5, 7, 6

C. 1, 3, 4, 2, 8, 5, 6, 7

D. 1, 3, 2, 4, 6, 5, 7, 8

 

Explanation:

w/o recovery catalog,you must provide dbid for rman to search for spfile autobackup.

QUESTION NO:643

 

Examine the followingALTER command:

SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

What is the purpose ofthe command?

 

A. It cancels all pending disk dropswithin the disk group.

B. It restores disks that are being dropped as the result ofa DROP DISKGROUP operation

C. It mounts disks in the disk group for which the drop-diskoperation has already been co pleted

D. It restores all the dropped disks in the disk group forwhich the drop-disk operation has already been completed

E. It adds previously dropped disks back into the disk group

 

Explanation:

The UNDROP DISKS clauseof the ALTER DISKGROUP statement allows pending disk drops to be undone. Itwill not revert drops that have completed, or disk drops associated with thedropping of a disk group.

QUESTION NO:644

TheBACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance.Which statement is true while performing a tape backup in an RMAN session?

 

A. The tape I/O performed is asynchronous

B. The tape buffer is allocated from the System Global Area(SGA)

C. The tape buffer is allocated fromthe Program Global Area (PGA)

D. Oracle I/O uses an interrupt mechanism to determine wheneach I/O completes

 

Explanation:

Section: Backup, Recovery & Recovery Manager (RMAN)

http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmtunin.htm#449408

RMAN allocates the tape buffers in the SGA or the PGA,depending on whether I/O slaves are used. Ifyou set the initialization parameter BACKUP_TAPE_IO_SLAVES = true, then RMAN

allocates tape buffers from the SGA or the large pool ifthe LARGE_POOL_SIZE initialization

parameter is set. If you set theparameter to false, then RMAN allocates the buffers from the PGA.

 

QUESTION NO:645

The database iscurrently open and the temp03.dbftempfile belonging to the default temporary tablespace TEMP has been corrupted.What steps should you take to recover from this tempfile loss in an efficientmanner?

 

A. Allow the database to continue running, drop the TEMPtablespace, and then re-create it with new tempfiles

B. Shut down the database, restore and recover the tempfilefrom backup, and then open the database with RESETLOGS

C. Allow the database to continue running, take the TEMP tablespaceoffline, drop the missing  tempfile, andthen create a new tempfile

D. Allow the database to continuerunning, add a new tempfile to TEMP tablespace with a new name, and drop thetempfile that has been corrupted.

 

Explanation:

QUESTION NO:646

Indentify two advantagesof using recovery catalog instead of the control file of the database in RecoveryManager (RMAN). (Choose two.) 在RMAN中用recovery catalog代替控制文件的优点是：

A. You can use RMAN stored scripts

B. Recovery is faster if data is stored in catalog inaddition to the control file

C. You can store backup information ofall registered databases in one place

D. Database backups are automatically deleted when they areolder than the specified time period

 

Explanation:

QUESTION NO:647

Which two commands nevertrigger an implicitrebalancing within the disk group?. (Choose two.)哪个命令从未触发一个明显的再平衡（在磁盘组中）

A. ALTER DISKGROUP misc MOUNT;

B. ALTER DISKGROUP misc DROP DISK misc2;

C. ALTER DISKGROUP misc CHECK ALLNOREPAIR;

D. ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;

E. ALTER DISKGROUP dgroupA ADD DISK '/devices/A*';

 

Explanation:

 

QUESTION NO:648

You want to configurethe Flashback Database feature and retain flashback logs for three days.

Presently the databaseis open and configured in ARCHIVELOG mode.

The following steps mustbe performed in the correct sequence to do this:

你想配置flashbackdatabase功能，保留闪回日志3天。目前数据库打开和配置归档模式。下列步骤必须执行在正确的序列去做这：

1. Set the retentiontarget:

SQL> ALTER SYSTEM SETDB_FLASHBACK_RETENTION_TARGET=4320;

2. Enable FlashbackDatabase:

SQL> ALTER DATABASE FLASHBACK ON;

3. Mount the database:

SQL> STARTUP MOUNT EXCLUSIVE

4. Shutdown theinstance:

SQL> SHUTDOWN IMMEDIATE

5. Open the database:

SQL> ALTER DATABASE OPEN;

Choose the correctsequence.

A. 4, 1, 3, 2, 5

B. 4, 3, 1, 2, 5

C. 2, 4, 3, 5, 1

D. 4, 2, 5, 3, 1

 

Explanation:

QUESTION NO:649

View the Exhibit andexamine the output.

You execute thefollowing RMAN command to perform the backup operation:

RMAN> RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;

BACKUP DATABASE FILESPERSET 4;

}

What is the multiplexing复用 level in thepreceding backup process?

A. 4

B. 8

C. 7

D. 0

 

.

QUESTION NO:650

To enable fasterincremental backups, you enabled block change tracking for the database. Whichtwo statements are true about the block change tracking file? (Choose two.)为了启用快速增量备份，你启用块变化跟踪（为数据库）。哪两个语句是正确的，关于块变化跟踪文件？

A. Multiple change tracking files can be created for adatabase.

B. The change tracking file must be created after the firstlevel 0 backup.

C. RMAN does not support backup andrecovery of the change tracking file. RMAN不支持变化更总文件的备份和恢复

D. The database clears the changetracking file and starts tracking changes again, after whole database restoreand recovery operations. 完整的数据库还原和恢复操作之后，数据库清空变更跟踪文件和启动变更跟踪。

 

Explanation:

QUESTION NO:651

Which options would youconsider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for your production database that is running in ARCHIVELOG mode?(Choose all that apply.)当你为你的生产库（运行在archivelog模式）配置一个闪回恢复区时（快速恢复区11.2），哪个选项是你要考虑的？

A. Setting the FAST_START_MTTR_TARGET to set the mean timeto recover

B. Setting the RECOVERY_PARALLELISM parameter to twice thenumber of CPUs

C. Using the DB_RECOVERY_FILE_DESTparameter to set the location for flash recovery area使用db_recovery_file_dest参数去设置闪回区的位置

D. Using the DB_RECOVERY_FILE_DEST_SIZEparameter to define the disk space limit for the recovery files created in theflash recovery area使用db_recovery_file_dest_size参数去定义磁盘空间限制为（在FRA中创建的恢复文件）

 

Explanation:

QUESTION NO:652

You want to take acomplete database backup using RMAN. The backup should consist only the usedblocks from your database.

你想使用RMAN进行一个完整的数据库备份。备份应该只有数据库中已使用的块组成。

Which two statements aretrue about this backup operation? (Choose two.)

哪两个语句是正确的，关于这个备份操作？

A. Backup compression should be enabled

B. Parallelism for the channel should be set to 2

C. All the files must be backed up asbackup sets所有的文件必须备份作为一个备份集

D. The backup may be stored either ondisk or on media with media manager备份或许存储在disk或media（用media manager）

 

Explanation:

QUESTION NO:653

Which two statements aretrue about the Automatic Diagnostic Repository (ADR)? (Choose two.)关于ADR描述正确的是：

 

A. The ADR base keeps all diagnostic information in binaryformat

B. SQL*Plus provides the ADRI script, which can be used towork with ADR

C. The ADR can be used for problem diagnosis only when thedatabase is open

D. The ADR can be disabled by settting the DIAGNOSTIC_DESTparameter to null

E. The ADR can be used for problemdiagnosis even when the database instance is down

F. The ADR base is shared acrossmultiple instances

 

Explanation:

 

QUESTION NO:654

You are working in anonline transaction processing (OLTP) environment. You use the FLASHBACK TABLE commandto flash back the CUSTOMERS table. Before executing the FLASHBACK  TABLE command, the system change number (SCN)was 663571. After flashing back the CUSTOMERS table, you realize that the tableis not in the correct state. Now, you need to reverse the effects of theFLASHBACK TABLE command. Whichis the fastest and the most efficient option to reverse the effects of theFLASHBACK TABLE command?

A. Restore the backup control file and open the databasewith RESETLOGS option.

B. Perform point-in-time recovery because flashback cannotbe performed again on this table

C. Execute the FLASHBACK DATABASE statement to retrieve theCUSTOMERS table as it was at SCN 663571

D. Execute another FLASHBACK TABLEstatement to retrieve the CUSTOMERS table as it was at SCN 663571

 

Explanation:

Undoing aFlashback Table Operation

It is important to noteyour current SCN before using a Flashback Table operation.

Use the FLASHBACK TABLEstatement again to go back to just before you were when you issued  the first statement.

QUESTION NO:655

What does the DB_FLASHBACK_RETENTION_TARGETparameter configure?

A. An upper limit on how far you can flash back thedatabase, depending on the information in the redo logs

B. An upper limit on how far you can flash back thedatabase, depending on the information in the undo tablespace

C. The amount of time for which theflashback data is to be kept in the flash recovery area, provided that there isenough space  闪回数据保存在FRA中的总时间，提供有足够的空间。

D. The amount of time for which the flashback data isguaranteed to be kept in the undo tablespace, provided that there is enough space

 

Explanation:

QUESTION NO:656

Examine the followingRMAN script:

RMAN> run {

debug on;

 

allocate channel c1 type disk;

backup datafile 5;

}

Which statementdescribes the purpose of the script?

A. The data file is checked for physical corruption and backedup if found clean.

B. The backup of data file 5 is performed and theinteractive messages during the backup are

suppressed.

C. The existing backup for the data file is checked and thebackup is performed if there are

changes in the data fileafter the last backup.

D. The backup of data file 5 isperformed and all SQL statements that are executed during RMAN compilation andtheir results are displayed

 

Explanation:

http://www.cs.bris.ac.uk/maintain/OracleDocs/server.816/a76990/troubler.htm

RMAN debugging output isso highly detailed that you may find yourself unable to distinguish the

useful from the uselessinformation. Execute the following command in debug mode:

run{ allocate channel c1type disk; backup tablespace TBS_5, TBS_6; }

QUESTION NO:657

User SCOTT wants to back out不遵守 the transactions on the REGIONS table in his schema. Asa DBA, which commands must you execute to enable SCOTT to flash back thetransactions? (Choose four.)

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT any transaction TO scott;

C. GRANT EXECUTE ON dbms_flashback TOscott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOGDATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F. ALTER DATABASE ADD SUPPLEMENTAL LOGDATA (PRIMARY KEY) COLUMNS;

 

QUESTION NO:658

After you have restoredand recovered a database to a new host by using a previously performed RecoveryManager (RMAN) backup, which is the best option you would consider for the new database?

你已经还原和恢复数据库到一个新的主机之后，通过使用一个先前执行的RMAN备份，你考虑最佳选项为（新的数据库）

A. Opening the database in RESTRICTED mode

B. Opening the database with theRESETLOGS option

C. Setting a new DBID for the newly restored database

D. Restoring the server parameter file (SPFILE) to the newhost

 

 

 

QUESTION NO:659

Examine the followingRMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE  ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which prerequisite mustbe met before accomplishing the backup?完成备份之前的先决条件？

A. Provide a password for the encryption

B. Set up an Oracle wallet for theencryption

C. No setup is required as it is a default encryption method

D. Both Oracle wallet and password must be set up for theencryption

 

Explanation:

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmconfa.htm

To configure theenvironment so that all RMAN backups are encrypted: Set up the Oracle wallet

as explained in OracleDatabase Advanced Security Administrator's Guide. Issue the following

RMAN command: CONFIGUREENCRYPTION FOR DATABASE ON; At this stage, all RMAN

backup sets created bythis database will use transparent encryption by default.

 

QUESTION NO:660

You plan to control idlesessions that are blocking other sessions from performing transactions.

Your requirement is to automatically terminate theseblocking sessions when they remain idle for a  specified amount of time.

How would you accomplishthis task?

A. Set metric threshold

B. Implement Database Resource Manager

C. Enable resumable timeout for user sessions

D. Add directives to Automatic Database Diagnostic Monitor(ADDM)

 

Explanation:

QUESTION NO:661

You want to create the Recovery Manager (RMAN) VirtualPrivate Catalog (VPC) to maintain a separation of responsibilities alongwith a consolidation ofRMAN repository. Which condition must be met before you create the VPC?

你想创建vpc去维持一个间隔用一个联合的RMAN仓储。哪个条件必须匹配，在你创建vpc之前？

A. A base catalog exists

B. The recovery catalog is empty

C. The base recovery catalog must be dropped

D. A target database is registered in the recovery catalog

 

Explanation:

QUESTION NO:662

Consider the followingscenario for your database:

考虑你的数据库的下列场景：

- Backup optimization isenabled in RMAN.备份优化器

- The recovery window isset to 7 days in RMAN.恢复窗口设置为7天，RMAN中

- The most recent backupto disk for the TOOLS tablespace was taken on November 3, 2007.  最近的备份到磁盘（为tools表空间，2007.11.3创建）

- The TOOLS tablespaceis read-only since November 4, 2007.（2004.11.4只读）

On November 23, 2007,you issue the RMAN command to back up the database to disk.在20073.11.23日，你发起RMAN命令去备份数据库到磁盘。

 

Which statement is trueregarding the backup of the TOOLS tablespace?

 

A. The RMAN backup fails because the TOOLS tablespace isread-only

B. The RMAN skips the backup of the tablespace becausebackup optimization is enabled

C. The RMAN makes backup because optimization can be enabledonly for backups to disk

D. The RMAN makes the backup because nobackup of the tablespace exists within the seven day window

 

 

QUESTION NO:663

The EMP table exists inyour schema. You want to execute the following query:

SELECT ename, sal

FROM emp

AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

WHERE ename = 'ALLEN';

What are the minimumrequirements for the statement to execute successfully? (Choose all that  apply)

A. ARCHIVELOG mode must be enabled

B. Row Movement must be enabled for the table

C. FLASHBACK must be set to ON for the database

D. The UNDO_MANAGEMENT parameter mustbe set to AUTO

E. The UNDO_RETENTION parameter must beset appropriately

 

Explanation:

 

QUESTION NO:664

Note the followingparameters settings in your database:

SGA_MAX_SIZE = 1024M

SGA_TARGET = 700M

DB_8K_CACHE_SIZE = 124M

LOG_BUFFER = 200M

You issued the followingcommand to increase the value of DB_8K_CACHE_SIZE:

SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

What would happen?

A. It will fail because DB_8K_CACHE_SIZE parameter cannot bechanged dynamically

B. It will be successful only if the memory is availablefrom the auto tuned components

C. It will fail because an increase in DB_8K_CACHE_SIZEcannot be accommodated within SGA_TARGET

D. It will fail because an increase inthe DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE

 

 

QUESTION NO:665

The SQL Tuning Advisor configuration has default settingsin your database instance. Which recommendationis automatically implemented after the SQL Tuning Advisor is run as part of theautomatic maintenance task?

A. statistics recommendations

B. SQL Profile recommendations

C. Index-related recommendations

D. restructuring of SQL recommendations

 

 

 

QUESTION NO:666

The BOOKINGS table contains online booking information.When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the BOOKINGS table.There is no fixed time interval between each online booking and itsconfirmation.

Because sufficient space足够的空间 is not always available from the delete operations the high-water mark (HWM) is  moved up and many rows are inserted below theHWM of the table.

The BOOKINGS table has Automatic Segment Space Management(ASSM) and row movement enabled. The tableis accessible in 24x7 mode.

What is the mostefficient method to reclaim the space released by the delete operations in the BOOKINGStable

A. Perform EXPORT, DROP, and IMPORT operations on theBOOKINGS table sequentially

B. Shrink the BOOKINGS table by usingthe ALTER TABLE... SHRINK SPACE command

C. Move the BOOKINGS table to a different location by usingthe ALTER TABLE... MOVE command

D. Deallocate the space in the BOOKINGS table by using theALTER TABLE ... DEALLOCATE UNUSED command

 

Explanation:

QUESTION NO:667

The ORACLE_SIDenvironment variable is set to +ASM. ASMLIB is not used in the configuration.

You executed thefollowing command to startup the Automatic Storage Management (ASM) instance.

SQL> STARTUP;

Which two activities areperformed during a successful start up operation? (Choose two.)

A. The databases configured to use the ASM instance aremounted

B. The disk groups are mounted as perthe ASM_DISKGROUPS initialization parameter 磁盘组绑定作为ASM_DISKGROUPS初始化参数

C. ASM starts the Oracle ClusterSynchronization Services (CSS) daemon if it is not started  ASM启动OCSS进程（如果它不能启动）

D. ASM discovers and examines the contents of all files thatare in the paths specified in the ASM_DISKGROUPS initialization parameters

 

Explanation:

There is only 1 goodanswer.. D would be correct if ASM_DISKGROUPS is replaced with ASM_DISKSTRING

ASM does not start CSSit may prompt user to run local config add to start CSS service.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/storeman.htm#i1013975

Starting Upan ASM Instance

ASM instances arestarted similarly to Oracle database instances with some minor differences.

These are:

- The initializationparameter file, which can be a server parameter file, must contain:

INSTANCE_TYPE = ASM

- This parameter signalsthe Oracle executable that an ASM instance is starting and not a

database instance.

- Using a serverparameter file is recommended because it eliminates the need to make manual

 

changes to a textinitialization parameter file.

- For ASM instances,STARTUP tries to mount the disk groups specified by the initialization

parameter ASM_DISKGROUPSand not the database.

Further, the SQL*PlusSTARTUP command parameters are interpreted by Automatic Storage

Management as follows:

The following is asample SQL*Plus session where an ASM instance is started:

% sqlplus /nolog

SQL> CONNECT / ASsysdba

Connected to an idleinstance.

SQL> STARTUP

ASM instance started

Total System Global Area147936196 bytes

Fixed Size 324548 bytes

Variable Size 96468992bytes

Database Buffers50331648 bytes

Redo Buffers 811008bytes

ASM diskgroups mounted

ASM InstanceMemory Requirements

ASM instances aresmaller than database instances. A 64 MB SGA should be sufficient for all but

the largest

ASM installations.

DiskDiscovery

When an ASM instanceinitializes, ASM is able to discover and look at the contents of all of the

disks in the disk

groups that are pointedto by the ASM_DISKSTRING initialization parameter. This saves you from

having to

specify a path for eachof the disks in the disk group.

Disk group mountingrequires that an ASM instance doing disk discovery be able to access all the

disks within

the disk group that anyother ASM instance having previously mounted the disk group believes are

members of

that disk group. It isvital that any disk configuration errors be detected before a disk group is

mounted.

 

AutomaticStorage Management attempts to identify the following configuration errors:

A single disk withdifferent mount points is presented to an ASM instance. This can be caused by

multiple paths to asingle disk. In this case, if the disk in QUESTION is part of a disk group,disk

group mount fails. Ifthe disk is being added to a disk group with ADD DISK or CREATE

DISKGROUP, the commandfails. To correct the error, restrict the disk string so that it does not

include multiple pathsto the same disk. Multiple ASM disks, with the same ASM label, passed to

separate ASM instancesas the same disk. In this case, disk group mount fails. Disks that were not

intended to be ASM disksare passed to an ASM instance by the discovery function. ASM does

not overwrite a disk ifit recognizes the header as that of an Oracle object. Disk Group Recovery

When an ASM instancefails, then all Oracle database instances on the same node as that ASM

instance and that use adisk group managed by that ASM instance also fail. In a single ASM

instance configuration,if the ASM instance fails while ASM metadata is open for update, then after

the ASM instancereinitializes, it reads the disk group log and recovers all transient changes.With

multiple ASM instancessharing disk groups, if one ASM instance should fail, another ASM

instance automaticallyrecovers transient ASM metadata changes caused by the failed instance.

The failure of an Oracledatabase instance is not significant here because only ASM instances

update ASM metadata.