1z0-043 lesson 3 Using Recovery Manager

Update 5:
增加注释

Update 4:
增加显示选项

Update 3:
增加答案
增加29,30两道题


 是否显示我的答案
 是否显示书上的答案和我的注释

预留


Updated at 5.55PM on Dec. 24, 2008
考题

1.
6、Exhibit，
[1z0-043-lesson3-q01.png]

You executed the following command to perform a backup of the USERS tablespace:
RMAN > BACKUP TABLESPACE USERS;
Which type of backup would this command perform?
A. backup set
B. image copy
C. incremental backup
D. None; the user receives an error indicating that the backup type must be specified.

1.A

6.A
配置了device type ... backup to backupset

2.
32. You executed the following command in Recovery Manager (RMAN) against your Oracle 10g database:
RMAN> REPORT NEED BACKUP days 3;
What would be the output of this command?
A. a list of files that require a backup within three days
B. a list of files that have not been backed up for three days
C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility
D. a list of files for which a backup has already been performed and may need a backup after three days

2.B

32.B
教材3-31

3.
87. What purpose would you achieve by enabling the block change tracking feature?
A. Eliminate the necessity for backups.
B. Perform optimized image copy backups.
C. Perform optimized incremental backups.
D. Enable checkpoint (CKPT) to perform checkpointing at every block change.
E. Enable database writer (DBWn) to write changed blocks to data files faster.

3.C

87.C
教材3-25

4.
88. You execute the following RMAN command in the order shown below:
BACKUP VALIDATE DATABASE;
BLOCKRECOVER CORRUPTION LIST;
What will these commands do?
A. Create a backup of the database and recover all corrupted blocks found in the backup.
B. Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
C. Run a backup validation to populate V$COPY_CORRUPTION view, and then list any corrupt blocks recorded in the view.
D. Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view, and then repair any corrupt blocks recorded in the view.
E. Run a backup validation, repair any corrupt blocks found during the validation process,
and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

4.D 不知道BLOCKRECOVER做什么, 猜的

88.D
VALIDATE见教材3-21
BLOCKRECOVER这章没讲

5.
155. Which two statements regarding compressed backups in Recovery Manager (RMAN) are true? (Choose two.)
A. Backup compression is disabled by default.
B. Backup compression can be used with both backup sets and image copies.
C. Backup compression cannot be enabled using the CONFIGURE command.
D. Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
E. Backup compression applies to only backup sets.
F. Backup compression applies to only image copies.

5.AE

155.AE
教材3-13

6.
163. You are managing a database for which incremental backups can be very time consuming.
In order to perform optimized incremental backups you enable the block change tracking feature.
How would you instruct RMAN to use the block change tracking feature when performing incremental backups?
A. You need to mention it with every BACKUP command.
B. The block change tracking feature is used automatically by RMAN.
C. You need to configure it using the CONFIGURE command.
D. You need to set the necessary initialization parameters to direct RMAN to use the feature.

6.B

163.B
教材3-25

7.
179. The backup retention policy is configured as RECOVERY WINDOW 2. You executed
the following command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
A. a list of all those files that have been deleted in the last two days
B. a list of all those files that have been recovered within the last two days
C. a list of all the expired backups and copies
D. a list of backups and copies that are outside the range covered by the current retention policy

7.D

179.D
教材3-31

8.
181. View the Exhibit.
[1z0-043-lesson3-q08.png]

You executed the following command to perform a backup of the USERS tablespace:
RMAN> BACKUP TABLESPACE USERS;
Which three types of files are backed up? (Choose three.)
A. all the data files belonging to the USERS tablespace
B. password file
C. online redo log files
D. the current control file
E. archived redo log files
F. the current server parameter file
G. data files belonging to the USERS tablespace and all the default tablespaces

8.ADF

181.ADF
配置了控制文件自动备份, 也自动备spfile

==========

9.
1. How is block change tracking enabled?
A. With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B. With ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
C. With a INIT.ORA parameter change
D. With a SPFILE parameter change

9.A

