Answer Posted / shwetha
During normal running of database, dirty buffers are added
to checkpoint queue.Also when a block is first modified it
is entered in the checkpoint queue.The RBA of redo record
is also added.Every 3 sec CKPT records the RBA from
checkpoint queue.In case of instance failure RBA gives the
location from where recovery has to start( Checkpoint
position). During log switch CKPT updates contrl file and
data file headers.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
what is grd?
Can you redefine a table online?
What the different components in replication and what is their use? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is replication? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what are the performance views in an oracle rac environment?
What are the recovery models for a database? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
Why would you call update statistics? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the operating modes in which database mirroring runs? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
