1z0-043 lesson 5 Database Recovery

做错好多

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


1.
3、One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?
A. drop and re-create the read-only tablespaces
B. rename the read-only data files to their correct file names
C. change the tablespace status from read/write to read-only
D. re-create the read-only tablespace because it is automatically removed

B

B
教材5-35

2.
8、You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?
A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation.
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number (SCN).

D 猜的

C

C:pdf教材8-33
D:教材5-20, 可是只读表空间的scn不就不一样了吗

3.
11、Your database is open and running in ARCHIVELOGmode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employeestable, you receive the following error message:
01578: ORACLE data block corrupted (file # 5, block # 51)
ORA-01110: data file 5:'/u01/app/oracle/oradata/orcl/example01.dbf'
You need to rectify the corruption while ensuring the following:
The data file should remain online.
The mean time to recover (MTTR) should be minimal.
You are not using a backup control file and all the archived logs are accessible.
Which option would you choose?
A. flash back the corrupted blocks
B. use the DBMS_REPAIR package
C. use the RMAN TSPITR command
D. use the RMAN BLOCKRECOVER command
E. use the RESTORE DATABASE and RECOVER DATABASE commands
F. investigate the time at which the corruption occurred and perform a point-in-time recovery

D 猜的

D
这是第7课的内容呀

4.
17. The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?
A. time-based recovery
B. log sequence recovery
C. cancel-based recovery
D. change-based recovery

A

C

A.不能确定具体时间
B.RMAN才能用这种方式 教材5-13
C.教材5-12

5.
18. You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?
A. restore the tablespace from the backup; there is no need to apply the redo information
B. restore the full database to recover the data up to the point when you performed the backup
C. restore the tablespace from the backup and then perform a recovery using the backup control file
D. restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied

C

D
教材5-33

6.
21. Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m. as follows:
SQL> DROP TABLE cust_ord PURGE;
Table dropped.
Client B executes a query at 9:00 a.m. on the same table as follows:
SQL> SELECT * FROM cust_ord;
SELECT * FROM cust_ord
*ERROR at line 1:ORA-00942: table or view does not exist
Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?
A. retrieve the table by using the flashback feature
B. restore all the data files from last Sunday's backup and then perform a time-based recovery
C. restore all the data files from last Sunday's backup and then perform a log sequence recovery
D. restore all the data files from last Sunday's backup and then perform a cancel-based recovery
E. restore from last Sunday's backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery

B

B
教材5-16,5-21

7.
22. You performed an incomplete recovery on your Oracle Database 10g database using the following command:
SQL> RECOVER DATABASE
2 UNTIL TIME '2004-08-05:12:10:03'
3 USING BACKUP CONTROLFILE;
In which situation would the above recovery be required?
A. A user table was lost at the specified time.
B. A redo log file was lost at the specified time.
C. The backup control file is on a faster disk than the current one.
D. The current control file has a different path compared with the intended time of recovery.
E. The current control file does not match the physical structure of the database at the intended time of recovery.

E

E
教材5-11没讲

8.
33. Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery:
RMAN> RUN {
2> SET UNTIL SEQUENCE 230 THREAD 1;
3> ALTER DATABASE MOUNT;
4> RESTORE DATABASE;
5> RECOVER DATABASE;
6> ALTER DATABASE OPEN RESETLOGS;
7> };
With reference to this scenario, which statement is true?
A. RMAN recovers up to log sequence 230, but not including 230.
B. RMAN returns an error because the log sequence number mentioned in the command should be 229.
C. RMAN returns an error because the log sequence number mentioned in the command may never be missing.
D. RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

A

A
教材5-23

9.
34. In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command:
RMAN> RESTORE CONTROLFILE;
Which two operations do you need to perform after restoring the control file from backup? (Choose two.)
A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode

AB

BC
教材5-30

10.
36. Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?

A. You must recover all data files to the required system change number (SCN).
B. You must recover all data files, except those that are offline, to the required SCN.
C. You must recover all data files belonging to the USERS tablespace to the required SCN.
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace.

C 不知道跟UNDO有什么关系

B

C.表空间的时间点的恢复(TSPITR: TableSpace Point-In-Time Recovery)呢?
D.好像跟UNDO没关系

11.
52. The loss of which two types of files may require a recovery with the RESETLOGS option?(Choose two.)
A. control files
B. password file
C. archived log files
D. system-critical data files for which all the redo entries are present
E. non-system-critical data files for which all the redo entries are present

A,C

AC
教材5-30,5-20,5-11

12.
57. You executed the following command in Recovery Manager (RMAN):
RMAN> RESTORE CONTROLFILE;
Which operation must you perform before this command is executed?
A. back up the control file to trace
B. bring database to the MOUNT state
C. open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
D. set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

B

C
教材5-30

D.如果没有catalog才用设置DBID

13.
77. Case 1:
1. Shut down the database and perform a backup.
2. Restore all the data files.
3. Mount the database.
4. Recover the database.
5. Without applying all the redo log files, open the database using the RESETLOGS option.
6. Back up the database.
Case 2:
1. Shut down the database and perform a backup.
2. Restore only the data files of the tablespace where user error damaged the data.
3. Mount the database.
4. Recover the database.
5. Open the database with the RESETLOGS option.
6. Back up the database.
Case 3:
1. Shut down the database.
2. Restore the data files.
3. Open the database.
4. Perform recovery to the current point in time.
Which case has the correct steps for an incomplete recovery?
A. Only case 1
B. Only case 2
C. Only case 3
D. Case 1 and 2
E. Case 2 and 3
F. Case 1 and 3
G. All cases, case 1, case 2, case 3

A

A
教材5-9

14.
99. You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? (Choose two)
A. Restore the lost data file from the backup, and then flash back the database.
B. Restore the data file pertaining to index tablespace, and then recover the tablespace.
C. Restore all the data files, and then perform an incomplete recovery to get the tablespace back.
D. Restore all the data files, and then perform an incomplete recovery using the backup control file.
E. Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.

BE

BE
完全恢复或重建

C不完全恢复会丢失其它数据

15.
100. You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8.30 a.m. With reference to this scenario, what would you do to recover the database?
A. Restore all the data files from last Sunday's backup, and then perform a time-based recovery.
B. Restore all the data files from last Sunday's backup, and then perform a cancel-based recovery.
C. Restore all the data files from last Sunday's backup, and then perform a change-based recovery.
D. Restore only data files that belong to the SYSTEM tablespace from last Sunday's backup, and then perform a complete recovery.

B

B

或者UNTIL SEQUENCE

16.
104. You are using Oracle Database 10g. The log LOG_ARCHIVE_FORMAT parameter is set to 'LOG%t_%_s_%r.dbf'. Why is %r used in the file name format?
A. To uniquely identify the archived log files with the restore operation.
B. To uniquely identify the archived log files with the redo log group number.
C. To uniquely identify the archived log files for each incarnation of the database.
D. To uniquely identify the archived log files with the number of recovery operations performed

C

C
教材5-28

17.
110. Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be able to perform when the database is being accessed by users? (Choose two)
A. Backup of offline tablespaces.
B. Backup of read-only tablespaces.
C. Backup of system-critical tablespaces.
D. Backup of online, locally managed tablespaces.
E. Backup of read/write dictionary-managed tablespaces.

A,B

AB
教材3-10, 不是这课的

18.
115. You used the following command in Recovery Manager (RMAN) as part of the recovery process:
RESTORE CONTROLFILE FROM AUTOBACKUP;
How does RMAN find the control file autobackup? (Choose all the apply)
A. By using the trace file.
B. By using the alert log file.
C. By using the database ID.
D. By using the server parameter file.
E. By using the V$CONTROLFILE view.
F. By using the autobackup format configuration setting.

C,F 做过

CF
第2课解释过

19.
123. For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? (Choose four)
A. RMAN image copies.
B. RMAN database backups.
C. RMAN tablespace backups.
D. User-managed backups placed in the flash recovery area.
E. User-managed backups that have been cataloged with RMAN.
F. User-managed data file backups for which the full path name is specified.

A,B,C,E

ABCE
不清楚,跟是不是incomplete的没关系吧?

20.
124. You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? (Choose two)
A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C. This operation moves all the redo log files to a different location.
D. This operation deletes the old redo log files and creates new redo log files.
E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

B,E

BE

A. datebase scn不变?
B教材5-28
E教材5-20

21.
126. Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two)
A. You find that one of the redo log members in each redo log group is lost.
B. You find that a data file that belongs to the USERS tablespace is damaged.
C. You find that a data file that belongs to the SYSTEM tablespace is damaged.
D. You find that the current redo log group is damaged and is not available for recovery.
E. You realized while performing a recovery that an archived redo log file needed for recovery is lost.