3-26页
1. A. Block change tracking must be enabled with ALTER DATABASE ENABLE BLOCK CHANGE
TRACKING. The physical location and name of the block change tracking file must be supplied.

10.
2. What type of backup is stored in a proprietary RMAN format?
A. Backup set
B. Image copy
C. Backup section
D. Backup group

10.A

教材3-9
2. A. The backup set is stored in a proprietary RMAN format, where only used blocks are backed up.

11.
3. What method is used to improve backup performance when creating backup sets?
A. Multicopy
B. Multiplecopy
C. Multiplex
D. Multiply

11.C

3. 没说, 就是PARALLELISM吧
C. Multiplexing a backup is designed to improve the performance of the backup sets by copy-
ing multiple database files at the same time. Multiplexing can be used with image copies or
backup sets.

12.
4. Which command creates an image copy?
A. BACKUP AS COPY
B. BACKUP COPY
C. COPY AS BACKUP
D. COPY BACK

12.A

教材3-14
4. A. The BACKUP AS COPY command is used to create an image copy backup.

13.
5. Compressed backups work with which of the following commands?
A. COPY AS BACKUP
B. BACKUP AS COPY
C. BACKUP
D. COPY

13.C

教材3-13
5. C. Compressed backups work only with backup sets, not image copies. Thus compressed backups
will work only with the BACKUP command.

14.
6. What ratio are compressed backups sized to?
A. 30 percent
B. 40 percent
C. 70 percent
D. 20 percent

14.C 压缩率?不知道

压缩后是1/5? 不相信
6. D. Compressed backups compressed at a ratio of 5 to 1—20 percent—of the original size of a
standard backup.

15.
7. Which of the following best describes a full backup?
A. All datafiles of a database
B. All datafiles, archive logs, and control files
C. All datafiles and control files
D. All the used blocks in a datafile

15.A ?

见教材3-22
7. D. A full backup is best described by backing up all the used blocks in a datafile or any database
file. A full backup can be taken on one database file.

16.
8. Which type of backup backs up only data blocks modified since the most recent backup at the
same level or lower?
A. Differential incremental backup
B. Different incremental backup
C. Cumulative backup
D. Cumulative incremental backup

16.A

教材3-24
8. A. A differential incremental backup only backs up blocks that have been modified since a
backup at the same level or lower.

17.
9. Which type of backup must be performed first with an incremental backup?
A. Level 1
B. Level 0
C. Level 2
D. Level 3

17.B

教材3-22
9. B. A level 0 backup is the first backup that is performed when implementing an incremental
backup strategy. A level 0 backup copies all the used blocks as a baseline.

18.
10. Which backup option defines a user-defined name for a backup?
A. FORMAT
B. NAME
C. TAG
D. FORMAT U%

18.C ? A是起文件名

教材3-16
10. C. The TAG option is used to name a backup with a user-defined character string.

19.
11. What action requires the RESTORE command?
A. Restoring a backup set
B. Restoring an image copy
C. Performing all RMAN recovery processes
D. All of the above

19.D 觉得C不对, 是AB, 可是不能多选

image copy也可以restore, 也可以switch, 所以restore不是必须的
题出的不好
11. A. The RESTORE command is required only with a backup set recovery. This is because the
backup set is stored in a RMAN proprietary format.

20.
12. Which of the following most closely represents an image copy?
A. Unix cp command of a file
B. Bit-by-bit copy of a file
C. Windows COPY command of a file
D. All of the above

20.D

等于复制
12. D. Image copies are similar to operating system copy commands. These equate to bit-by-bit copies
of a file.

21.
13. Which dynamic view displays the status of block change tracking?
A. V$BLOCK_CHANGE
B. V$BLOCK_CHANGE_TRACKING
C. V$BLOCKCHANGE
D. V$BLOCK_TRACKING

21.B 瞎选的

教材3-26
13. B. The V$BLOCK_CHANGE_TRACKING dynamic view shows the filename, status, and size of the
block change tracking file.

22.
14. Which new Oracle 10g capability improves the backup efficency database of any size?
A. Differential incremental backup
B. Cumulative incremental backup
C. Block change tracking
D. Compressed backup

22.D

