26.
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.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| 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. |
27.
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
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| 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. |
28.
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
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| 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. |
29.
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
- Answer & Explanation
- Report
Answer : [A, B, C]
Explanation :
Explanation :
| 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. |
30.
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.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| 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. |
|
|
||||||||||||||||||||||||||||