D,E

DE
教材5-12

22.
135. Exhibit, One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8:00 a.m. No full backup has been taken after April 15.What would you do?

A. recover the database until April 10
B. recover the database until April 15
C. recover the database until 22 7:59 a.m.
D. recovery is not possible; manually re-create the object

C 10g好像行?

C
pdf教材8-33
教材5-28:"If you are using Oracle Database 10g, this step is now optional."

23.
153. Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process? (Choose two.)
A. open the database with the RESTRICTED option
B. open the database with the RESETLOGS option
C. recover to the required SCN only that data file in which the error occurred
D. recover all the data files to the same system change number (SCN)

B,D

BD
教材5-20

24.
156. You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?
A. restore the tablespace from the backup, and then perform an incomplete recovery
B. restore the tablespace from the backup, and then apply all the redo information
C. restore all the data files in the database, and then perform an incomplete recovery
D. restore the tablespace from the backup

D

D
教材5-33

25.
157. The loss of the control file forced you to re-create the control file. After re-creating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a five-digit number starting with 0. What could be the possible reason?
A. These are the data files that are corrupted.
B. There is no SYSAUX tablespace in your database
C. There is a read-only tablespace in your database.
D. These are the data files that cannot be recovered.

C

C
教材5-35

26.
158. Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday's backup is the most recent backup available.What would you do in this scenario?
A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday's backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. restore all the files from Sunday's backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
D. restore all the files from Sunday's backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday

