36.
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.
- Answer & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
| The ALTER DATABASE BACKUP CONTROL FILE TO TRACE command creates a user trace file, which stores an ASCII representation of the binary control file. |
37.
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
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
| The two cases in the backup control file are opening the database with RESETLOGS or NORESETLOGS. |
38.
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
- Answer & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
| 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. |
39.
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
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| 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. |
40.
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.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| 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. |
|
|
||||||||||||||||||||||||||||
