I think E - F are correct.
E: Instance recovery is the process of applying records in the online redo log to data files to reconstruct changes made after the most recent checkpoint. Instance recovery occurs automatically when an administrator attempts to open a database that was previously shut down inconsistently.
..
The checkpoint process (CKPT) is responsible for writing checkpoints to the data file headers and control file.
F: Oracle Database can roll back multiple transactions simultaneously as needed. All transactions that were active at the time of failure are marked as terminated. Instead of waiting for the SMON process to roll back terminated transactions, new transactions can roll back individual blocks themselves to obtain the required data.
https://docs.oracle.com/cd/E25178_01/server.1111/e25789/startup.htm
Should be E and F are correct.
D is wrong, SMON rollback transaction after DB is open which make F correct.
After the database has been opened, those uncommitted transactions
are rolled back.
Agre with E
The checkpoint process (CKPT) updates the control file and data file headers with checkpoint information and signals DBWn to write blocks to disk. Checkpoint information includes the checkpoint position, SCN, location in online redo log to begin recovery, and so on.
E, F
"The database can be opened as soon as cache recovery completes"
Cache Recovery- >DB OPen-> Transaction Recovery
Cache Recovery = Roll Forward Redo
Transaction Recovery = rollback segments to undo the uncommitted changes
Agreed D E are correct
to confirm when SMON starts
SQL> shutdown immediate;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: 896876471
Process ID: 0
Session ID: 0 Serial number: 0
SQL> !ps -ef | grep smon | grep -v smon
Note -- Confirmed after shutdown DB, no SMON --
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1124073328 bytes
Fixed Size 9133936 bytes
Variable Size 721420288 bytes
Database Buffers 385875968 bytes
Redo Buffers 7643136 bytes
SQL> !ps -ef | grep smon | grep -v grep
oracle 19323 1 0 23:30 ? 00:00:00 ora_smon_cdb1
Note: -- Database is not in open state yet --
E. During instance recovery, the database must apply the changes that occur between the checkpoint position and the end of the redo thread. Of course CKPT is responsible for updating control files with checkpoint information and also two other activities
F. No comments https://docs.oracle.com/database/121/CNCPT/startup.htm#CNCPT1290 (see the last paragraph after figure 13-6)
D and E.
F is incorrect. SMON does a cleanup upon instance startup, not after.
DBWR is a 'very lazy' background process, but LGWR is more 'awake' and the CKPT process ensures regular checkpoints between LGWR . In short, CKPT overlooks LGWR, which in turn overlooks DBWR. Remember, the control file has the record of the most current checkpoint info, including the SCN.
I think D is incorrect
Rolling backward phase starts after the database has been opened. F is correct.
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/intro004.htm#i1022212
... to make you sure I'm right about C - I've just performed the same test again and it succeed, I also found in alert log:
2021-05-20T17:26:37.896591+02:00
Started redo scan
2021-05-20T17:26:38.374728+02:00
Completed redo scan
Couple of years ago I performed following test - backup control file to trace, shutdown abort (so recovery wil be required), drop all controlfiles, create fresh controlfile using SQL command from trace file, mount, open. It succeed. So you do not need in fact controlfile to perform recovery - it's enough for Oracle to read headers of datafiles and redo logs.
So... C and F.
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Marco_M
Highly Voted 3 years, 7 months agoarpz
3 years, 4 months agojorche
3 years, 4 months agoAldrid
Highly Voted 3 years, 8 months agozenai
Most Recent 2 months, 2 weeks ago_gio_
1 year, 7 months agodancymonkey
11 months, 3 weeks agoG_C
2 years, 3 months agoxsxxxxx
3 years, 4 months agochefdba
3 years, 3 months agoryochin
1 year, 7 months agoNeil107
3 years, 5 months agoKishor123
3 years, 4 months agoniabs
3 years, 6 months agoObserverPL
3 years, 7 months agoObserverPL
3 years, 7 months ago