D 同第22题

D
同第22题

27.
165. You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?
A. until Thursday morning
B. until that point in time when the database is opened
C. until that point in time when the recovery is performed
D. until last Sunday's backup
E. until that point in time when the table is dropped and purged
F. until Wednesday evening

D

D
只能恢复到上次备份

28.
167.In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file:
1.RESTORE CONTROLFILE;
2.RESTORE DATABASE;
3.ALTER DATABASE MOUNT;
4.SQL ALTER TABLESPACE temp ADD TEMPFILE
5.ALTER DATABASE OPEN RESETLOGS;
6.RECOVER DATABASE;
7.STARTUP NOMOUNT;
In what sequence would you use this process to perform the recovery?
A. 2, 7, 3, 5, 1, 6, 4
B. 2, 1, 7, 6, 3, 5, 4
C. 7, 1, 3, 2, 6, 5, 4
D. 7, 2, 3, 1, 4, 6, 5

C

C
教材5-30,5-35

29.
175. You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?
A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery; status of the tablespace in control file will be changed automatically

D

A
教材5-36
Recovering Read-Only Tablespaces with a Backup Control File: Scenario

30.
180. You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?
A. loss of one of the tablespaces
B. loss of a system data file
C. loss of one of the control files
D. loss of a tempfile
E. loss of the only member of an unarchived redo log group
F. loss of a member from each redo log group

B

E
失误,不应该做错的呀

31.
183. You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID). In which two sources would you find the DBID? (Choose two.)
A. the alert log file
B. the server parameter file
C. the formatted name of a control file autobackup
D. an RMAN session log file
E. the trace file

CD 做过

CD
做过

pdf教材8-6

=====

