1Z0-083 practice question 28 of 35
Choose the best answer. Examine this configuration:1. CDB1 is a container database running in ARCHIVELOG mode.2. Multiple uncommitted transactions…
Full set: 286 questionsChoose the best answer. Examine this configuration:
1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are INACTIVE.
4. Redo log group 3 is the CURRENT group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.
The loss of all members of the CURRENT online redo log group is a critical failure requiring incomplete recovery from a backup. The database must first be shut down abortively (1). Then, it is started and mounted (STARTUP MOUNT) (3) to access the control file. The database files are restored from the last backup (RESTORE DATABASE) (5). Incomplete recovery is performed using RECOVER DATABASE UNTIL AVAILABLE (7), which applies all available archived logs. Since this is an incomplete recovery, the database must be opened with the RESETLOGS option (10) to create a new database incarnation.
A. RECOVER DATABASE NOREDO is an obsolete command and incorrect for this scenario. The database must be opened with RESETLOGS after incomplete recovery.
C. STARTUP NOMOUNT followed by ALTER DATABASE MOUNT is less efficient than a direct STARTUP MOUNT.
D. RECOVER DATABASE NOREDO is the incorrect recovery command for a database in ARCHIVELOG mode.
F. RESTORE ARCHIVELOG is typically handled implicitly by the RECOVER command, and RECOVER DATABASE NOREDO is incorrect.
- Oracle Database Backup and Recovery User's Guide, 19c, Chapter 17, "Performing Incomplete Recovery". This chapter outlines the procedure: "1. After a media failure, shut down the database abort... 2. Start the instance and mount the database... 3. Restore a whole database backup... 4. Perform media recovery... 5. Open the database with the RESETLOGS option...".
- Oracle Database Backup and Recovery Reference, 19c, "RECOVER". The documentation for the RECOVER command describes the UNTIL AVAILABLE clause for incomplete recovery, applying redo until the first missing log.
- Oracle Database SQL Language Reference, 19c, "ALTER DATABASE". The documentation specifies that OPEN RESETLOGS is required after incomplete media recovery.
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