看错了, 压缩节省空间, 时间更长
14. C. Block change tracking improves the backup efficiency of large or small databases. With block
change tracking, the backup time is proportional to the amount of changes that occurred in a
database.

23.
15. Where are RMAN dynamic views stored?
A. Recovery catalog database
B. Control file of the recovery catalog database
C. Control file of the target database
D. Target database

23.C

这题不对吧 ,教材3-34 说放在控制文件中
15. D. RMAN dynamic views are stored in the target database.

24.
16. Which of the following can be used to monitor RMAN backups?
A. LIST commands
B. REPORT commands
C. RMAN dynamic views
D. All of the above

24.D

都看
16. D. LIST, REPORT, and dynamic views all allow different types of monitoring of RMAN activities.

25.
17. The LIST commands are best used to identify what about RMAN?
A. How many times the database is restored
B. Files impacted by the CHANGE, CROSSCHECK, and DELETE commands
C. Only data in the recovery catalog
D. All of the above

25.B

教材3-28
17. B. The LIST commands are used to determine files impacted by the CHANGE, CROSSCHECK, and
DELETE commands.

26.
18. The REPORT command is best used to identify what about RMAN?
A. Which files need a backup
B. Unneeded backups
C. Database physical schema
D. If unrecoverable operations were performed on files
E. All of the above

26.E

教材3-29
18. E. The REPORT command is best used to identify which files need a backup, unneeded backups,
database physical schema, and if unrecoverable operations were performed on files.

27.
19. What should be done to generate accurate information from the REPORT command?
A. Recently performed CHANGE command
B. Recently performed UNCATALOG command
C. Recently performed CROSSCHECK commands
D. RMAN repository synchronized with the control file
E. All of the above

27.E

教材3-29
19. E. The REPORT command is accurate when the control and RMAN repository are synchronized,
which can be performed by the CHANGE, UNCATALOG, and CROSSCHECK commands.

28.
20. Identify the methods used to schedule a backup job. (Choose all that apply.)
A. A third-party GUI tool provided by the media management provider
B. A file that is scheduled with the operating system scheduler
C. Running the EM Maintenance utility
D. Running RMAN from CLI

28.ABC

EM为什么不行?
20. A, B. Third-party GUI tools provided from the media manager software and manually scripting
a file incorporated with operating system scheduler are the two methods for scheduling a
backup.

29.
5. The BACKUP command has the ability to do what? (Choose all that apply.)
A. The BACKUP command can make bit-for-bit copies of a file.
B. The BACKUP command can improve performance by multiplexing backup files.
C. The BACKUP can take advantage of the block change tracking capability.
D. The BACKUP command cannot store data in incremental backups.
E. The BACKUP command can store data in cumulative incremental backups only.

29.ABC

A也可以呀, BACKUP AS COPY
5. B, C. The BACKUP command can take advantage of multiplexing datafiles to the same backup
set. The BACKUP command can also use the block change tracking capability. See Chapter 2 for
more information.

30.
6. Which commands are required to perform a compressed RMAN backup? (Choose all that apply.)
A. BACKUP AS COMPRESSED BACKUPSET DATABASE
B. BACKUP AS COMPRESSED COPY OF DATABASE
C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
E. BACKUP DATABASE COMPRESS

30.AC

教材3-13
6. A, C. The correct methods of compressing a backup are to use the command BACKUP AS
COMPRESSED BACKUPSET DATABASE and to set persistent settings by using CONFIGURE DEVICE
TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET. See Chapter 2 for more information.

Updated at 10:44 PM on Dec. 25, 2008
疑问

1. 3-10
If the target database is in ARCHIVELOG mode, only “current” data files can be backed up (restored data files are made current by recovery).
什么叫"current" data files?

2. 3-17
NOCHECKSUM, CHECK LOGICAL, VALIDATE 是什么意思?
NOCHECKSUM: 备份时不计算数据块的校验值?
CHECK LOGICAL:只检查逻辑错误(比如数据块的内部数据结构有问题?)，不检查物理错误(读不出来?)?
VALIDATE: 假装备份一遍?





-fin-