32.
11. You are faced with a media failure for a tablespace that is currently read-only. The only backup of the read-only tablespace was made one week ago when the tablespace was read-write. What do you have to do to recover this tablespace? (Choose all that apply.)
A. You only need to restore the datafile for this tablespace because the tablespace is read-only.
B. You only need to restore and recover the datafile for this tablespace because the tablespace you have restored is read-write.
C. You only need to restore and recover the datafile for this tablespace because the tablespace has a different SCN in the header.
D. You only need to recover the datafile for this tablespace because the tablespace is read-only.

BC ?

11. B, C. You need to restore and recover the tablespace of the read-only tablespace because the tablespace was read-write when the backup was taken. If the tablespace was backed up read-write, the datafile has changed or has a different SCN in the datafile header. This will require recovery. See Chapter 3 for more information.

教材5-33的案例3
不清楚是怎么恢复的，得做个试验

33.
12. User-managed recovery requires which major difference from using RMAN?
A. User-managed recovery uses the UNTIL SCN clause.
B. User-managed recovery uses the UNTIL SEQUENCE clause.
C. User-managed recovery uses the UNTIL TIME clause.
D. User-managed recovery requires the DBA to directly manage the recovery.

D

12. D. User-managed recovery requires the DBA to directly manage the recovery process. The DBA must determine which database files to restore and from what backup, as well as which archive logs to apply. See Chapter 4 for more information.

A.用户管理的是UNTIL CHANGE, RMAN管理的用的才是UNTIL SCN

34.
13. Why does control file recovery require special steps when using RMAN without the recovery catalog? (Choose all that apply.)
A. Special steps are required when recovering control files because they are not part of the physical database.
B. Special steps are required when recovering control files because they contain RMAN metadata information.
C. Special steps are required when recovering a database when the RMAN repository is not available for that database.
D. Special steps are required when recovering control files because they cannot be easily rebuilt.

B,C

13. B, C. Control files contain the RMAN repository when not using the recovery catalog that contains metadata about the backups that are used to perform the recovery. This information is not available when recovering a control file. See Chapter 4 for more information.

问的不好

35.
14. Logical corruption has been introduced into the database. You need to recover the database to the point-in-time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 P.M. on September 6, 2004.
A. run
{
set until time '06-SEP-2004 6:25:00';
restore database;
recover database;
}
B. run
{
set until time '06-SEP-2004 18:25:00';
recover database;
}
C. run
{
set until time '06-SEP-2004 18:25:00';
restore database;
}
D. run
{
set until time '06-SEP-2004 18:25:00';
restore database;
recover database;
}

D

14. D. The correct RMAN commands would be as follows:
run
{
set until time '06-SEP-2004 18:25:00';
restore database;
recover database;
}
The closest time to 6:30 P.M. would be 18:25. You need to use both the RESTORE DATABASE and RECOVER DATABASE commands. See Chapter 4 for more information.

教材5-21

36.
15. You have a backup from two days ago. It is discovered that corruption was introduced today at 6:30 P.M. You perform an incomplete recovery of the database to 6:25 P.M. before the corruption. One day later you have a media failure, and you need to recover but you only have the same backup that was used to perform an incomplete recovery prior to the corruption. What will happen to the recovery attempt for the media failure?
A. The media recovery will fail because you have performed a RESETLOGS to recover from the corruption and you have not taken another backup after the RESETLOGS operation.
B. The media recovery will be successful because you can perform a RESETLOGS to recover from an incomplete recovery to a new point-in-time greater than the RESETLOGS operation.
C. The media recovery will fail because you always must take a backup following an incomplete recovery with RESETLOGS to open the database.
D. The media recovery will only be successful if you recover the database back to the original time of 6:25 P.M. before the corruption.

B ?

15. B. You can now recover through an incomplete recovery, which uses RESETLOGS to open the database. In previous Oracle versions, you had to take a backup immediately following an incomplete recovery, because the redo log sequences got reset, making the backup unusable. See Chapter 4 for more information.

10g新特性

==

