Q92 Choose the minimum required steps in the correct order to recover the database
Q92. 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.
A. 1, 2, 5, 7, 4, 10
B. 1, 3, 5, 8, 6, 10
C. 1, 3, 5, 6, 10
D. 1, 3, 5, 6, 9
Xem thêm:
- Quản trị index trong postgresql
- Oracle R là gì?
- Lợi Ích và Thách Thức Của Việc Chấp Nhận Bitcoin Trong Thanh Toán
- Q2. While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck
- Oracle Enterprise Manager là gì?
Bài viết cùng chủ đề:
-
Q172. PDB1 and PBD2 are pluggable databases in CDB1 Examine these commands: CDB1 is then restarted Which three are true?
-
Q171. Which two are true about RMAN Multisection backups when a very large data file is divided int four sections?
-
Q170. You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB User-defined objects are stored in several tablespaces in the NON-CDB
-
Q169. Examine the command for creating pluggable database PDB2 in container database CDB2
-
Q168 After a system crash, an instance restart and an attempted opening of the PDBs result in
-
Q167. Which two are true about automatic block repair?
-
Q166. For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command?
-
Q165. Which two are true about server-generated alerts?
-
Q164. Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
-
Q163. Which three are true about Recovery Manager (RMAN) in Oracle Database and later releases?
-
Q162. Which three methods can be used for heap table data migration after upgrading a database?
-
Q161. Which three are true about opatchauto?
-
Q160. Which three are true about Automatic Workload Repository (AWR)?
-
Q159. Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
-
Q158. Which three are true in Oracle 19c and later releases?
-
Q157. Which two are true about RMAN duplexed backup sets?
