What are the steps involved in Instance Recovery ?
Answer / guest
Rolling forward to recover data that has not been recorded
in data files, yet has been recorded in the on-line redo
log, including the contents of rollback segments.
Rolling back transactions that have been explicitly rolled
back or have not been committed as indicated by the rollback
segments regenerated in step a.
Releasing any resources (locks) held by transactions in
process at the time of the failure.
Resolving any pending distributed transactions
undergoing a two-phase commit at the time of the instance
failure.
| Is This Answer Correct ? | 4 Yes | 4 No |
What are the applications of rdbms?
What is database partitioning?
What are the types of Calculated columns available ?
What do you understand by ‘atomicity’ and ‘aggregation’?
Explain the role of metadata for the three-layer architecture.
How do I check my drivers?
What file is read by ODBC to load drivers ?
What do you mean by transparent dbms?
What are the properties of a primary key in DBMS?
0 Answers HAL, Honeywell, Zomato,
What is a relation in dbms?
What is flag in database?
What are dml and ddl statements?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)