You are in the middle of a transaction updating a very important table. The machine on which a
database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?
A.
The online redo log files and archived redo log files are required to accomplish the recovery
B.
The uncommitted transaction will be committed at the next startup of the database instance
C.
The uncommitted transaction is rolled back automatically at the next opening of the database
D.
The DBA has to perform the recovery on the database to recover the uncommitted transaction
1. First, query table scott.emp
sys @ TEST0924> select * from scott.dept;
DEPTNO DNAME LOC
———- ————– ————-
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
2. Update the table , and does not submit , then simulate power shutdown abort, then restart
sys @ TEST0924> update scott.dept set dname = ‘it’ where deptno = 10;
1 row updated.
sys @ TEST0924> select * from scott.dept;
DEPTNO DNAME LOC
———- ————– ————-
10 it NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
sys @ TEST0924> shutdown abort;
ORACLE instance shut down.
sys @ TEST0924> startup
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size 2230952 bytes
Variable Size 603981144 bytes
Database Buffers 1879048192 bytes
Redo Buffers 20078592 bytes
Database mounted.
Database opened.
3. Run the query again the value has not changed, the rollback occurred. B is wrong.
like question 58