37.
10. What should be updated and readily accessible in case of a non-critical loss of a tablespace?
A. Temporary segments
B. SELECT statements using sorting
C. Current index scripts
D. Create table scripts

C 什么意思?

10. C. The index scripts must be current and stored locally so they can be accessed quickly and easily during an index tablespace rebuild.

修改建索引的脚本,重建索引表空间和索引

38.
11. Which type of tablespace contains static data?
A. Read-only tablespace
B. Index tablespace
C. Read-write tablespace
D. Temporary tablespace

A

11. A. The read-only tablespace contains only static or non-changing data.

教材5-33

39.
12. What is the result of starting an Oracle database with a missing read-only tablespace? (Choose two.)
A. The database opens normally.
B. The database only mounts.
C. An ORA-01157 cannot identify datafile halts the database from opening error occurs.
D. The database functions normally, and the read-only tablespace is static.

A ?

12. B, C. The database will stop at the mount stage. This is due to the ORA-01157 error.

这个也可以试试

40.
19. The main reason that you need to restore and use the RECOVER command on a tablespace that was backed up read-write and converted to read-only is due to what? (Choose all that apply.)
A. The checkpointing process has changed the control file.
B. There have been changes to the tablespace.
C. The tablespace file header has been changed.
D. Read-only tablespaces require the RECOVER command.

A,B,C

19. A, B, C. The scenario of read-write to read-only tablespace requires the use of the RECOVER command, which will apply necessary redo changes to make the tablespace consistent with the control file. The checkpointing operation of Oracle will change the control file, and the header of the read-only tablespace will be modified, which equates to changes in the tablespace.

同前面那几道题
另外，怎么又是恢复一个表空间? 又是TSPITR?

===

41.
1. What is another name for RMAN-based database recovery?
A. User-managed recovery
B. Server-managed recovery
C. Traditional recovery
D. Database recovery

B ?

1. B. Server-managed recovery is another name for RMAN recovery because the server session performs the recovery process as it interacts with the target database.

pdf教材8-4

42.
2. What command is responsible for automating the backup of control files?
A. ALTER DATABASE CONTROLFILE AUTOBACKUP ON
B. ALTER SYSTEM CONTROLFILE AUTOBACKUP ON
C. CONFIGURE CONTROLFILE AUTOBACKUP ON
D. ENABLE CONTROLFILE AUTOBACKUP

C

2. C. The control file autobackup is enabled by setting parameters within RMAN by using CONFIGURE CONTROLFILE AUTOBACKUP ON.

第2课讲过

43.
3. What is the process to recover a control file?
A. Start up database, restore control file, start up mount the database, recover the database, and open the database.
B. Start up mount, restore control file, start up the database, recover the database, and open the database.
C. Start up nomount, restore control file, start up mount the database, recover the database, and open the database.
D. Start up force, restore control file, start up the database, recover the database, and open the database.

C

3. C. The database needs to be started in NOMOUNT mode because there is not a control file available to MOUNT the database. Next, the control file can be restored. Once a restored control file is available, the database can be started in MOUNT mode so that standard database recovery can continue. When recovery is complete, the database can OPEN for normal use.

教材5-30

44.
4. When recovering a control file without the recovery catalog, what special step must be performed to identify the target database? (Choose all that apply.)
A. You must CONNECT TARGET / to the target database within RMAN.
B. You must STARTUP MOUNT the database because the control file is missing.
C. You must SET DBID to the target database so that the target database can be identified without the control file available.
D. You must CONNECT TARGET database name to the target database within RMAN.

A? C

4. A, C. The target database is not identifiable by database name without the control file. So you must first use the CONNECT TARGET / command to connect. The target database needs to be identified by the database identifier (DBID) number with the command SET DBID database identifier. This database identifier number denotes the target database. When you are recovering the control file, the target database identification is not available because it is stored in the control file.

教材5-30,

45.
5. After you restore the control file, what must you do before you execute the RECOVER command to apply archive logs?
A. The database must be restored with the RESTORE command.
B. The database must be reconnected with the CONNECT TARGET database name command.
C. The database must be started in MOUNT mode.
D. The database must open for use with ALTER DATABASE OPEN command.

