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 is the purpose of normalization in dbms?
What does partition mean in database?
What is data abstraction in dbms?
What are the advantages of a database?
What does <> mean in database?
What is the use of RECORD LENGTH option in EXP command ?
What is alternate key?
What do you understand by unique key?
Define transaction and transaction isolation levels?
If you need to refresh a website page every time a record is updated in database, how would you do it?
What is meant by database system?
What is structure of dbms?
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)