C

5. C. The database must be mounted before the RECOVER command can be executed. You first must restore control so you can MOUNT the database.

当然了

46.
6. Which of the following methods should you use for creating a control file? (Choose all that apply.)
A. Dump the control file information to a trace file.
B. Use the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command.
C. Use the CREATE CONTROLFILE command.
D. None of the above.

A,B

6. A, B. The ALTER DATABASE BACKUP CONTROL FILE TO TRACE command creates a user trace file, which stores an ASCII representation of the binary control file.

教材5-31
AB说的是一回事

47.
7. What are the two cases defined in the backup control file? (Choose two.)
A. ALTER DATABASE OPEN
B. ALTER DATABASE OPEN RESETLOGS
C. ALTER DATABASE OPEN NORESETLOGS
D. ALTER DATABASE OPEN NORESET

BC

7. B, C. The two cases in the backup control file are opening the database with RESETLOGS or NORESETLOGS.

RESETLOG,NORESETLOGS两种

48.
8. Which files need to be available and in the matching location of the ASCII control file in order to rebuild the control file? (Choose all that apply.)
A. Server file, PFILE or SPFILE
B. Datafiles
C. Control files
D. Redo logs

A,B, D?

8. A, B. The server file, SPFILE or PFILE must be available to start the database with the right parameters, and the datafiles must be in the location matching the control file. The redo logs and control file will be rebuilt.

重做日志文件会被重建

49.
9. Which of the following descriptions best describes incomplete recovery? (Choose all that apply.)
A. Recovery that stops before the failure
B. Recovery that stops at the point of failure
C. Recovery that is missing transactions
D. Recovery that is not missing transactions

ABD?

9. A, C. Incomplete recovery is a recovery that stops before the failure and a recovery that is missing transactions. Incomplete recovery is not complete or missing some data that was previously stored in the database prior to the failure.

教材5-7
B应该是之前
D应该是丢失一些事务

50.
10. What are the required steps to perform a RMAN-based incomplete recovery with the SET UNTIL TIME clause?
A. Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate time with the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with the ALTER DATABASE OPEN command.
B. Start up the database in NOMOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with the ALTER DATABASE OPEN RESETLOGS command.
C. Start up the database in MOUNT mode, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN NORESETLOGS command.
D. Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN RESETLOGS command.

D

10. D. The proper process of performing a RMAN based incomplete recovery utilizing a time stamp to determine the point-in-time to complete the recovery process is as follows: Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable if not present, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN RESETLOGS command.

教材5-21,5-22

51.
11. Which command is not a valid RMAN incomplete recovery run block?
A. run
  {
   set until change 7563633;
   restore database;
   recover database;
  }
B. run
  {
   set until time '06-SEP-2004 11:25:00';
   restore database;
   recover database;
  }
C. run
  {
   set until SCN 7563633;
   restore database;
   recover database;
  }
D. run
  {
   set until sequence 3 thread 1;
   restore database;
   recover database;
  }

C

11. A. The SET UNTIL CHANGE command is not used with RMAN. This command is used during a user-managed incomplete recovery.

教材5-13

52.
12. Which of the following would be a reason for using incomplete recovery? (Choose all that apply.)
A. Stopping the recovery at a certain redo log sequence before a database corruption point
B. Stopping the recovery at a certain time when database corruption occurred
C. Stopping the recovery before a bad transaction is executed
D. Stopping the recovery only after applying all transactions

ABC

12. A, B, C. Incomplete recovery is designed to be able to stop at a desired point, before introducing undesired transactions to the database.

教材5-10
D完全恢复

53.
13. Which incomplete recovery capability is available to RMAN or user-managed methods?
A. SET UNTIL TIME
B. UNTIL TIME
C. UNTIL SCN
D. UNTIL SEQUENCE

B 不知道, 和33题不一样呀

13. B. The UNTIL TIME clause is available in both user-managed and RMAN-based incomplete recovery methods.

同第33题

54.
14. When performing incomplete recovery, which command allows you to stop the recovery process at a random point?
A. UNTIL SEQUENCE, when performing a user-managed recovery
B. UNTIL SCN, when performing a RMAN-based recovery
C. UNTIL CANCEL, when performing a RMAN-based recovery
D. UNTIL CANCEL, when performing a user-managed recovery

C 不知道，什么叫random point?

14. D. The UNTIL CANCEL command is available only in user-managed recovery. This command allows you to stop the recovery process at a random point during redo log switches.

恢复到哪个日志不也是确定的吗

55.
15. Which command is required when performing an incomplete recovery?
A. ALTER DATABASE OPEN RESETLOGS
B. ALTER DATABASE OPEN NORESETLOGS
C. UNTIL CANCEL
D. ALTER DATABASE OPEN

A

15. A. The ALTER DATABASE OPEN RESETLOGS command is required with every incomplete recovery. This is because the redo log sequence always needs to be reset.

教材5-10

56.
16. When using EM to perform a whole database incomplete recovery, what sequence of events must occur? (Choose the best answer.)
A. The database must be shut down and started in NOMOUNT mode.
B. The database must be started in MOUNT mode.
C. The database must be shut down and started in MOUNT mode.
D. The database must be shut down and restarted.

C EM?

16. C. When using EM, the database must be shut down and started in MOUNT mode so that a whole database backup can be performed when you are recovering the same database EM is connected to.

为什么是EM? 用RMAN也要关库,STARTUP MOUNT吧?
pdf教材8-30说可以全库不完全恢复, 还可以表空间，数据文件，归档日志，表的不完全恢复? 教材5-20说必须恢复到一样的SCN. 很矛盾呀

57.
17. Which credentials are needed to perform a recovery with EM? (Choose all that apply.)
A. Database account with SYSDBA privilege
B. Administrator account in Windows
C. Oracle account in Unix
D. Any Windows account

A,B,C

17. A, B, C. You need two credentials when running a recovery with EM: the correct operating system account and the correct database account. The correct operating system account is an account similar to the Oracle account in Unix or the administrator account in Windows. The database account is any account that has SYSDBA privilege.

pdf教材8-27,8-30

58.
18. The RESETLOGS clause is required with which of the following types of incomplete recovery?
A. Using the UNTIL CANCEL command and applying almost all the archived redo logs before cancelling recovery
B. Using the UNTIL TIME command and stopping before the current time
C. Using the SET UNTIL SEQUENCE command and stopping before the last redo log sequence
D. All of the above

D

18. D. The RESETLOGS clause is required with all incomplete recovery options. The RESETLOGS clause is required because you are opening the database to a point prior to the existing redo log entries. So the redo logs must be reset when the database is opened.

是不完全恢复就要RESETLOGS

59.
19. What is required to perform a UNTIL SEQUENCE recovery in RMAN?
A. Identifying the sequence number with V$LOGHISTORY
B. Identifying the sequence number with V$LOG_HISTORY
C. Identifying the SCN number with V$LOG_HISTORY
D. Identifying the SCN number with V$LOGHISTORY

B

19. B. You need to know the redo log sequence number and thread to perform an UNTIL SEQUENCE recovery in RMAN. This can be obtained by querying the V$LOG_HISTORY dynamic view.

教材5-18

60.
20. What is required to recover your database through a RESETLOGS recovery from a backup created prior to the RESETLOGS recovery?
A. NORESETLOGS
B. RESETLOGS
C. UNTIL SEQUENCE
D. Nothing, this feature is automatic.

D

20. D. The new feature to recover your database through a prior RESETLOGS recovery is native with Oracle 10g. Oracle will recover the database through the RESETLOGS prior to recovery if necessary.

10g新特性

疑问:
1.除了10g新特性TSPITR, 可以部分库不完全恢复吗？比如不完全恢复一个表空间(第56题, EM有这些选项)
2.怎么恢复只读表空间? 从读写的变成只读的，怎么恢复？教材5-33的3个案例





-fin-